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.
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.
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!