首先建立一个数据库db_0808，将db_0808中表格student导入网页。
CURD.php
<!DOCTYPE html><html><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 = "ｓｅｌｅｃｔ * 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='ｄｅｌｅｔｅ.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" id="man"><label for="man">男</label> <input type="radio" name="sex" value="0" id="nv"><label for="nv">女</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 = "ｉｎｓｅｒｔ INTO student VALUES (null,'{$name}',{$sex},{$ban},'{$birthday}',DEFAULT,null)"; if ($db->query($sql)){header("location:CURD.php");}else{ header("location:add.php");}添加信息成功
立即学习“PHP免费学习笔记（深入）”；
删除信息ｄｅｌｅｔｅ.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="ｄｅｌｅｔｅ FROM student WHERE Sno='{$id}'";//彻底删除，数据库中内容删除$sql = "ｕｐｄａｔｅ 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 $s = null;if(isset($_GET['id'])){ $id = $_GET['id']; $db=new Mysqli("localhost","root","root","db_0808"); empty(Mysqli_connect_error())?"":die("连接错误"); $sql="ｓｅｌｅｃｔ * from student where Sno='{$id}'"; $r=$db->query($sql);//var_dump($r); $s=$r->fetch_row();}?><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'"; ?> id="nv"><label for="nv">女</label> <input type="radio" name="sex" value="1" <?php echo $s[2]?"checked='checked'":""; ?> id="nan"><label for="nan">男</label> <input type="text" name="banji" placeholder="<?php echo $s[3]?>"> <!-- <input type="text" name="age" placeholder="年龄">--> <input type="text" name="birthday" placeholder="<?php echo $s[4]?>"> <input type="submit" value="提交"></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="ｕｐｄａｔｅ student SET Sname='{$name}',Ssex='{$sex}',class='{$banji}',birthday='{$birthday}'WHERE Sno='{$id}'";//var_dump($sql);if ($db->query($sql)){ header("location:CURD.php");}
免责声明：本站内容仅用于学习参考，信息和图片素材来源于互联网，如内容侵权与违规，请联系我们进行删除，我们将在三个工作日内处理。联系邮箱：chuangshanghai#qq.com（把#换成@）