PDO实现学生管理系统-巨人网络通讯

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=delid='+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;
}

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。

您可能感兴趣的文章: