php登录页面：
|
1
2
3
4
5
6
|
<h1>登录界面</h1> <form action="dengluchuli.php" method="post"> 用户名：<input type="text" name="uid"/> 密码：<input type="text" name="pwd"/> <input type="submit" value="登录" /></form> |
其中 dengluchuli.php在规定路径下。
登录跳转页面：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
<?php $yonghuming = $_POST["uid"]; $mima = $_POST["pwd"]; $db = new mysqli("localhost","root","","12345"); $sql = "select password from login where username='{$yonghuming}'"; $result = $db->query($sql); $atter = $result->fetch_row(); if($atter[0]==$mima && !empty($mima)) { header("location:xinxi.php"); } else { echo "用户名或密码错误"; }?> |
此页面用于登录界面登录成功后通过用户名找到相应的数据。
登录主界面：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
<?php$de = new mysqli("localhost","root","","12345");$e="select * from info";$result = $de->query($e);$atter = $result->fetch_all();echo "<table border=1>";echo "<tr> <td>代号</td> <td>姓名</td> <td>性别</td> <td>民族</td> <td>出生日期</td> <td>操作</td> </tr> ";for($i=0;$i<count($atter);$i++){ echo "<tr>"; for($j=0;$j<count($atter[$i]);$j++) { if($j==4) { echo "<td>".$atter[$i][$j]."</td> <td><a href='shanchu.php?code={$atter[$i][1]}' onclick="return confirm('确定删除？')"> 删除</a></td>"; } else { echo "<td>".$atter[$i][$j]."</td>"; } } echo "</tr>";}echo " </table>";echo "<a href='tianjia.php'>添加数据</a>"?> |
添加数据（tianji.php）：
|
1
2
3
4
5
6
7
8
9
|
<h1>添加数据</h1> <form action="zeng.php" method="post"> 代号：<input type="text" name="daihao" /> <br /> 姓名：<input type="text" name="xinming" /><br /> 性别：<input type="text" name="xinbie" /><br /> 民族：<input type="text" name="minzu" /><br /> 生日：<input type="text" name="shengri" /><br /> <input type="submit" value="提交"/> </form> |
zeng.php ：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<?php $code = $_POST["daihao"]; $name = $_POST["xinming"]; $sex = $_POST["xinbie"]; $nation = $_POST["minzu"]; $birthday = $_POST["shengri"]; $db = new mysqli("localhost","root","","12345"); $sql = "insert into info values('{$code}','{$name}','{$sex}','{$nation}','{$birthday}')"; $r = $db->query($sql); if($r) { header("location:xinxi.php"); } else { echo "添加失败"; }?> |
添加成功：
shanchu.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
<?php $name = $_GET["code"]; $db = new mysqli("localhost","root","","12345"); $sql = "delete from info where name='{$name}'"; $result = $db->query($sql); if($result) { header("location:xinxi.php"); } else { echo "删除失败"; }?> |
修改数据：
在xinxi.php文件中插入代码：
|
1
|
<a href='xiugai.php?code={$atter[$i][1]}'>修改</a> |
相同路径下新建xiugai.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
<?php $name = $_GET["code"]; $db = new mysqli("localhost","root","","12345"); $sql = "select * from info where name='{$name}'"; $r = $db->query($sql); $atter = $r->fetch_row(); ?><h1>修改</h1> <form action="xiugaichuli.php" method="post"> <input type="hidden" name="daihao" value="<?php echo $atter[0]; ?>" /> <br /> 姓名： <input type="text" name="xinming" value="<?php echo $atter[1]; ?>"/> <br /> 性别： <input type="text" name="xinbie" value="<?php echo $atter[2]; ?>"/> <br /> 民族： <input type="text" name="minzu" value="<?php echo $atter[3]; ?>"/> <br /> 生日： <input type="text" name="shengri" value="<?php echo $atter[4]; ?>"/> <br /> <input type="submit" value="修改" /> </form> |
相同路径下新建xiugaichuli.php
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<?php $code = $_POST["daihao"]; $name = $_POST["xinming"]; $sex = $_POST["xinbie"]; $nation = $_POST["minzu"]; $birthday = $_POST["shengri"]; $db = new mysqli("localhost","root","","12345"); $sql = "update info set name='{$name}',sex={$sex},nation='{$nation}',birthday='{$birthday}' where code='{$code}'"; $r = $db->query($sql); if($r) { header("location:xinxi.php"); } else { echo "修改失败"; }?> |
点击修改其中一条数据：
