这里实现一个简单的学生管理系统,供大家参考,具体内容如下
需要建立如下文件:
- 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