View/debug SQL

Suite and Optimus Suite 5
#1

Is there a way to see the exact SQL query that is being sent to MySQL when using the PHP Connector and the render_table method?

#2

Yep, add the next code before the “render” command

$grid->enable_log("some.txt");

some.txt will be created in the same file where connector.php resides, so be sure to enable write access for connector’s folder ( or use full path to a writable folder in the enable_log command )

#3

Thanks, it works.

Getting greedy now, but the output in the text file is just one continual string. Is there a way to insert a line break after the “Done in xxxx”?

#4

Never mind! That was a Notepad issue. It comes through well-formatted in other program.

Thanks very much