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.
- 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.
- Next, highlight the navigation text or image on your page.
- 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.