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;
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>
