Shehzad Ismail asked 11 years ago
Hey Abu,
There is a field in my database that is boolean. I need to be able to set that field to 1 for the filtered data in PHP GRID. Is there a callback that I can use to see the SQL right after a filter is done? I'd like to be able to use that SQL and then update the rows.
-Shehzad
1 Answers
Abu Ghufran answered 11 years ago
Question is little unclear, But if i understand it correctly, you wish to see the background SQL executed by PHP Grid.
There are various ways, quickest would be to enable mysql general query log and see it.
If that's out of access, you can dig into jqgrid_dist.php code, and find
function execute_query($sql,$return="") and print $sql, and check output using firebug > ajax response.
Your Answer
