Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > PHP simple paging principle and paging code examples

PHP simple paging principle and paging code examples

WBOY

Release： 2016-07-25 08:52:49

Original

2080 people have browsed it

/*******Page Principle*************/
//Display the number of records per page
$page_size = 3;
$sql = "select * from message";
$result = mysql_query($sql);
//Total number of records
$num = mysql_num_rows($result);
//Calculation of total number of pages
if($num<= $page_size) { $page_count =1; }
if($num%$page_size) { $page_count = intval($num/$page_size)+1;}
if($num%$page_size==0) { $page_count = $num/$page_size ;}
if( isset($_GET['page']) ){
$page = intval($_GET['page']);
}
else{
$page = 1;
}
$sql_page= "select * from message limit ".($page-1)*$page_size.",$page_size";
$do = mysql_query($sql_page);
while( $re = mysql_fetch_object($ do)){
echo 'Write anything you want';
}
if($page<>1){
echo 'Homepage';
echo 'Previous page';
}
if($page<>$page_count){
echo '
';
echo 'Next page';
echo 'Last Night';
echo '< /div>';
}

Copy code

Related labels：

php简单分页原理与分页代码示例

source：php.cn

Previous article：PHP paging principle analysis and PHP paging code design Next article：PHP simple paging code to learn PHP paging principles

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn