在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
首先建立一个数据库db_0808,将db_0808中表格student导入网页。 CURD.php <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>Title</title> </head> <body> <?php $db = new Mysqli("localhost","root","root","db_0808"); //!$db?"":die("链接错误"); empty(mysqli_connect_error())?"":die("链接错误"); $sql = "select * from student where is_delete='0'"; //$data = $db->query($sql)->fetch_all();//索引数组形式的所有数据 ?> <table border="1"> <tr> <td>id</td> <td>名字</td> <td>性别</td> <td>班级</td> <td>生日</td> <td>操作</td> </tr> <?php $result=$db->query($sql); while ($data=$result->fetch_row()){ //索引数组形式的第一条数据 // foreach ($data as $i){ if ($data[2]==1){ $data[2]="男"; }else if ($data[2]==0){ $data[2]="女"; }else{ $data[2]="保密"; } echo "<tr> <td>{$data[0]}</td> <td>{$data[1]}</td> <td>{$data[2]}</td> <td>{$data[3]}</td> <td>{$data[4]}</td> <td><a href='delete.php?id={$data[0]}'>删除</a> <a href='xiugai.php?id={$data[0]}'>修改</a> </td> </tr>"; } ?> </table> <a href="add.php">新增用户</a> </body> </html>
向数据库中添加新信息add.php <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <form method="post" action="addpost.php"> <input type="text" name="name" placeholder="姓名"> <input type="radio" name="sex" value="1" >男</label> <input type="radio" name="sex" value="0" >女</label> <input type="text" name="banji" placeholder="班级"> <!-- <input type="text" name="age" placeholder="年龄">--> <input type="text" name="birthday" placeholder="出生年月"> <input type="submit" value="提交"> </form> </body> </html>
对add.php信息处理addpost.php <?php /** * Created by fcc * User: Administrator * Date: 2017/10/13 * Time: 15:49 */ $name = $_POST['name']; //var_dump($name); $sex = $_POST['sex']; $ban=$_POST['banji']; //$age = $_POST['age']; $birthday = $_POST['birthday']; $db=new Mysqli("localhost","root","root","db_0808"); $sql = "INSERT INTO student VALUES (null,'{$name}',{$sex},{$ban},'{$birthday}',DEFAULT,null)"; if ($db->query($sql)){ header("location:CURD.php"); }else{ header("location:add.php"); } 添加信息成功 删除信息delete.php <?php /** * Created by fcc * User: Administrator * Date: 2017/10/14 * Time: 10:56 */ $id=$_GET['id']; $db=new Mysqli("localhost","root","root","db_0808"); empty(mysqli_connect_error())?"":die("链接错误"); //$sql="DELETE FROM student WHERE Sno='{$id}'";//彻底删除,数据库中内容删除 $sql = "update student set is_delete = '1' where Sno= '{$id}'";//表面删除,数据库中内容仍存在 if ($db->query($sql)){ header("location:CURD.php"); };
更改信息页面xiugai.php <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <?php <form method="post" action="xiugaichuli.php"> <input type="hidden" name="id" value="<?php echo $s[0]?>"> <input type="text" name="name" placeholder="<?php echo $s[1]?>"> <input type="radio" name="sex" value="0" <?php echo $s[2]?"":"checked='checked'"; ?> > </form> </body> </html> 更改信息处理页面xiugaichuli.php <?php /** * Created by fcc * User: Administrator * Date: 2017/10/17 * Time: 9:07 */ $id=$_POST['id']; $name=$_POST['name']; $sex=$_POST['sex']; $banji=$_POST['banji']; $birthday=$_POST['birthday']; $db=new Mysqli("localhost","root","root","db_0808"); empty(Mysqli_connect_error())?"":"连接错误"; $sql="UPDATE student SET Sname='{$name}',Ssex='{$sex}',class='{$banji}',birthday='{$birthday}'WHERE Sno='{$id}'"; //var_dump($sql); if ($db->query($sql)){ header("location:CURD.php"); }
|
2022-08-17
2022-11-06
2022-08-15
2022-08-18
2022-08-16
请发表评论