Manual: Internals-Setsql

Understanding and Using Setsql Mode

A RidgeStar Interactive Site typically consists of one or more functional pages that rely in interacting with a database respository containing site related data. This is accomplished using mysqlnd 8.3.14 currently, which has an extensive range of support for a variety of SQL (Structured Query Language) commands.

If you would like to be able to view the variety of SQL commands being issued by the various pages, activate Setsql mode.

Turning ON Setsql mode

You can activate Setsql mode by adding the keyword sequence "setsql=1" to any interactive page. You need to understand how HTTP uses the question mark (?) and ampersand (&) to separate keywords from the page name, but here's an example using this page of what you'd put in the Address/Location area:

http://ridgestar.com/setsqlmode.php?setsql=1

Turning OFF Setsql mode

To disable Setsql mode, add the keyword sequence "Setsql=0" to any interactive page, as

http://ridgestar.com/setsqlmode.php?setsql=0

What happens when Setsql is on?

Setsql Mode will display the actual SQL Command(s) that is(are) being issued to the Database processor. This can be extremely useful when determining precisely what the Query Language construct is for and doing.

To display an example of Setsql output in this page, turn on Setsql mode as described in the paragraph titled "Turning ON Setsql mode".