How do I "count" queries in PHP (MySQL)

[SNN]

I am trying to find the function for PHP where you can get the number of mysql queries and print them on a webpage.

I know this is possible, I've seen this on a few forums...how can I do this?

"Page generated in 2.29798 seconds with 16 queries"

 

Thanks,

Billy

[haku]

Just off the top of my head, you could write a function like this:

 

function query_and_count($query) {
   global $count;      
   $count = $count + 1;
   return mysql_query($query);
}

 

Then, at the top of your scripts, add this code:

 

global $count = 0;
$start_time = time();

 

And each time you want to do a query, you just call the code (for example):

 

query_and_count("SELECT * FROM table);

 

And at the end of your script, you use this code:

 

$finish_time = time();
$total_time = $finish_time - $start_time;
$output_time = date("s", $total_time) . "." . date("u", $total_time);
echo "Page generated in " . $output_time . " seconds with " . $count . "queries";

 

disclaimer: non-tested, just written off the top of my head.

[SNN]

Ah, my friend suggested this as well, but by just adding $qc++; at the end of each mysql_query.

I thought I saw a PHP function to do this before but this will work just as well (Should work from the looks of it.)

 

Thanks!

[haku]

You could use $count ++; and it would work fine. Shorter code too which is good.

[SNN]

Very true, but this is for a custom forum software, so extra functions for debugging mode will be good.

 

Thanks everyone.

Billy