Using correlation functions to implement PHP processing paging _php Tutorial

Through the

If we specify paging, 20 articles per page. A sub-channel list of the article through the database query for 45, then, we first through the query to obtain the following parameters: 1, the total number of pages, 2, per page.

PHP processing Paging The second step, for ($i = 0; $i < allpages; $i + +), page element acquisition, analysis, article generation, are executed in this loop. The difference is that die ("Create file". $filename. " Success! This sentence is removed and placed on the display after the loop, because the statement aborts the execution of the program. Cases:

2. < ? PHP
4. $ FP = fopen ("temp.html", "R");
6. $ content = fread ($FP, FileSize ("temp.html"));
8. $ Onepage = ' A ' ;
10. $ SQL = "SELECT ID from article where
    Channel= ' $channelid ' ";
12. $ Query = mysql_query ($sql);
14. $ Num = mysql_num_rows ($query);
16. $ Allpages = Ceil ($num/$onepage);
18. For ($i = 0; $i<$allpages; $i + +) {
20. if ($i = = 0) {
22. $ Indexpath = "Index.html" ;
24. } else {
26. $ Indexpath = "Index_" . $i. " HTML ";
28. }
30. $ Start = $i * $onepage;
32. $ List = '' ;
34. $ Sql_for_page = "Select Name,filename,title
    From article where channel= ' $channelid '
    Limit $start, $onepage ";
36. $ Query_for_page = mysql_query ($sql _for_page);
38. While ($result = $query _for_page) {
40. $list . = ' . $root. $result [' filename ']
    .' Target = _blank > '. $title. ' a><br> ';
42. }
44. $ content = Str_replace ("{articletable}
    ", $list, $content);
46. if (Is_file ($indexpath)) {
48. @unlink ($indexpath); If the file already exists, delete the
50. }
52. $ Handle = fopen ($indexpath, "w");
    Open file pointer, create file
54. /*
56. Check if the file is created and writable
58. */
60. if (!is_writable ($indexpath)) {
62. echo "File:". $indexpath. " Not writable,
    Please check its properties and try again! "; Modify to Echo
64. }
66. if (!fwrite ($handle, $content)) {//write information to file
68. echo "Generate file". $indexpath. " Failed! "; Modify to Echo
70. }
72. Fclose ($handle); Close pointer
74. }
76. Fclose ($FP);
78. Die ("Raw content Page file complete, if not complete,
    Please check the file permissions system and regenerate! ");
80. ?>

Roughly the way PHP handles paging, such as other data generation, data input and output checking, paging content pointing, etc. can be added to the page as appropriate.

http://www.bkjia.com/PHPjc/445950.html www.bkjia.com true http://www.bkjia.com/PHPjc/445950.html techarticle 20 articles per page when paging is assigned to us. A sub-channel list of the article through the database query for 45, then, we first through the query to get the following parameters: 1, the total number of pages, 2, per page ...

