PHP page flip function implementation

This article describes how to implement the PHP page flip function. The following describes how to implement the current page data display quantity and how to implement the dynamic flip function, we all know that it is very simple and interesting to use php + mysql to display all the database information on the web page. if there are few database information, the page is satisfactory, however, when there are a lot of database information, the page display will become very bad, the following describes how to display the data volume on the current page and how to implement the dynamic flip function.
Here we will introduce Implementation of two page flip display functions:
First, we will introduce the database syntax used in Paging:

mysql_query("select * from table order by id desc");

This database statement is no longer familiar. it is used to search records and display them in reverse order, but does not play a role in the paging function, the extended syntax below is the core function of page flip:

mysql_query("select * from table order by id desc limit $start,$limit");

Here, $ start is the starting row for database search, and $ limit is the starting row to search for $ limit Records. well, with this core function, we can start the page flip function.

The first page flip function:
The features described here are the simplest of the page flip function. you can only flip the pages forward and backward. this is the paging function of the news and download center on this site.
First, we will introduce the implementation of the page flip function.Ideas:

• First, determine the number of data records displayed on the current page. for example, 20 records are displayed. set the value of $ limit to 20: $ limit = 20;
• When displaying database records, it must start from the first entry. Therefore, the initial value of $ start is set to 0: $ start = 0;
• The implementation of the paging function depends on the dynamic changes of $ start. when the page is turned back, $ start is added with $ limit: $ start + $ limit; when you flip the page forward, $ start is regularly subtracted from $ limit: $ start-$ limit;

With the above ideas, you can start designing the program.

Page. php:

<? // Set the quantity displayed on the current page (this quantity can be set as needed) $ limit = 20; // initialize the database search start record if (! Emptyempty ($ start) $ start = 0; mysql_connect ("localhost", "", ""); mysql_select_db (database ); // set the total number of database records $ result = mysql_query ("select * from table"); $ num_max = mysql_numrows ($ result ); $ result = mysql_query ("select * from table order by id desc limit $ start, $ limit); $ num = mysql_numrows ($ result); echo"
 
 "; If (! Emptyempty ($ num) {for ($ I = 0; $ I <$ num; $ I ++) {$ val = mysql_result ($ result, $ I, "val"); $ val1 = mysql_result ($ result, $ I, "val1"); echo" 
   ";}} Echo" 
   

  
  
 
   
 
    
Page Flip function
 
   
 
    
$ Val
 
    
$ Val1
 
   
 
    
"; // Set the jump to the previous page flip $ prve = $ start-$ limit; if ($ prve> = 0) {echo" prve ";} // Set the jump to the back page to $ next = $ start + $ limit; if ($ next <$ num_max) {echo "next" ;}echo"
 
   
 
  
 
 
";?>

A front flip and back flip function is completed, but this function will be very cumbersome for processing more information display. next we will continue to introduce the more powerful and more complex page turning feature-loop page turning (I have always called this because I cannot find a more appropriate name ). :)
The previous section introduced the simple page flip function implementation. the page flip function described below is more powerful and complex. This function is used in many forums and articles on this site.
Loop paging is implemented by adding numbers to the front and back pages. the specific manifestation is as follows:
Page: prve <1 2 3 4 ...... 20> next
The numbers in it indicate the current pages. the prve and next operations are not only the front and back pages of the current page, but more complex numeric control.

As in the past, before program design, I should clarify my ideas. I suggest that you do it yourself after reading how to implement the function of turning pages cyclically, some methods and ideas studied here may be abstract.
First, we boldly assume that there are more than 1000 records in the database. we want to display 25 records, and the number flip control is 20. Therefore, the following result is displayed:
Page: 0 1 2 3...> next
The following result is displayed:
Page: prve <20 27 28 ...... 49> next
Well, let's take a look at the rule. a fixed number 25 is displayed, and a fixed number is doubled by 20. we can use these two numbers to implement the cyclic page flip function;
First, set the fixed display variable:
$ Limit = 20;

Database initial variable settings:
$ Start = 0;

The total number of database records is:

$ Num;
Page number variable: $ page;
The procedure for loop display of a page number is as follows:

<? ... $ Result = mysql_query ("select * from table"); $ num = mysql_numrows ($ result); for ($ page = 0; $ page <($ num/$ limit ); $ page ++) {echo $ page; if ($ page> 0 & ($ page % 20) = 0) {break; // exit loop}?>

In addition to displaying numbers, this code does not implement other functions. because the number control is used to control the flip, there must be several variables to Mark and identify these controls, $ s is used to mark the variable. this variable is used to control the digital loop page turning control. now you can see the complete code page for implementing loop page turning. php:

<? $ Limit = 25; if (! Emptyempty ($ start) $ start = 0; if (! Emptyempty ($ s) $ s = 0; mysql_connect ("localhost", "", ""); mysql_select_db (database ); // count the total number of database records $ result = mysql_query ("select * from table"); $ num = mysql_numrows ($ result ); $ result = mysql_query ("select * from table order by id limit $ start, $ limit"); $ numb = mysql_numrows ($ result); echo"
 
 
  
  
"; If (! Emptyempty ($ numb) {for ($ I = 0; $ I <$ numb; $ I ++) {$ val = mysql_result ($ result, $ I, "val"); $ val1 = mysql_result ($ result, $ I, "val1"); echo"
  
  ";}} Echo" 
  
 
   
 
    
$ Val
 
    
$ Val1
 
   
 
 
"; // Digital loop paging control echo"
 
 
  
  
"; Echo"
  
  "; // Forward flip control if ($ s> 20) {if ($ s = 21) {$ st = $ S-21;} else {$ st = $ S-20 ;} $ pstart = $ st * $ limit; echo" 
    ";} Echo" 
    "; // Set the page number of the current page without link function $ star = $ start; // pay attention to the initial value of the loop. think carefully about why it is not 0 for ($ page = $ s; $ page <($ num/$ limit); $ page ++) {$ start = $ page * $ limit; echo" 
    "; // Controls the limited display function of the digital page. only 20 pages are displayed. if ($ page> 0 & ($ page % 20) = 0) {if ($ s = 0) {$ s = $ s + 21;} else {$ s = $ s + 20;} $ start = $ start + $ limit; if ($ num/$ limit)-1)> $ page) {echo" 
    ";}// Note break for loop exit control;} echo" 
   
 
   
 
    
Page:
Prve
>
"; If ($ page! = $ Star/$ limit) {echo "";} echo $ page; if ($ page! = $ Star/$ limit) {echo "";} echo"
<
 
    
Next
 
  
 
 
";?>

Another page flip function is to submit pages, that is, to add data to the submission form, and then the program jumps to the corresponding page. This function is easy to implement and left for the reader to complete.

The above procedures have already been able to complete the powerful loop paging function, you can carefully study, truly learn to use.