PDO实现学生管理系统
这里实现一个简单的学生管理系统,供大家参考,具体内容如下
需要建立如下文件:
- index.php
- menu.php //菜单栏
- add.php //添加数据
- edit.php // 编辑数据
- action.php // 添加,删除,编辑的实现
分别写一下每个文件的代码:
menu.php:
<html> <h2>学生信息管理</h2> <a href="index.php" rel="external nofollow" >浏览学生</a> <a href="add.php" rel="external nofollow" >增加学生</a> <hr> </html>
index.php
<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
<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
<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
<?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; }
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持我们。
赞 (0)