在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
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; 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>
|
2022-08-18
2022-08-17
2022-07-18
2022-08-18
2022-07-29
请发表评论