PHP reads mysql database data and implements paging example code_PHP tutorial

PHP reads mysql database data and implements paging example code as follows:

2. //Connect to the database
3. $db =mysql_connect("localhost","root","root");
4. mysql_select_db("gaoge",$db);
5. //Set the number of records displayed on each page
6. $pagesize=3;
8. //Get the total number of records and calculate the total number of pages
9. $res=mysql_query("select count(*) from image " ,$db);
10. $myrow = mysql_fetch_array($res);
11. //$myrow[o] is the sum of the total number of records in the database
12. $numrows=$myrow[0];
13. //echo "total num is:";
14. //echo $numrows;
15. // echo
    ;
16. //Calculate the total number of pages
17. $pages=intval($numrows/$pagesize);
19. if ($numrows%$pagesize )
20. $pages ;
21. // echo "total pages is:";
22. //echo $pages;
23. //echo
    ;
24. //Determine whether the page number is set or not, if not, it is defined as the home page
26. if (isset($_GET[page])){
27. //echo "page exist";
28. $page = $_GET[page];
29. //echo "enter if ";
30. }
31. else{
32. //echo "page not exist";
33. $page = 1;
34. }
36. //echo "page is:" ;
37. // echo $page;
38. // echo
    ;
39. //Calculate record bias Offset
40. $offset=$pagesize*($page-1);
41. // echo "offset is:" ;
42. echo $offset;
43. //Get records
44. $res=mysql_query("select * from image order by id desc limit $offset,$pagesize" ,$db);
45. //Loop display records
46. if ($myrow = mysql_fetch_array($res))
47. {
48. $i=0;
49. ?>
50. < ;table cellspacing=0 bordercolordark=#FFFFFF width="95%" bordercolorlight=#000000 border=1 align="center" cellpadding="2">
52.   ＩＤ
53.   Picture name
54.   Uploader name
55. Upload time
56. Picture effect
60. do {
61. $i ;
62. ?>
64. < ?php echo $myrow[2];?>
66. 
69. }
70. while ($myrow = mysql_fetch_array ($res));
71. echo "" ;
72. }
73. //Display the total number of pages
74. echo "
    There are ".$pages." pages (".$page."/".$pages.")
    ";
75. //Display the number of pages
76. for ($i=1;$i<=$pages;$i)
77. echo "< ;a href=pages.php?page=".$i.">Page ".$i ." ";
78. //echo "page is:";
79. //echo "$page";
81. // echo "
    ";
82. //Display the page number
83. echo "
    ";
84. //Calculate the page values ​​of the first page, previous page, next page and last page
85. $ first=1;
86. $prev=$page-1;
87. $next=$page 1;
88. $last=$pages;
90. echo "Homepage ";
91. //echo "page is:";
92. //echo "$page";
93. echo "Previous page ";
94.  
95. echo "Next page ";
96. echo "Last page ";
98. echo "";
99. echo "

";

?>