PHP reads mysql database data and implements paging instance code

The code for PHP to read mysql database data and implement paging instances is as follows: & lt ;? Php & nbsp; // Connect to database & nbsp; $ dbmysql_connect (localhost, root, root); & nbsp; & nbsp; mysql_select_db (gaoge, $ db) PHP reads mysql database data and implements the following code for paging instance:

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;
7.  
8. // Obtain 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] indicates 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 );
18.  
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, the page number is defined as the homepage.
25.  
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. }
35.  
36. // Echo "page is :";
37. // Echo $ page;
38. // Echo
    ;
39. // Calculate the record offset
40. $ Offset = $ pagesize * ($ page-1 );
41. // Echo "offset is :";
42. Echo $ offset;
43. // Retrieve records
44. $ Res = mysql_query ("select * from image order by id desc limit $ offset, $ pagesize", $ db );
45. // Display records cyclically
46. If ($ myrow = mysql_fetch_array ($ res ))
47. {
48. $ I = 0;
49. ?>
55.  
56.  
57.  
59.  
60. $ I;
61. ?>
62.  
63.  
64.  
65.  
67. "/>
68.  
69.  
70. While ($ myrow = mysql_fetch_array ($ res ));
71. Echo"
72. Do {
73. }

ID	Image name	Uploaded person name	Upload time	Image Effects

";
74. }
75. // Display the total number of pages
76. Echo "total". $ pages. "page (". $ page. "/". $ pages .")
    ";
77. // Display the number of pages
78. For ($ I = 1; $ I <= $ pages; $ I)
79. Echo "page". $ I ";
80. // Echo "page is :";
81. // Echo "$ page ";
82.  
83. // Echo"
    ";
84. // Display to page number
85. Echo "";
86. Echo "";
87. ?>