MySQLi Show Region

Navigation links and/or images as well as other objects on a page can be conditionally shown baesed on results returned by a recordset. You can also specify that a region be displayed or hidden based on whether the recordset is empty. If a recordset is empty (for example, no records were found matching the query), you can display a message informing the user that no records were returned. This is especially useful when creating search pages that rely on user input search terms to run queries against. Similarly, you can display an error message if there is a problem connecting to a database, or if a user’s user name and password do not match those recognized by the server.

The Show Region server behaviors are:

  • MySQLi Show If First Page

  • MySQLi Show If Not First page

  • MySQLi Show If Last Page

  • MySQLi Show If Not Last Page

  • MySQLi Show If Recordset Empty

  • MySQLi Show If Recordset Not Empty

  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 > Show Region > MySQLi Show If First Page

MySQLi Show If First Page will only display the selected content if the first page of results from the recordset is currently displayed.

Server Behaviors (+) > WebAssist > MySQLi > Show Region > MySQLi Show If Not First Page

MySQLi Show If Not First Page will only display the selected content if any page other than the first page of results from the recordset is currently displayed.

Server Behaviors (+) > WebAssist > MySQLi > Show Region > MySQLi Show If Last Page

MySQLi Show If Last page page will only display the selected content if the last page of results from the recordset is currently displayed.

Server Behaviors (+) > WebAssist > MySQLi > Show Region > MySQLi Show If Not Last Page

MySQLi Show If Not Last Page will only display the selected content if any page other than the last page of results from the recordset is currently displayed..

Server Behaviors (+) > WebAssist > MySQLi > Show Region > MySQLi Show If Recordset Empty

MySQLi Show If Recordset Empty will only display the selected content if the recordset has not returned any records.

Server Behaviors (+) > WebAssist > MySQLi > Show Region > MySQLi Show If Recordset Not Empty

MySQLi Show If Recordset Not Empty will only display the selected content if the recordset has returned any records..