callback to get sql after filtering

Questionscallback to get sql after filtering
Shehzad Ismail asked 6 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 6 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

7 + 18 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



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!