Provide an example classification function, friends in need can refer to it.
//page paging function
$page = $_get["page"];
function page($rows,$page_size){
global $page,$select_from,$select_limit,$pagenav;
$page_count = ceil($rows/$page_size);
if($page <= 1 || $page == '') $page = 1;
if($page >= $page_count) $page = $page_count;
$select_limit = $page_size;
$select_from = ($page - 1) * $page_size.',';
$pre_page = ($page == 1)? 1 : $page - 1;
$next_page= ($page == $page_count)? $page_count : $page + 1 ;
$pagenav . = "$page/$page_count page with $rows records";
$pagenav .= "Homepage ";
$pagenav .= "Previous page ";
$pagenav .= "After One page ";
$pagenav .= "Last page";
$pagenav.=" Jump to
Look at the database structure below
Create a new database test
Execute the following statement (create a new table test: three fields of id, sex, name)
create table `test` (
`id` int( 4 ) not null auto_increment primary key ,
`sex` int( 1 ) not null ,
`name` varchar( 20 ) not null ) engine = myisam character set utf8 collate utf8_bin;
Add data to the test table, for example:
1 1 Xiaoqiang
2 0 Xiaohong
3 0 Xiaoli
4 1 Xiaobing
5 1 Zhang San
6 0 Li Si
7 0 Wu Xin
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
