I have seen on some sites that it has a script for doing this:

7 Queries 0.40125 Execution Time


Does anybody know how to do something like that???

You mean like this?

PHP Code:

<?php
// Insert this block of code at the very top of your page:
$time = microtime();
$time = explode(" ", $time);
$time = $time[1] + $time[0];
$start = $time;

// Place this part at the very end of your page
$time = microtime();
$time = explode(" ", $time);
$time = $time[1] + $time[0];
$finish = $time;
$totaltime = ($finish - $start);
printf ("This page took %f seconds to load.", $totaltime);
?>

- Steve

Yeah cheers!

is there any way to count the number of queries in a page???

Then I suppose you'll want this:

PHP Code:

<?php
// Insert this block of code at the very top of your page:
$time = microtime();
$time = explode(" ", $time);
$time = $time[1] + $time[0];
$start = $time;

// You can put this anywhere you like
$GLOBALS['_MYSQL_QUERY_COUNT'] = 0;
function exec_mysql_query($sql)
{
++$GLOBALS['_MYSQL_QUERY_COUNT'];
return mysql_query($sql);

}// Place this part at the very end of your page
$time = microtime();
$time = explode(" ", $time);
$time = $time[1] + $time[0];
$finish = $time;
$totaltime = ($finish - $start);

//echo it
echo $_MYSQL_QUERY_COUNT.' Queries ';
printf ("%f Execution Time", $totaltime);dumpfi
?>

- Steve

I tried it with the query count and it doesnt count any queries! How come do they have to called a certain name on the variable?

Be sure to put the right part of the code onto the right part of the page... and this is counting mySQL queries, not some other kind of query, mind you.

- Steve

if your trying to optimize your code will that function slow it down???

What do you mean? This should work:

Put at the top of page,

PHP Code:

<?php
$time = microtime();
$time = explode(" ", $time);
$time = $time[1] + $time[0];
$start = $time;
?>

And now put this at the bottom of your page:

PHP Code:

<?php
$GLOBALS['_MYSQL_QUERY_COUNT'] = 0;
function exec_mysql_query($sql)
{
++$GLOBALS['_MYSQL_QUERY_COUNT'];
return mysql_query($sql);

}
$time = microtime();
$time = explode(" ", $time);
$time = $time[1] + $time[0];
$finish = $time;
$totaltime = ($finish - $start);

echo $_MYSQL_QUERY_COUNT.' Queries ';
printf ("%f Execution Time", $totaltime);dumpfi
?>

I googled this and got this all off the internet, so if it doesn't work for you you can take a look at http://www.google.com/search?hl=en&c...hp&btnG=Search

- Steve

yeah but i have to execute the queries using that function!

Originally Posted by evans123

yeah but i have to execute the queries using that function!

Yep. The trick is that you must wrap the mysql_query() call into another function.
It's that function that will both increment the query count and fire the query and return the result to the caller.
To mimic the original way of mysql_query()

It'll take longer for the code to execute won't it???

Maybe 1 or 2 milliseconds more.
Nothing compared to the time a query takes to be sent to the db engine and returned to PHP.