Posted By

stancell on 08/21/08

Tagged

mysql
log
query

Versions (?)

Last Edited at 08/21/08 08:55am

Statistics

Viewed 1124 times

Favorited by 1 user(s)

Related snippets

Show mysql query log with firebug

/ Published in: PHP

Replace all mysql_query() calls in your project to debug_mysql_query() to see all mysql queries in Firebug console.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

if (!function_exists('debug_mysql_query')) {
 
    function debug_mysql_query($query)
    {
        $js_query = str_replace(array('\\', "'"), array("\\\\", "\\'"), $query);
        $js_query = preg_replace('#([\x00-\x1F])#e', '"\x" . sprintf("%02x", ord("\1"))', $js_query);
        echo '<script>console.log("'.$js_query.'");</script>'."\n";
        return mysql_query($query);
    }
}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.