本文实例为大家分享了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>
更多学习资料请关注专题《管理系统开发》。
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持网页设计。
