Detailed explanation of paging, worry-free pagination (PHP+mysql)_PHP tutorial

All the codes I posted are original and have been used in multiple projects. I often use php+mysql paging code

Copy the code The code is as follows:

$perpagenum = 10;//Define how many items are displayed on each page
$total = mysql_fetch_array(mysql_query("select count(*) from a"));/ /Query how many pieces of data there are in the database
$Total = $total[0];                                                       !isset($_GET['page'])||!intval($_GET['page'])||$_GET['page']>$Totalpage)//Four possible states of page
{
$page=1;
}
else
{
$page=$_GET['page'];//If the above four conditions are not met, the value of page is $ _GET['page']
}
$startnum = ($page-1)*$perpagenum;//Start number
$sql = "select * from a order by id limit $startnum,$ perpagenum";//Query the required number of items
echo $sql."
";
$rs = mysql_query($sql);
$contents = mysql_fetch_array($rs);
if($total) If $total is not empty, execute the following statement
{
do
{
$id = $contents['id'];
$name = $contents ['name'];
?>



($rs));//do....while
$per = $page - 1;//Previous page
$next = $page + 1;//Next page
echo "There are ".$Total." records in total, ".$perpagenum." records in each page, and a total of ".$Totalpage." pages ";
if($page != 1)
{
echo "Homepage";
echo " Previous page";
}
if($page != $Totalpage)
{
echo " Next page";
echo " Last page";
}
}
else if $total is empty, output No message
{
echo "No message";
}
?>





http://www.bkjia.com/PHPjc/318581.html

www.bkjia.com

true
http: //www.bkjia.com/PHPjc/318581.html

TechArticle

All the codes I posted are original and used in multiple projects. I often use php+mysql for pagination The code copy code is as follows: ?php $perpagenum=10; //Define how many items are displayed on each page...

Statement：

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

Previous article：[PHP] Practical functions 4_PHP tutorialNext article：[PHP] Practical functions 4_PHP tutorial

Related articles

See more

• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• How to use cURL to implement Get and Post requests in PHP
• All expression symbols in regular expressions (summary)

Public welfare online PHP training，Help PHP learners grow quickly！

About usDisclaimerSitemap

© php.cn All rights reserved

id:
< ;?php echo $id;?>
                                         $name;?>