PHP開發 學生管理系統之修改學生訊息
建立 edit.php 修改檔案
#將資料庫裡的資訊以指定的格式讀取出來做出對應的修改（使用HTML和PHP混編），再把新的資料存放到資料庫裡
#程式碼如下
##edit.php檔案程式碼
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>学生管理系统</title>
</head>
<body>
<?php include ('menu.php');
//1. 链接数据库
header("content-type:text/html;charset=utf8");
$conn=mysqli_connect("localhost","root","root","study");
mysqli_set_charset($conn,"utf8");
$id=$_GET['id'];
//2.执行sql
$sql_select = "select * from stu where id='$id'";
$stmt = mysqli_query($conn,$sql_select);
// var_dump($stmt);
// die();
if ($stmt>0) {
$stu = mysqli_fetch_assoc($stmt); // 解析数据
}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="class" value="<?php echo $stu['class']?>"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" value="修改"></td>
<td><input type="reset" value="重置"></td>
</tr>
</table>
</form>
</body>
</html>再將修改頁面修改的資料重新提交到資料庫
程式碼如下
<?php
header("content-type:text/html;charset=utf8");
$conn=mysqli_connect("localhost","root","root","study");
mysqli_set_charset($conn,"utf8");
$id = $_POST['id'];
$name = $_POST['name'];
$age = $_POST['age'];
$class = $_POST['class'];
$sex = $_POST['sex'];
$sql = "update stu set name='$name', age='$age',sex='$sex',class='$class' where id='$id';";
$rw = mysqli_query($conn,$sql);
if ($rw > 0){
echo "<script>alert('修改成功');</script>";
}else{
echo "<script>alert('修改失败');</script>";
}
header('Location: index.php');
?>這樣就把我們的修改功能完成了，下一步就是我們的刪除功能了
<body>
<meta charset="UTF-8">
<title>登陆界面</title>
<h2>学生管理系统</h2>
<a href="index.php"> 浏览学生</a>
<a href="add.php"> 添加学生</a>
<hr>
<h3>修改学生信息</h3>
<form action="action.php?action=edit" method="post">
<input name="id" value="3" type="hidden">
<table>
<tbody><tr>
<td>姓名</td>
<td><input name="name" value="刘奇" type="text"></td>
</tr>
<tr>
<td>年龄</td>
<td><input name="age" value="12" type="text"></td>
</tr>
<tr>
<td>性别</td>
<td>
<input name="sex" value="男" checked="" type="radio">男
</td>
<td>
<input name="sex" value="女" type="radio">女
</td>
</tr>
<tr>
<td>班级</td>
<td><input name="class" value="五年级" type="text"></td>
</tr>
<tr>
<td> </td>
<td><input value="修改" type="submit"></td>
<td><input value="重置" type="reset"></td>
</tr>
</tbody></table>
</form>
</body>
