老雷php全栈开发课程之php+mysql的curd实现
mysql是最流行的开源数据库
php+mysql是一对绝配
php连接mysql可以使用mysqli 、pdo 、mysql。
推荐大家使用mysqli。
本教程也都是基于mysqli讲解的。
教程参考:php手册 mysqli
//创建guest表 CREATE TABLE `sky_guest` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) DEFAULT '' COMMENT '主题', `userid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户id', `catid` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '类型', `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态', `telephone` varchar(15) NOT NULL, `email` varchar(50) DEFAULT '0' COMMENT '邮箱', `qq` varchar(15) NOT NULL DEFAULT '' COMMENT 'QQ', `createtime` datetime NOT NULL DEFAULT '2019-01-17 08:08:01' COMMENT '留言时间', `content` text COMMENT '留言内容', `reply_content` text COMMENT '回复内容', `reply_time` datetime NOT NULL DEFAULT '2019-01-17 08:08:01' COMMENT '回复时间', `nickname` varchar(16) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `catid` (`catid`), KEY `userid` (`userid`,`id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='留言板';
<?php $mysqli = new mysqli("localhost", "root", "123", "laoleiphp"); $mysqli->query("set names utf8"); $a=isset($_GET["a"])?htmlspecialchars($_GET["a"]):"default"; switch($a){ case "create": //插入数据 $sql="insert sky_guest set title='测试数据',createtime='".date("Y-m-d H:i:s")."',catid=1 "; $mysqli->query($sql); $id=$mysqli->insert_id; echo "create::".$id; break; case "update": //更新数据 $id=intval($_GET["id"]); $sql="update sky_guest set title='测试数据',createtime='".date("Y-m-d H:i:s")."',catid=2 where id=".$id; $mysqli->query($sql); echo "update"; break; case "list": //查询数据 $sql="SELECT * from sky_guest"; $res = $mysqli->query($sql); $row = $res->fetch_all(MYSQLI_ASSOC); echo "读取列表"; print_r($row); break; case "read": //查询数据 $id=intval($_GET["id"]); $sql="SELECT * from sky_guest where id=".$id; $res = $mysqli->query($sql); $row = $res->fetch_all(MYSQLI_ASSOC); echo "读取详情"; print_r($row); break; case "delete": //删除 $sql="delete from sky_guest limit 1"; $mysqli->query($sql); echo "delete"; break; default: echo "php连接mysql数据的实现"; break; } //查询一条id $sql="SELECT * from sky_guest limit 1"; $res = $mysqli->query($sql); $row = $res->fetch_array(); ?> <style> a{ font-size: 18px; margin: 20px; } </style> <br /> <a href="index.php?a=create">Create</a> <a href="index.php?a=update&id=<?=$row["id"]?>">Update</a> <a href="index.php?a=read&id=<?=$row["id"]?>">Read</a> <a href="index.php?a=list">Read List</a> <a href="index.php?a=delete">Delete</a>