PHP+MySQL paging display record code

$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);
//Judge 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

create table myTable(id int NOT NULL auto_increment,
 news_title varchar(50),
 news_cont text,
 add_time datetime,
PRIMARY KEY(id))

4. Complete code

php paging example_bbs.it-home.org



　$conn=mysql_connect("localhost","root","");
　//Set the number of records displayed on each 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'] ; Specify the 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;
?>
　　　　　　　　　　　　　　} while ($myrow = mysql_fetch_array($rs));　　 echo "


　　
　　　　do {　　　$i++;　　?>
　　
 


";
　}
　 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 "[".$i ."] ";
　echo "