PHP reads mysql database data and implements paging instance code _ PHP Tutorial

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 :? Php connects to the database $ dbmysql_connect (localhost, root, root); mysql_select_db (gaoge, $ db); sets PHP to read mysql database data on each page and implements the following code for paging instances:

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. // 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 );
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.
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 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. ?>
60. $ I;
61. ?>
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 ";
83. // Echo"
    ";
84. // Display to page number
85. Echo "";
86. Echo"
    ";
87. ?>

Why :? Php // connect to the database $ db = mysql_connect ("localhost", "root", "root"); mysql_select_db ("gaoge", $ db ); // Set each page to display...