Custom SQL query error reporting

[Teach]

Hello!

I hope you can help me out please

I have created a custom "goquery" function instead of mysql_query so that we can give error reporting, and count the amount of SQL queries per page for us to echo out

The code is:

function goquery($sql)
{
  $GLOBALS['queryCount']++;

  if ($res = mysql_query($sql)) {
    // All ok here
    return $res;
  } else {
    echo "              <ul class=\"left\">\n";
    echo "                <li><span><strong>Query:</strong> <code>".htmlentities($sql)."</code></span></li>\n";
    echo "                <li><span><strong>MySQL said:</strong> <code>".mysql_error()."</code></span></li>\n";
    echo "              </ul>\n";
    if (isset($_SESSION['logged'])) {
      include_once('/var/www/httpdocs/staff/footer.php');
    } else {
      include_once('/var/www/httpdocs/footer.php');
    }
    exit();
  }
}

The problems I hope you can help me with...

1) When error_reporting is on, it says $queryCount is undefined... how should I start defining it?

2) The above error reporting does work fine, except when the error happens inside a <select> menu or whatever (then it isn't displayed, or causes layout issues). What I'd LIKE to happen would be to add my header.php to the function, echo the error and then our footer - as if it was a brand new page, so none of the original page. Is that doable? I have heard one solution of doing all queries in one go before the page, but we have so many it's not really feasible

Thank you for your help

[leatherback]

1) if(! array_key_exists($GLOBALS, 'queryCount') {$GLOBALS['querycount']=1;} else {$_GLOBALS['querycount']++;}

2) Have a look at output control: http://www.php.net/manual/en/ref.outcontrol.php

[Teach]

Thanks for that, much appreciated

I tried looking over those pages, a lot if it flew over my head though

Based on some of the examples, I've played around with a few, particularly:

    ob_start();
    ob_clean();

followed by my include header (same as footer) before my <ul>, and I seem to get two headers, and still some of the output of the original page. :o

Any ideas how to get it to include nothing of the original?

[leatherback]

Basically, you start the page with ob_start(). You process as normal. Every time you encounter an error, you run your function, which should not create any output. At the end of the processing, you test whether error occurred (By checking the $_GLOBALS array).
If no error occurred, you flush the object to the client. Otherwise, you create a custom page notifying the user of the errors.

[Teach]

Hiya, sorry to be a pain with this 🙂

Just read over http://php.net/ob_start

From what I understood (not much!!!) I should be putting ob_start(); in my functions.php with session_start(); (that's included in every file), then an ob_end_flush(); in my footer.php at the end of all content...

If that's right, what would I need to do with that above function to get it to echo on its own page?

Sorry if I've completely misunderstood