id int not null primary key auto_increment,
title varchar(200) not null comment '标题',
content text...comment '内容'
);
insert into articles(title, content) values ('Laravel 测试1', 'Laravel 测试文章内容1'),
('...Laravel 测试2', 'Laravel 测试文章内容2'),
('Laravel 测试3', 'Laravel 测试文章内容3');
从 Mysql 读取数据
1
2
3
4
5...6
7
8
9
10
11
12
try {
$db = new PDO('mysql:host=127.0.0.1;dbname=test', 'root', 'root');
...$sql = 'select * from articles';
$query = $db->prepare($sql);
$query->execute();
$lists = $query