在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
修改 1、首先,建立一个修改页面(edit.php),加入表单(也可与增加页面的表单同用) <?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']?>"> 班级: <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、成功^-^
|
2022-08-15
2022-08-17
2022-11-06
2022-08-17
2022-07-18
请发表评论