Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Home > Backend Development > PHP Tutorial > body text

PHP simple paging principle and paging code examples

WBOY

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

Original

1787 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