Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > PHP simple paging code to learn PHP paging principles

PHP simple paging code to learn PHP paging principles

WBOY

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

Original

1099 people have browsed it

include("conn.php"); //Database link, solve it yourself
$sql="select * from news";
$query=mysql_query($ sql);
$all_num=mysql_num_rows($query); //Total number of items
$page_num=3; //Number of items per page
$page_all_num = ceil($all_num/$page_num); //Total number of pages
$ page=empty($_GET['page'])?1:$_GET['page']; //Current page number
$page=(int)$page; //Safe forced conversion
$limit_st = ($page -1)*$page_num; //Start number
//===php paging code key
$sql="select * from news limit $limit_st, $page_num";
$ query=mysql_query($sql);
while($row=mysql_fetch_array($query)){
echo $row['title']." Browse
";
}
$px = $page>=$page_all_num ? $page_all_num : $page+1 ;
$ps = $page<=1 ? 1 : $page-1 ;
?>
Homepage |
Previous page |
Next page |
Last page

Copy code

Related labels：

php简单分页代码学习php分页原理

source：php.cn

Previous article：PHP simple paging principle and paging code examples Next article：What’s going on with software development and product managers?

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