Displaying MySQL execution time in PHP

Question

I have been looking around the web for this but cannot really find a good answer. I have a small site search and I want to display the time it took the mysql query to execute (similar to Google). I've been trying to use microtime() but I get huge strings like 1.342524564267782e25... I just want a simple digit with two decimals following (0.15). Thanks in advanced.

score 4 · Accepted Answer · answered Apr 07 '12 at 17:04

4

Use round to fix the decimal points

$time = microtime();
echo round($time, 2);

answered Apr 07 '12 at 17:04

Starx

77,474
47
185
261

There's also `sprintf('%0.2f', $time)` and the like. PHP has LOTS of options for formatting numbers. – Marc B Apr 07 '12 at 17:16

score 2 · Answer 2 · answered Apr 07 '12 at 17:06

2

$ms = microtime(true);
mysql_query($sql);
$ms = microtime(true) - $ms;
echo $ms.' secs'; //seconds
echo ($ms * 1000).' millisecs'; //millseconds

answered Apr 07 '12 at 17:06

Nguyễn Hoàng Gia

928
4
11

Displaying MySQL execution time in PHP

2 Answers2