[Resolved] Page information

[sys4dm1n]

<?
$round = 3; // The number of decimal places to round the micro time to.
$m_time = explode(" ",microtime());
$m_time = $m_time[0] + $m_time[1];
$endtime = $m_time;
$totaltime = ($endtime - $starttime);
echo "<!-- page loaded in ". round($totaltime,$round) ." seconds -->";
?>

That is my code, and i have it to output into the html source (commented so if u view the source u will see it).

..but i am also trying to get it to display how many mysql querys were used and how long it took them. i have no idea how to do this- i know for the time i would use something like i used for the page generation, but just not sure how..any suggestions?

Thanks

[Installer]

You could do it like this:

$page_start_time = microtime_float(); 
$round = 4; 
$query_num = 0; 
$query_time = array(); 

$query_start = microtime_float(); 
$return_1 = mysql_query($query_1); 
$query_time[$query_num++] = microtime_float() - $query_start; 
// 
// More code 
// 
$query_start = microtime_float(); 
$return_2 = mysql_query($query_2); 
$query_time[$query_num++] = microtime_float() - $query_start; 
// 
// More code 
// 
$query_start = microtime_float(); 
$return_n = mysql_query($query_n); 
$query_time[$query_num++] = microtime_float() - $query_start; 
// 
// More code 
// 
echo '<!-- There were ' . $query_num . ' queries. -->';  

$query_total_time = 0; 
foreach ($query_time as $key => $val) { 
    $query_total_time += $val; 
    echo '<!-- Query ' . $key + 1 . ' took ' . round($val, $round) . ' seconds. -->'; 
}  

echo '<!-- Total query time: ' . round($query_total_time, $round) . ' seconds. -->';  

$totaltime = microtime_float() - $page_start_time; 
echo '<!-- page loaded in' . round($totaltime, $round) . ' seconds -->';  

// 
// Insert microtime_float() function from the manual. 
//

[sys4dm1n]

The current code:

 <?
$page_start_time = microtime_float(); 
$round = 4; 
$query_num = 0; 
$query_time = array(); 

$query_start = microtime_float(); 
$return_1 = mysql_query($query_1); 
$query_time[$query_num++] = microtime_float() - $query_start; 

$query_start = microtime_float(); 
$return_2 = mysql_query($query_2); 
$query_time[$query_num++] = microtime_float() - $query_start; 

$query_start = microtime_float(); 
$return_n = mysql_query($query_n); 
$query_time[$query_num++] = microtime_float() - $query_start; 

echo '<!-- There were ' . $query_num . ' queries-  ';  

$query_total_time = 0; 
foreach ($query_time as $key => $val) { 
    $query_total_time += $val; 
    echo ' Query ' . $key + 1 . ' took ' . round($val, $round) . ' seconds; '; 
}  

echo ' Total query time: ' . round($query_total_time, $round) . ' seconds; ';  

$totaltime = microtime_float() - $page_start_time; 
echo ' Page loaded in: ' . round($totaltime, $round) . ' seconds -->';  

function microtime_float ()
{
list ($msec, $sec) = explode(' ', microtime());
$microtime = (float)$msec + (float)$sec;
return $microtime;
}
?>

in the source:

  <!-- There were 3 queries-  1 took 0.0008 seconds; 1 took 0.0001 seconds; 1 took 0.0001 seconds;  Total query time: 0.001 seconds;  Page loaded in: 0.0012 seconds -->

Works great, but-

I dont really understand the point of 3 query calculations for time?

Thanks

[Installer]

Well, you said you wanted to know how long your queries took.
If you time each query and add them up that will give you...the total time.
I used three queries just for an example to demonstrate the logic
(which, imo, is pretty clear). If you have only one query in your script,
use it once. If you have ten queries, use it ten times.
Then the echo statement will give you the time each one took,
and the time they took altogether. The main idea is to put
"$query_start = microtime_float();" right before each query,
and "$query_time[$query_num++] = microtime_float() - $query_start;"
right after.

Edit: Line breaks added to lessen the need for scrolling (easier reading).

[sys4dm1n]

ah ha! 😃

Thanks a lot, Installer. :p

[sys4dm1n]

Ah, one more thing:

<?
$page_start_time = microtime_float(); 
$round = 4; 
$query_num = 0; 
$query_time = array(); 

$query_start = microtime_float(); 
$return_1 = mysql_query($query_1); 
$query_time[$query_num++] = microtime_float() - $query_start; 

echo '<!-- There were ' . $query_num . ' queries executed. ';  

$query_total_time = 0; 
foreach ($query_time as $key => $val); { 
    [b]$query_total_time += $val; 
    echo ' Query number ' . $key + 1 . ' took ' . round($val, $round) . ' seconds to execute! '; [/b]
}  

echo ' Total query execution time was ' . round($query_total_time, $round) . ' seconds. ';  

$totaltime = microtime_float() - $page_start_time; 
echo ' Total page generation time was ' . round($totaltime, $round) . ' seconds. -->';  

function microtime_float ()
{
list ($msec, $sec) = explode(' ', microtime());
$microtime = (float)$msec + (float)$sec;
return $microtime;
}
?>

I get this outputted in the source:

<!-- There were 1 queries executed.[b] 1 took 0.0011 seconds to execute!  [/b]Total query execution time was 0.0011 seconds.  Total page generation time was 0.0013 seconds. -->

The output doesnt match the PHP code. It should read:

Query number 1 took 0.0011 seconds to execute!

No matter what i do to try to fix it, nothing works. Any suggestions?

[Installer]

Yeah, I forgot to put parentheses around "$key + 1". That should clear it up.

echo ' Query number ' . ($key + 1) . ' took ' . round($val, $round) . ' seconds to execute! ';