欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

php實(shí)現(xiàn)學(xué)生管理系統(tǒng)

 更新時間：2020年03月21日 12:53:24   作者：hyhlinux  
這篇文章主要為大家詳細(xì)介紹了php學(xué)生管理系統(tǒng)的具體實(shí)現(xiàn)代碼，文中示例代碼介紹的非常詳細(xì)，具有一定的參考價值，感興趣的小伙伴們可以參考一下

本文實(shí)例為大家分享了php學(xué)生管理系統(tǒng)源碼，供大家參考，具體內(nèi)容如下

功能：

1.添加／刪除／修改
2.數(shù)據(jù)存儲.

界面分布：

index.php --->主界面
add.php --->stu添加
action ---> sql中add/del/update (處理html表單-->mysql的數(shù)據(jù)存儲 ＆＆ 頁面跳轉(zhuǎn))
edit.php --->stu修改
menu.php -->首頁

1. index.php

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="UTF-8">
 <title>學(xué)生信息管理</title>
 <script>
 function doDel(id) {
  if(confirm('確認(rèn)刪除?')) {
  window.location='action.php?action=del&id='+id;
  }
 }
 </script>
</head>
<body>
<center>
 <?php
 include ("menu.php");
 ?>
 <h3>瀏覽學(xué)生信息</h3>
 <table width="500" border="1">
 <tr>
  <th>ID</th>
  <th>姓名</th>
  <th>性別</th>
  <th>年齡</th>
  <th>班級</th>
  <th>操作</th>
 </tr>
 <?php
// 1. 鏈接數(shù)據(jù)庫
 try{
  $pdo = new PDO("uri:mysqlPdo.ini","root","1");
 }catch (PDOException $e) {
  die('connection failed'.$e->getMessage());
 }
 //2.執(zhí)行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>學(xué)生管理系統(tǒng)</title>
</head>
<body>
<center>
 
 <?php include ('menu.php'); ?>
 <h3>增加學(xué)生信息</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>&nbsp;</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. 鏈接數(shù)據(jù)庫
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>學(xué)生管理系統(tǒng)</title>
</head>
<body>
<center>
 <?php include ('menu.php');
 //1. 鏈接數(shù)據(jù)庫
 try{
 $pdo = new PDO("uri:mysqlPdo.ini","root","1");
 }catch (PDOException $e) {
 die('connection failed'.$e->getMessage());
 }
 //2.執(zhí)行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); // 解析數(shù)據(jù)
 }else{
 die("no have this id:{$_GET['id']}");
 }
 ?>
 
 <h3>修改學(xué)生信息</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>&nbsp;</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>學(xué)生管理系統(tǒng)</h2>
 <a href="index.php"> 瀏覽學(xué)生</a>
 <a href="add.php"> 添加學(xué)生</a>
 <hr>
</body>
</html>

更多學(xué)習(xí)資料請關(guān)注專題《管理系統(tǒng)開發(fā)》。

以上就是本文的全部內(nèi)容，希望對大家的學(xué)習(xí)有所幫助，也希望大家多多支持腳本之家。

相關(guān)文章

最新評論