[RESOLVED] php viewing tool

[lerro]

Is there a tool that can be used to view sql statements being processed by php?

what i mean is, monitoring when a form is posted, the values that are being sent to the server, and likewise, monitoring values being sent to a page from teh server.

Also, when a function with php is executed, viewing the sql statement and how teh function formats it and what it returns.

The reason i say this is some commands seems to run but return the wrong thing, logical errors, and it helps to monitor where these logical errors are emerging from, either from the form or function.

[dagon]

echo or print_r or var_dump

[sneakyimp]

Generally speaking, it is good practice to wrap your query function (e.g., mysql_query) in a class or in a function so that you have a single point where you can monitor or alter database query behavior. It could be as simple as this:

function my_query($param) {
  return mysql_query($param);
}

If you have such a function, you could easily alter it to LOG every single query that comes through to some log file like so:

function my_query($param) {
  file_put_contents('/path/to/log/file.txt', '[' . date('Y-m-d H:i:s') . ']' . $param . "\n", FILE_APPEND);
  return mysql_query($param);
}

[lerro]

Thanks for the answers