这里实现一个简单的学生管理系统，供大家参考，具体内容如下
需要建立如下文件：
- index.php
- menu.php //菜单栏
- add.php //添加数据
- edit.php // 编辑数据
- action.php // 添加，删除，编辑的实现
分别写一下每个文件的代码：
menu.php:
|
1
2
3
4
5
6
|
<html><h2>学生信息管理</h2><a href="index.php" rel="external nofollow" >浏览学生</a><a href="add.php" rel="external nofollow" >增加学生</a><hr></html> |
index.php
|
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
<html> <head> <meta charset="UTF-8"> <title>学生信息管理系统</title> </head> <script> function doDel(id){ if(confirm("是否要删除")){ window.location='action.php?action=del&id='+id; } } </script> <body> <center> <?php include("menu.php");?> <h3>浏览学生信息</h3> <table width="600" border="1"> <tr> <th>ID</th> <th>姓名</th> <th>姓别</th> <th>年龄</th> <th>班级</th> <th>操作</th> </tr> <?php //1. 连接数据库 try{ $pdo = new PDO("mysql:host=localhost;dbname=myapp;", "root", ""); }catch(PDOException $e){ die("fail to connect db".$e->getMessage()); } //2. 执行数据库，并解析遍历 $sql = "SELECT * FROM users"; foreach($pdo->query($sql) as $val){ echo "<tr>"; echo "<td>{$val['id']}</td>"; echo "<td>{$val['name']}</td>"; echo "<td>{$val['sex']}</td>"; echo "<td>{$val['age']}</td>"; echo "<td>{$val['class']}</td>"; echo "<td> <a href='javascript:doDel({$val['id']})'>删除</a> <a href='edit.php?id={$val['id']}'>修改</a> </td>"; echo "</tr>"; } ?> </table> </center> </body></html> |
add.php
|
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
<html><head> <meta charset="UTF-8"> <title>学生信息管理系统</title></head><body><center> <?php include("menu.php");?> <h3>增加学生信息</h3> <form action="action.php?action=add" method="post"> <table> <tr> <td>姓名</td> <td><input type="text" name="name"/></td> </tr> <tr> <td>姓别</td> <td> <input type="radio" name="sex" value="m"/>男 <input type="radio" name="sex" value="w"/>女 </td> </tr> <tr> <td>年龄</td> <td><input type="text" name="age"/></td> </tr> <tr> <td>班级</td> <td><input type="text" name="class"/></td> </tr> <tr> <td> </td> <td> <input type="submit" value="增加"/> <input type="submit" value="重置"/> </td> </tr> </table> </form></center></body></html> |
edit.php
|
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
<html><head> <meta charset="UTF-8"> <title>学生信息管理系统</title></head><body><center> <?php include("menu.php"); //获取修改信息 //1. 连接数据库 try{ $pdo = new PDO("mysql:host=localhost;dbname=myapp;", "root", ""); }catch(PDOException $e){ die("fail to connect db".$e->getMessage()); } //2. 拼装sql语句，取出信息 $sql = "SELECT * FROM users WHERE id=".$_GET['id']; $stmt = $pdo->query($sql); if($stmt->rowCount() > 0){ $stu = $stmt->fetch(PDO::FETCH_ASSOC); //解析数据 }else{ die("没有修改的信息"); } ?> <h3>修改学生信息</h3> <form action="action.php?action=edit" method="post"> <!-- 以隐藏域的方式添加id --> <input type="hidden" name="id" value="<?php echo $stu['id']; ?>"> <table> <tr> <td>姓名</td> <td><input type="text" name="name" value="<?php echo $stu['name'];?>"/></td> </tr> <tr> <td>姓别</td> <td> <input type="radio" name="sex" value="m" <?php echo ($stu['sex']== "m")? "checked": ""; ?>/>男 <input type="radio" name="sex" value="w" <?php echo ($stu['sex']== "w")? "checked": ""; ?>/>女 </td> </tr> <tr> <td>年龄</td> <td><input type="text" name="age" value="<?php echo $stu['age'];?>"/></td> </tr> <tr> <td>班级</td> <td><input type="text" name="class" value="<?php echo $stu['class'];?>"/></td> </tr> <tr> <td> </td> <td> <input type="submit" value="修改"/> <input type="submit" value="重置"/> </td> </tr> </table> </form></center></body></html> |
action.php
|
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
<?php//1. 连接数据库try{ $pdo = new PDO("mysql:host=localhost;dbname=myapp;", "root", ""); }catch(PDOException $e){ die("fail to connect db".$e->getMessage());}//2. 通过action的值做相应的操作switch($_GET['action']){ case "add": //增加操作 $name = $_POST['name']; $sex = $_POST['sex']; $age = $_POST['age']; $class = $_POST['class']; $sql = "INSERT INTO users VALUES (null, '{$name}','{$sex}', '{$age}', '{$class}')"; $rw = $pdo->exec($sql); if($rw > 0){ echo "<script>alert('增加成功'); window.location='index.php'</script>"; }else{ echo "<script>alert('增加失败'); window.history.back()</script>"; } break; case "del": $id = $_GET['id']; $sql = "DELETE FROM users WHERE id={$id}"; $pdo->exec($sql); header("location:index.php"); break; case "edit": $name = $_POST['name']; $sex = $_POST['sex']; $age = $_POST['age']; $class = $_POST['class']; $id = $_POST['id']; $sql = "UPDATE users SET name='{$name}',sex='{$sex}',age={$age},class={$class} WHERE id={$id}"; $rw = $pdo->exec($sql); if($rw > 0){ echo "<script>alert('修改成功'); window.location='index.php'</script>"; }else{ echo "<script>alert('修改失败'); window.history.back()</script>"; } break;} |
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。
原文链接：https://blog.csdn.net/thystar/article/details/47381819
