How to get the amount of time a query will take in php?

Question

I am getting result from database and I want to print the amount of seconds or minute it took to bring me the result.

something like this:

if($fba_num_rows > 0){
//print the amount of time the query took
//like "Search completed in 0.57 seconds"

}

How do i do this? please help.

save the time before and after the query runs, then compare them afterwards. — JimL, May 14 '16 at 08:57
Look at this answer pls http://stackoverflow.com/a/1631335/5094931 — Petko Kostov, May 14 '16 at 09:12

score 0 · Accepted Answer · answered May 14 '16 at 09:06

0

Use microtime function:

if($fba_num_rows > 0){
    $time_start = microtime(true);
    // your code

    $time_end = microtime(true);
    echo 'Search completed in ' . ($time_end - $time_start) . ' seconds';
}

answered May 14 '16 at 09:06

u_mulder

54,101
5
48
64

Thanks so much..looks simple – james Oduro May 14 '16 at 09:30

score 0 · Answer 2 · answered May 14 '16 at 09:13

You can always use the microtime function as said in the PHP Docs.

Like:

$start_time = microtime(true);
// Do DB Ops
if($fba_num_rows > 0){
    // Find the end time
    $end_time = microtime(true);
    // Calculate the time taken
    $time_taken = $end_time - $start_time;
    // Print the time
    printf("Query took %f seconds", $time_taken);
}

Hope it helps!

How to get the amount of time a query will take in php?

2 Answers2