当前位置:Gxlcms > PHP教程 > php数据库增删改查方式

php数据库增删改查方式

时间:2021-07-01 10:21:17 帮助过:17人阅读

首先建立一个数据库db_0808,将db_0808中表格student导入网页。

CURD.php

  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="utf-8">
  5. <title>Title</title>
  6. </head>
  7. <body>
  8. <?php
  9. $db = new Mysqli("localhost","root","root","db_0808");
  10. //!$db?"":die("链接错误");
  11. empty(mysqli_connect_error())?"":die("链接错误");
  12. $sql = "select * from student where is_delete='0'";
  13. //$data = $db->query($sql)->fetch_all();//索引数组形式的所有数据
  14. ?>
  15. <table border="1">
  16. <tr>
  17. <td>id</td>
  18. <td>名字</td>
  19. <td>性别</td>
  20. <td>班级</td>
  21. <td>生日</td>
  22. <td>操作</td>
  23. </tr>
  24. <?php
  25. $result=$db->query($sql);
  26. while ($data=$result->fetch_row()){ //索引数组形式的第一条数据
  27. // foreach ($data as $i){
  28. if ($data[2]==1){
  29. $data[2]="男";
  30. }else if ($data[2]==0){
  31. $data[2]="女";
  32. }else{
  33. $data[2]="保密";
  34. }
  35. echo "<tr>
  36. <td>{$data[0]}</td>
  37. <td>{$data[1]}</td>
  38. <td>{$data[2]}</td>
  39. <td>{$data[3]}</td>
  40. <td>{$data[4]}</td>
  41. <td><a href='delete.php?id={$data[0]}'>删除</a>
  42. <a href='xiugai.php?id={$data[0]}'>修改</a>
  43. </td>
  44. </tr>";
  45. }
  46. ?>
  47. </table>
  48. <a href="add.php">新增用户</a>
  49. </body>
  50. </html>

向数据库中添加新信息add.php


  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>Title</title>
  6. </head>
  7. <body>
  8. <form method="post" action="addpost.php">
  9. <input type="text" name="name" placeholder="姓名">
  10. <input type="radio" name="sex" value="1" id="man"><label for="man">男</label>
  11. <input type="radio" name="sex" value="0" id="nv"><label for="nv">女</label>
  12. <input type="text" name="banji" placeholder="班级">
  13. <!-- <input type="text" name="age" placeholder="年龄">-->
  14. <input type="text" name="birthday" placeholder="出生年月">
  15. <input type="submit" value="提交">
  16. </form>
  17. </body>
  18. </html>

对add.php信息处理addpost.php


  1. <?php
  2. /**
  3. * Created by fcc
  4. * User: Administrator
  5. * Date: 2017/10/13
  6. * Time: 15:49 */$name = $_POST['name'];//
  7. var_dump($name);
  8. $sex = $_POST['sex'];
  9. $ban=$_POST['banji'];//
  10. $age = $_POST['age'];
  11. $birthday = $_POST['birthday'];
  12. $db=new Mysqli("localhost","root","root","db_0808");
  13. $sql = "INSERT INTO student VALUES (null,'{$name}',{$sex},{$ban},'{$birthday}',DEFAULT,null)";
  14. if ($db->query($sql)){header("location:CURD.php");
  15. }else{ header("location:add.php");
  16. }

添加信息成功

删除信息delete.php


  1. <?php/**
  2. * Created by fcc
  3. * User: Administrator
  4. * Date: 2017/10/14
  5. * 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");
  6. };

更改信息页面xiugai.php


  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>Title</title>
  6. </head>
  7. <body>
  8. <?php
  9. $s = null;if(isset($_GET['id'])){
  10. $id = $_GET['id'];
  11. $db=new Mysqli("localhost","root","root","db_0808");
  12. empty(Mysqli_connect_error())?"":die("连接错误");
  13. $sql="select * from student where Sno='{$id}'";
  14. $r=$db->query($sql);//var_dump($r);
  15. $s=$r->fetch_row();
  16. }?>
  17. <form method="post" action="xiugaichuli.php">
  18. <input type="hidden" name="id" value="<?php echo $s[0]?>">
  19. <input type="text" name="name" placeholder="<?php echo $s[1]?>">
  20. <input type="radio" name="sex" value="0" <?php echo $s[2]?"":"checked='checked'"; ?> id="nv"><label for="nv">女</label>
  21. <input type="radio" name="sex" value="1" <?php echo $s[2]?"checked='checked'":""; ?> id="nan"><label for="nan">男</label>
  22. <input type="text" name="banji" placeholder="<?php echo $s[3]?>">
  23. <!-- <input type="text" name="age" placeholder="年龄">-->
  24. <input type="text" name="birthday" placeholder="<?php echo $s[4]?>">
  25. <input type="submit" value="提交">
  26. </form>
  27. </body>
  28. </html>

更改信息处理页面xiugaichuli.php

  1. <?php
  2. /**
  3. * Created by fcc
  4. * User: Administrator
  5. * Date: 2017/10/17
  6. * Time: 9:07
  7. */
  8. $id=$_POST['id'];
  9. $name=$_POST['name'];
  10. $sex=$_POST['sex'];
  11. $banji=$_POST['banji'];
  12. $birthday=$_POST['birthday'];
  13. $db=new Mysqli("localhost","root","root","db_0808");
  14. empty(Mysqli_connect_error())?"":"连接错误";
  15. $sql="UPDATE student SET Sname='{$name}',Ssex='{$sex}',class='{$banji}',birthday='{$birthday}'WHERE Sno='{$id}'";
  16. //var_dump($sql);
  17. if ($db->query($sql)){
  18. header("location:CURD.php");
  19. }

以上就是php数据库增删改查方式的详细内容,更多请关注Gxl网其它相关文章!

人气教程排行