php简单实现增删改查

php实现简单增删改查：test.php是主页，insert.php是添加页，del.php是删除页。

sql代码

DROP TABLE IF EXISTS `bnk_test2`;
CREATE TABLE `bnk_test2`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
  `sex` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
  `age` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of bnk_test2
-- ----------------------------
INSERT INTO `bnk_test2` VALUES (3, '王五', '男', 20);
INSERT INTO `bnk_test2` VALUES (4, '李1', '女', 17);
INSERT INTO `bnk_test2` VALUES (5, '王2', '男', 20);
INSERT INTO `bnk_test2` VALUES (6, '王3', '女', 22);
INSERT INTO `bnk_test2` VALUES (7, '王4', '男', 23);
INSERT INTO `bnk_test2` VALUES (8, '李二', '女', 18);
INSERT INTO `bnk_test2` VALUES (9, '李二1', '男', 14);
INSERT INTO `bnk_test2` VALUES (10, '李二1', '女', 14);
INSERT INTO `bnk_test2` VALUES (12, '李二', '男', 31);

SET FOREIGN_KEY_CHECKS = 1;
View Code

 test.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <form action="" method="post" name="indexf">
        <P align="center"><input type="button" value="新增" name="inbut" onclick="location.href='insert.php'"></P>
        <p align="center"><input type="text" name="sel" ><input type="submit" value="搜索" name="selsub"></p>
        <table align="center" border="1px" cellpadding="0px" width="800px">
            <tr><th>姓名</th><th>性别</th><th>年龄</th><th>操作</th></tr>
<?php
    session_start();
    if (isset($_SESSION['success'])){
        echo '<p align="center">'.$_SESSION['success'].'<p>';
        unset($_SESSION['success']);
    }
    $link = mysqli_connect('localhost:3306', 'root', '', 'school');
    if(!$link){
        exit('数据库连接');
    }
    if (empty($_POST["selsub"])){
        $res = mysqli_query($link,"select * from bnk_test2 order by id");//全部结果
    }else{
        $sel = $_POST["sel"];
        $res = mysqli_query($link,"select * from bnk_test2 where name like '%$sel%' or sex like '%$sel%' or age like '%$sel%'");//搜索出来的结果集
    }
    while($row = mysqli_fetch_array($res)){
        echo '<tr align="center">';
        echo "<td>$row[1]</td><td>$row[2]</td><td>$row[3]</td>
               <td>
               <input type='submit' name='upsub$row[0]' value='修改'>
               <input type='submit' name='delsub$row[0]' value='删除'>
              </td>
             ";
        echo '</tr>';
        if(!empty($_POST["upsub$row[0]"])){
            echo '<tr align="center">';
            echo "<td><input type='text' name='upname' value='$row[1]'> </td>                   
                  <td><input type='text' name='upsex' value='$row[2]'> </td>                   
                  <td><input type='text' name='upage' value='$row[3]'> </td>                                   
                  <td><input type='submit' value='确认修改' name='upsubs$row[0]'> </td>";
            echo '</tr>';
        }
        if(!empty($_POST["upsubs$row[0]"])){
            $upname = $_POST['upname'];
            $upsex = $_POST['upsex'];
            $upage = $_POST['upage'];
            mysqli_query($link,"update bnk_test2 set name='$upname',sex='$upsex',age='$upage' where id=$row[0]");
            header('location:#');
        }
        if(!empty($_POST["delsub$row[0]"])){
            $_SESSION['del'] = $row[0];
            echo '<script>
                if (confirm("是否删除") == true){
                    location.href = "del.php";
                }
                </script>';

        }
    }
?>
        </table>
    </form>
</body>
</html>

insert.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <h1 align="center">添加学生记录</h1>
    <form action="" method="post" name="inf">
        <p align="center">姓名<input type="text" name="name"></p>
        <p align="center">性别<input type="text" name="sex"></p>
        <p align="center">年龄<input type="text" name="age"></p>
        <p align="center"><input type="submit" value="submit" name="insub"></p>
    </form>
<?php
    session_start();
    $link = mysqli_connect('localhost:3306', 'root', '', 'school');
    if(!$link){
        exit('数据库连接');
    }
    if(!empty($_POST["insub"])){
        $name = $_POST['name'];
        $sex = $_POST['sex'];
        $age = $_POST['age'];
        mysqli_query($link,"insert bnk_test2 (name,sex,age) values ('$name','$sex',$age)");
        $_SESSION['success'] = '添加成功';
        header('location:test.php');
    }
?>
</body>
</html>

del.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<?php
    $link = mysqli_connect('localhost:3306', 'root', '', 'school');
    if (!$link){
        exit('数据库连接失败');
    }
    session_start();//开启缓存
    $del = $_SESSION['del'];//获取session
    mysqli_query($link,"delete from bnk_test2 where id = $del");
    unset( $_SESSION['del']);//删除
    header('location:test.php');
?>
</body>
</html>

 

posted @ 2021-08-18 16:59  树之下  阅读(2302)  评论(0)    收藏  举报