<?php //本地测试 $host = '127.0.0.1'; $port = 3306; $user = "root"; $pwd = ""; $link = @mysql_connect("{$host}:{$port}",$user,$pwd,true); if(!$link) { die("Connect Server Failed: " . mysql_error()); } //选择连接的数据库库名 mysql_select_db("my"); //设置字符编码utf8 mysql_set_charset('utf8'); ?>
2.注册页面（html页面）
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head> <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" /> <title>Document</title> </head> <body> <h3>注册页面</h3> <form action="add.php" method='post'> <table cellpadding='0' cellspacing='0' bgcolor='#ABCDEF'> <tr> <td>用户名</td> <td><input type="text"/>以小写字母开始，长度要求5~10</td> </tr> <tr> <td>密码</td> <td><input type="password"/>密码不能为空</td> </tr> <tr> <td>邮箱</td> <td><input type="text" /></td> </tr> <tr> <td>性别</td> <td> <input type="radio" value='1' />男 <input type="radio" value='2' />女 <input type="radio" value='3' />保密 </td> </tr> <tr> <td>个人简介</td> <td> <textarea cols="50" rows="10"></textarea> </td> </tr> <tr> <td colspan='2'><input type="submit" value='注册' /></td> </tr> </table> </form> </body> </html>
3.将注册数据显示在数据库
//往数据库中添加数据 <?php header("Content-type:text/html; charset=utf-8"); //-----------------------连接数据库--------------------------- include_once "connect.php"; //-------------------------将数据连接到数据库------------------ $time=time(); $sql="insert into user (username,password,email,sex,txt,`time`) value('{$_POST['username']}','{$_POST['password']}','{$_POST['email']}','{$_POST['sex']}','{$_POST['txt']}','{$time}')"; $res=mysql_query($sql); header("location:hello.php"); ?>
4.返回后台界面
<?php header("Content-type:text/html; charset=utf-8"); //-----------------------连接数据库------------------------------ include_once "connect.php"; //--------------------查询数据库-------------------------------- $query="select * from user"; $result=mysql_query($query); if(!$result) { die("could not to the database<br/>".mysql_error()); } //-------------------封装函数----------------------------- //该函数将数据库的数据写成数组形式 function result2Arr($result){ while($result_row=mysql_fetch_assoc($result)){ $arr[] = $result_row; } return $arr; } $arr = result2Arr($result); foreach($arr as $key=>$value){ echo "<table>"; echo "<table >"; echo "<tr> "; echo "<td>".$value['id']."</td>"; echo "<td>".$value['username']."</td>"; echo "<td>".$value['password']."</td>"; echo "<td>".$value['email']."</td>"; echo "<td>".$value['sex']."</td>"; echo "<td>".$value['txt']."</td>"; echo "<td>".date('Y-m-d H:i:s',$value['time'])."</td>"; echo "<td><a href='update1.php?id=$value[id]'>修改</a> <a href='delete.php?id=$value[id]'>删除</a></td>"; echo "<tr/>"; echo "</table>"; } ?>
5.修改数据
//当用户要修改信息时，返回页面，页面中包含之前填写的信息 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head> <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" /> <title>Document</title> </head> <body> <div> <?php include_once "connect.php"; $sql="select * from user whereid']."'"; //echo "sql:".$sql;(显示出修改哪一行) $result=mysql_query($sql,$link); $arr = result2Arr($result); //print_r($arr); $row = $arr[0]; function result2Arr($result){ while($result_row=mysql_fetch_assoc($result)){ $arr[] = $result_row; } return $arr; } ?> <h3>注册页面</h3> <form action="update.php" method='post'> <input type="hidden" value="<?php echo $row['id']?>"/> <table cellpadding='0' cellspacing='0' bgcolor='#ABCDEF'> <tr> <td>用户名</td> <td><input type="text" value="<?php echo $row['username']?>"/>以小写字母开始，长度要求5~10</td> </tr> <tr> <td>密码</td> <td><input type="password"value="<?php echo $row['password']?>"/>密码不能为空</td> </tr> <tr> <td>邮箱</td> <td><input type="text" value="<?php echo $row['email']?>"/></td> </tr> <tr> <td>性别</td> <td> <input type="radio" value='1' <?php if($row['sex']=='1'){ echo 'checked';}?>/>男 <input type="radio" value='2' <?php if($row['sex']=='2'){ echo 'checked';}?>/>女 <input type="radio" value='3' <?php if($row['sex']=='3'){ echo 'checked';}?>/>保密 </td> </tr> <tr> <td>个人简介</td> <td> <textarea cols="50" rows="10"><?php echo $row['txt']?></textarea> </td> </tr> <tr> <td colspan='2'><input type="submit" value='修改' /></td> </tr> </table> </form> </div> </body> </html>
