MySQLi Recordset Paging

When a given recordset returns more records than what your repeat region is set to display per page, a form of navigation is needed to move between the paged results. MySQLi Recordset Paging Server Behaviors are used to accomplish this.

 

  1. First, add text or images that will be used as navigation. Text such as: First, Next, Previous and Last are often used. As well as images containing arrows.
  2. Next, highlight the navigation text or image on your page.
  3. Access the mySQLi Recordset Paging server behavior you wish to use:

Server Behaviors (+) > WebAssist > MySQLi > Recordst Paging > MySQLi Move To First Page

In the example below, the text 'First' is highlighted and will display the first page of recrods returned by the recordset.

Server Behaviors (+) > WebAssist > MySQLi > Recordst Paging > MySQLi Move To Next Page

In the example below, the text 'Next' is highlighted and will display the next page of recrods returned by the recordset.

Server Behaviors (+) > WebAssist > MySQLi > Recordst Paging > MySQLi Move To Previous Page

In the example below, the text 'Previous' is highlighted and will display the previous page of recrods returned by the recordset.

Server Behaviors (+) > WebAssist > MySQLi > Recordst Paging > MySQLi Move To First Page

In the example below, the text 'Last' is highlighted and will display the last page of recrods returned by the recordset.