PHP+Mysql development of paging and preparation before making paging

Preparation before making paging

Before making paging, first build the database and enter the data

Create a bbs2 in the database table, import the following sql statement.

CREATE TABLE `test` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) character set utf8 NOT NULL,
`sex` varchar(2) character set utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

I won’t explain much here.

Then pour the data content

INSERT INTO `test` (`id`, `name`, `sex`) VALUES
(1, '张三', '男'),
(2, '李四', '女'),
(3, '王五', '男'),
(4, '赵六', '女'),
(5, '小七', '男'),
(6, '小八', '男'),
(7, '小九', '男'),
(8, '小十', '女'),
(9, '小十一', '男');

If you want to add more, you can copy and paste to add. In this way, we have built the database used for paging