PHP连接mysql数据库进行增删改查--修稿数据

最新推荐文章于 2021-04-05 05:20:49 发布

T869634492

最新推荐文章于 2021-04-05 05:20:49 发布

阅读量152

点赞数

文章标签： php 数据库

原文链接：http://www.cnblogs.com/GP1014336455/p/7704970.html

版权

<?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']?>" > &nbsp;&nbsp;性别： <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> &nbsp;&nbsp;出生年月: <input type="text" name="Sbirthday" placeholder="出生年月" value="<?php echo $date['Sname']?>"> &nbsp;&nbsp;班级or组: <input type="text" name="Class" placeholder="班级" value="<?php echo $date['Class']?>"> &nbsp;&nbsp; <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"); }