Rumah >pembangunan bahagian belakang >tutorial php >php实现学生管理系统

php实现学生管理系统

不言asal: 2018-06-12 17:32:4322660semak imbas

这篇文章主要为大家详细介绍了php学生管理系统的具体实现代码，感兴趣的小伙伴们可以参考一下

本文实例为大家分享了php学生管理系统源码，供大家参考，具体内容如下

功能：
1.添加／删除／修改
2.数据存储.
界面分布：
index.php --->主界面
add.php --->stu添加
action ---> sql中add/del/update (处理html表单-->mysql的数据存储＆＆页面跳转)
edit.php --->stu修改
menu.php -->首页

1. index.php

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="UTF-8">
 <title>学生信息管理</title>
 <script>
  function doDel(id) {
   if(confirm(&#39;确认删除?&#39;)) {
    window.location=&#39;action.php?action=del&id=&#39;+id;
   }
  }
 </script>
</head>
<body>
<center>
 <?php
 include ("menu.php");
 ?>
 <h3>浏览学生信息</h3>
 <table width="500" border="1">
  <tr>
   <th>ID</th>
   <th>姓名</th>
   <th>性别</th>
   <th>年龄</th>
   <th>班级</th>
   <th>操作</th>
  </tr>
  <?php
//  1. 链接数据库
  try{
   $pdo = new PDO("uri:mysqlPdo.ini","root","1");
  }catch (PDOException $e) {
   die(&#39;connection failed&#39;.$e->getMessage());
  }
  //2.执行sql
  $sql_select = "select * from stu";
  //3.data 解析
  foreach ( $pdo->query($sql_select) as $row) {
   echo "<tr>";
   echo "<th>{$row[&#39;id&#39;]} </th>";
   echo "<th>{$row[&#39;name&#39;]}</th>";
   echo "<th>{$row[&#39;sex&#39;]} </th>";
   echo "<th>{$row[&#39;age&#39;]} </th>";
   echo "<th>{$row[&#39;classid&#39;]}</th>";
   echo "<td>
     <a href=&#39;edit.php?id={$row[&#39;id&#39;]}&#39;>修改</a>
     <a href=&#39;javascript:void(0);&#39; onclick=&#39;doDel({$row[&#39;id&#39;]})&#39;>删除</a>
    </td>";
   echo "</tr>";
  }
  ?>
 </table>
</center>
</body>
</html>

2. add.php

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="UTF-8">
 <title>学生管理系统</title>
</head>
<body>
<center>
 
 <?php include (&#39;menu.php&#39;); ?>
 <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="text" name="age"></td>
   </tr>
   <tr>
    <td>性别</td>
    <td><input type="radio" name="sex" value="男">男</td>
    <td><input type="radio" name="sex" value="女">女</td>
   </tr>
   <tr>
    <td>班级</td>
    <td><input type="text" name="classid"></td>
   </tr>
   <tr>
<!--    <td> </td>-->
    <td><a href="index.php">返回</td>
    <td><input type="submit" value="添加"></td>
    <td><input type="reset" value="重置"></td>
   </tr>
  </table> 
 </form>
  
</center>
</body>
</html>

3. action.php

<?php
/**
 * Created by PhpStorm.
 * User: hyh
 * Date: 16-7-7
 * Time: 下午9:37
 */
//1. 链接数据库
try{
 $pdo = new PDO("uri:mysqlPdo.ini","root","1");
}catch (PDOException $e) {
//   echo &#39;Connection failed: &#39; . $e->getMessage();
 die(&#39;connection failed&#39;.$e->getMessage());
}
 
//2.action 的值做对操作
 
switch ($_GET[&#39;action&#39;]){
  
 case &#39;add&#39;://add 
  $name = $_POST[&#39;name&#39;];
  $sex = $_POST[&#39;sex&#39;];
  $age = $_POST[&#39;age&#39;];
  $classid = $_POST[&#39;classid&#39;];
   
  $sql = "insert into stu (name, sex, age, classid) values (&#39;{$name}&#39;, &#39;{$sex}&#39;,&#39;{$age}&#39;,&#39;{$classid}&#39;)";
  $rw = $pdo->exec($sql); 
  if ($rw > 0){
   echo "<script>alter(&#39;添加成功&#39;);</script>";
  }else{
   echo "<script>alter(&#39;添加失败&#39;);</script>";
  }
  header(&#39;Location: index.php&#39;);
  break; 
  
 case &#39;del&#39;://get
  $id = $_GET[&#39;id&#39;];
  $sql = "delete from stu where id={$id}";
  $rw = $pdo->exec($sql);
  if ($rw > 0){
   echo "<script>alter(&#39;删除成功&#39;);</script>";
  }else{
   echo "<script>alter(&#39;删除失败&#39;);</script>";
  }
  header(&#39;Location: index.php&#39;);
  break;
 
 case &#39;edit&#39;://post
  $id = $_POST[&#39;id&#39;];
  $name = $_POST[&#39;name&#39;]; 
  $age = $_POST[&#39;age&#39;];
  $classid = $_POST[&#39;classid&#39;];
  $sex = $_POST[&#39;sex&#39;];
   
//  echo $id, $age, $age, $name;
  $sql = "update stu set name=&#39;{$name}&#39;, age={$age},sex=&#39;{$sex}&#39;,classid={$classid} where id={$id};";
//  $sql = "update myapp.stu set name=&#39;jike&#39;,sex=&#39;女&#39;, age=24,classid=44 where id=17";
  print $sql;
  $rw = $pdo->exec($sql);
  if ($rw > 0){
   echo "<script>alter(&#39;更新成功&#39;);</script>";
  }else{
   echo "<script>alter(&#39;更新失败&#39;);</script>";
  }
  header(&#39;Location: index.php&#39;);
  break; 
  
 default:
  header(&#39;Location: index.php&#39;);
  break;
}

4.edit.php

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="UTF-8">
 <title>学生管理系统</title>
</head>
<body>
<center>
 <?php include (&#39;menu.php&#39;);
 //1. 链接数据库
 try{
  $pdo = new PDO("uri:mysqlPdo.ini","root","1");
 }catch (PDOException $e) {
  die(&#39;connection failed&#39;.$e->getMessage());
 }
 //2.执行sql
 $sql_select = "select * from stu where id={$_GET[&#39;id&#39;]}";
 $stmt = $pdo->query($sql_select);
 if ($stmt->rowCount() >0) {
  $stu = $stmt->fetch(PDO::FETCH_ASSOC); // 解析数据
 }else{
  die("no have this id:{$_GET[&#39;id&#39;]}");
 }
 ?>
  
 <h3>修改学生信息</h3>
 
 <form action="action.php?action=edit" method="post">
  <input type="hidden" name="id" value="<?php echo $stu[&#39;id&#39;];?>">
  <table>
   <tr>
    <td>姓名</td>
    <td><input type="text" name="name" value="<?php echo $stu[&#39;name&#39;];?>"></td>
   </tr>
   <tr>
    <td>年龄</td>
    <td><input type="text" name="age" value="<?php echo $stu[&#39;age&#39;];?>"></td>
   </tr>
   <tr>
    <td>性别</td>
    <td>
     <input type="radio" name="sex" value="男" <?php echo ($stu[&#39;sex&#39;] == "男")? "checked":"";?> >男
    </td>
    <td>
     <input type="radio" name="sex" value="女" <?php echo ($stu[&#39;sex&#39;] == "女")? "checked":"";?> >女
    </td>
   </tr>
   <tr>
    <td>班级</td>
    <td><input type="text" name="classid" value="<?php echo $stu[&#39;classid&#39;]?>"></td>
   </tr>
   <tr>
    <td> </td>
    <td><input type="submit" value="更新"></td>
    <td><input type="reset" value="重置"></td>
   </tr>
  </table>
 </form>
  
  
</center>
 
<?php
?>
</body>
</html>

5. menu.php

<!DOCTYPE html>
<html lang="en">
<body>
 <h2>学生管理系统</h2>
 <a href="index.php"> 浏览学生</a>
 <a href="add.php"> 添加学生</a>
 <hr>
</body>
</html>

以上就是本文的全部内容，希望对大家的学习有所帮助，更多相关内容请关注PHP中文网！

Artikel berkaitan

Lihat lagi