欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

php学生管理系统

程序员文章站 2024-02-23 14:41:04
本文实例为大家分享了php学生管理系统源码,供大家参考,具体内容如下 功能: 1.添加/删除/修改 2.数据存储. 界面分布: index.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('确认删除?')) {
    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>

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

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