Principle analysis of php+mysql paging query code

　

　　　

　　

　　< ?php

　　do {

　　　$i++;

　　　?>

　　

　　

　　

　　　　}

　while ($myrow = mysql_fetch_array ($rs));

　　echo "

$pagesize=10; //Set the number of records displayed on each page $conn=mysql_connect("localhost","root",""); //Connect to the database $rs=mysql_query("select count(*) from tb_product",$conn); //Get the total number of records $rs $myrow = mysql_fetch_array($rs); $numrows=$myrow[0]; //Calculate the total number of pages $pages= intval($numrows/$pagesize); //Determine the page number setting if (isset($_GET['page'])){ 　$page=intval($_GET['page']); } else { 　$page=1; // Otherwise, set to the first page } 3. Create the use case table myTable php pagination - bbs.it-home.org 　$conn=mysql_connect("localhost","root",""); 　//Set each The number of records displayed on one page 　$pagesize=1; 　mysql_select_db("mydata",$conn); 　//Get the total number of records $rs, and calculate the total number of pages using 　$rs=mysql_query("select count(*) from tb_product",$conn); 　$myrow = mysql_fetch_array($rs); 　$numrows=$myrow[0]; 　//Calculate the total number of pages 　$pages=intval($numrows/$pagesize); 　if ( $numrows%$pagesize) 　$pages++; 　//Set the number of pages 　if (isset($_GET['page'])){ 　$page=intval($_GET['page']); 　} 　else { 　　//Set as the first page 　 $page=1; 　} 　//Calculate the record offset 　$offset=$pagesize*($page - 1); 　//Read the specified number of records 　$rs =mysql_query("select * from myTable order by id desc limit $offset,$pagesize",$conn); 　if ($myrow = mysql_fetch_array($rs)) 　{ 　　$i=0; 　　?> 　　< ;table border="0" width="80%">
Title	Release time

";

　}

　echo "

There are ".$pages." pages (".$page."/".$ pages.")";

　for ($i=1;$i< $page;$i++)

　　echo "[". $i ."] ";

　echo "[".$page."]";

　for ($i=$page+1;$i<=$pages;$i++)

　echo "< ;a href='fenye.php?page=".$i."'>[".$i ."] ";

　　echo "

";

　　?>