php实现简单增删改查:test.php是主页,insert.php是添加页,del.php是删除页。
sql代码
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
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
Title
姓名性别年龄操作
|