当前位置:Gxlcms > php框架 > php学生管理系统

php学生管理系统

时间:2021-07-01 10:21:17 帮助过:11人阅读

本文实例为大家分享了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('确认删除?')) {
    window.location='action.php?action=del&id='+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('connection failed'.$e->getMessage());
  }
  //2.执行sql
  $sql_select = "select * from stu";
  //3.data 解析
  foreach ( $pdo->query($sql_select) as $row) {
   echo "<tr>";
   echo "<th>{$row['id']} </th>";
   echo "<th>{$row['name']}</th>";
   echo "<th>{$row['sex']} </th>";
   echo "<th>{$row['age']} </th>";
   echo "<th>{$row['classid']}</th>";
   echo "<td>
     <a href='edit.php?id={$row['id']}'>修改</a>
     <a href='javascript:void(0);' onclick='doDel({$row['id']})'>删除</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 ('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="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 'Connection failed: ' . $e->getMessage();
 die('connection failed'.$e->getMessage());
}
 
//2.action 的值做对操作
 
switch ($_GET['action']){
  
 case 'add'://add 
  $name = $_POST['name'];
  $sex = $_POST['sex'];
  $age = $_POST['age'];
  $classid = $_POST['classid'];
   
  $sql = "insert into stu (name, sex, age, classid) values ('{$name}', '{$sex}','{$age}','{$classid}')";
  $rw = $pdo->exec($sql); 
  if ($rw > 0){
   echo "<script>alter('添加成功');</script>";
  }else{
   echo "<script>alter('添加失败');</script>";
  }
  header('Location: index.php');
  break; 
  
 case 'del'://get
  $id = $_GET['id'];
  $sql = "delete from stu where id={$id}";
  $rw = $pdo->exec($sql);
  if ($rw > 0){
   echo "<script>alter('删除成功');</script>";
  }else{
   echo "<script>alter('删除失败');</script>";
  }
  header('Location: index.php');
  break;
 
 case 'edit'://post
  $id = $_POST['id'];
  $name = $_POST['name']; 
  $age = $_POST['age'];
  $classid = $_POST['classid'];
  $sex = $_POST['sex'];
   
//  echo $id, $age, $age, $name;
  $sql = "update stu set name='{$name}', age={$age},sex='{$sex}',classid={$classid} where id={$id};";
//  $sql = "update myapp.stu set name='jike',sex='女', age=24,classid=44 where id=17";
  print $sql;
  $rw = $pdo->exec($sql);
  if ($rw > 0){
   echo "<script>alter('更新成功');</script>";
  }else{
   echo "<script>alter('更新失败');</script>";
  }
  header('Location: index.php');
  break; 
  
 default:
  header('Location: index.php');
  break;
}

4.edit.php

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

更多学习资料请关注专题《管理系统开发》。

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

人气教程排行