前言
基于PHP在用户注册时的动态增加、删除以及修改和管理员后台的管理。(软件为appserv)
https://pan.baidu.com/s/1zjdzVDvWD6K1t4a9qbsAPw
密码:cr31
注:下面案例仅供参考
一、web交互
二、管理员创建数据库
在http://127.0.0.1:8888/phpmyadmin页面中的数据库中创建一个名为db_users的数据库,再在该数据库中创建一个名为tb_users的表。
表结构如下:
三、页面代码
add.Form.htm<center>
<font color="red" size="7">注册信息</font><br />
<form method="post" action="addUser.php">
用户名:<input type="text" name="fUserName" /><br />
密码:<input type="password" name="fUserPWD" /><br />
性别:<input type="radio" name="fGender" value="男" />男
<input type="radio" name="fGender" value="女" />女
<br>
爱好:
<input type="checkbox" name="fHobby[]" value="蹦极">蹦极
<input type="checkbox" name="fHobby[]" value="滑雪">滑雪
<input type="checkbox" name="fHobby[]" value="街舞">街舞
<input type="checkbox" name="fHobby[]" value="轮滑">轮滑
<br>
年龄:
<select name="fAge">
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
</select>
<br>
<input type="submit" value="提交">
</form>
</center>
index.php
<?php
ob_start();
date_default_timezone_set("Asia/Shanghai");
$conn=mysql_connect("localhost","root","123456");
mysql_query("set names 'utf8'");
mysql_select_db("db_users",$conn);
$result=mysql_query("select * from tb_users",$conn);
?>
<table border="1" align="center">
<caption>用户信息</caption>
<tr>
<th>序号</th>
<th>用户名</th>
<th>密码</th>
<th>性别</th>
<th>爱好</th>
<th>年龄</th>
<th>删除操作</th>
<th>更新操作</th>
</tr>
<?php
$i=1;
while($row=mysql_fetch_assoc($result)){
?>
<tr>
<td><?=$i?></td>
<td><?=$row['UserName']?></td>
<td><?=$row['UserPWD']?></td>
<td><?=$row['Gender']?></td>
<td><?=$row['Hobby']?></td>
<td><?=$row['Age']?></td>
<td><a href="delUser.php?ID=<?=$row['ID']?>">删除记录</a></td>
<td><a href="modUserForm.php?ID=<?=$row['ID']?>">修改密码</a></td>
</tr>
<?php
$i++;
}
?>
</table>
<center>
<p><a href="addForm.htm">继续注册新用户</a></p>
</center>
addUser.php
<?php
ob_start();
date_default_timezone_set("Asia/Shanghai");
$conn=mysql_connect("localhost","root","123456");
mysql_query("set names 'utf8'");
mysql_select_db("db_users",$conn);
$vUserName=$_POST["fUserName"];
$vUserPWD=$_POST["fUserPWD"];
$vGender=$_POST["fGender"];
$vHobbys="";
$vHobby=$_POST["fHobby"];
for($i=0;$i<count($vHobby);$i++)
$vHobbys=$vHobbys.$vHobby[$i]. " ";
$vAge=$_POST["fAge"];
$sql="insert into tb_users(UserName,UserPWD,Gender,Hobby,Age) values
('$vUserName','$vUserPWD','$vGender','$vHobbys','$vAge')";
mysql_query($sql) or die('执行失败');
?>
<center>
<p><?=$vUserName?>注册成功!</p>
<p><a href="index.php">查看用户信息</a></p>
</center>
delUser.php
<?php
ob_start();
date_default_timezone_set("Asia/Shanghai");
$conn=mysql_connect("localhost","root","123456");
mysql_query("set names 'utf8'");
mysql_select_db("db_users",$conn);
$ID=intval($_GET['ID']);
$sql="delete from tb_users where ID=$ID";
if(mysql_query($sql)&&mysql_affected_rows()==1)
echo "<script>alert('该用户已被删除!');location.href='index.php'</script>";
else
echo "<script>alert('删除失败!';location.href='index.php'</script>";
?>
modUser.php
<?php
ob_start();
date_default_timezone_set("Asia/Shanghai");
$conn=mysql_connect("localhost","root","123456");
mysql_query("set names 'utf8'");
mysql_select_db("db_users",$conn);
$ID=intval($_GET['ID']);
$vUserName=$_POST["fUserName"];
$vUserPWD=$_POST["fUserPWD"];
$sql="update tb_users set UserPWD='$vUserPWD' where ID=$ID";
mysql_query($sql) or die('执行失败');
?>
<center>
<p><?=$vUserName?>的密码修改成功!</p>
<p><a href="index.php">查看用户信息</a></p>
</center>
modUserForm.php
<?php
ob_start();
date_default_timezone_set("Asia/Shanghai");
$conn=mysql_connect("localhost","root","123456");
mysql_query("set names 'utf8'");
mysql_select_db("db_users",$conn);
$ID=intval($_GET['ID']);
$sql="select * from tb_users where ID=$ID";
$result=mysql_query($sql,$conn);
$row=mysql_fetch_assoc($result);
?>
<center>
修改用户密码
<form method="post" action="modUser.php?ID=<?=$row['ID']?>">
<p>用户名:<?=$row['UserName']?></p>
<input type="hidden" name="fUserName" value="<?=$row['UserName']?>">
<p>密码:<input type="text" name="fUserPWD" value="<?=$row['UserPWD']?>"></p>
<p><input type="submit" value="修改" /></p>
</form>
</center>