PHP连接mysql数据库进行增删改查--修稿数据
<?php
$id = $_GET['id'];
$db = new Mysqli("localhost","root","root","student");
$sql = "select * from student.student WHERE Sno = {$id}";
$result = $db->query($sql);
$date = $result->fetch_assoc();
//var_dump($date);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form method="post" action="editpost.php">
<input type="hidden" name="Sno" placeholder="id" value="<?php echo $date['Sno']?>">
姓名：<input type="text" name="Sname" placeholder="姓名" value="<?php echo $date['Sname']?>" >
性别：
<input type="radio" name="Ssex" value="1" <?php if ($date['Ssex'] == 1){echo 'checked';}?> id="man"><label for="man">男</label>
<input type="radio" name="Ssex" value="0" <?php if ($date['Ssex'] == 0){echo 'checked';}?> id="woman"><label for="woman">女</label>
出生年月:
<input type="text" name="Sbirthday" placeholder="出生年月" value="<?php echo $date['Sname']?>">
班级or组:
<input type="text" name="Class" placeholder="班级" value="<?php echo $date['Class']?>">
<input type="submit" value="确认修改">
</form>
</body>
</html>
2、建立一个之前写到的需要作出修改动作的页面（文件名为：editpost.php）
<?php
$id = $_POST['Sno'];
$name = $_POST['Sname'];
$sex = $_POST['Ssex'];
$birthday = $_POST['Sbirthday'];
$class = $_POST['Class'];
$db = new Mysqli("localhost","root","root","student");
$sql = "update student set Sname='{$name}',Ssex='{$sex}',Sbirthday='{$birthday}',Class='{$class}' WHERE Sno='{$id}'";
if ($db->query($sql)){
header("location:crud.php");
}
之后就可以进行测试了！
测试一下：
1、在首页点击修改（选择修改ID：111行）
2、可以成功提取 id 及 信息，就是地址栏的这个信息！
3、对内容进行修改
4、点击确认看一下
5、成功^-^
