note 46705 added to function.mysql-stat
| From: | anthony dot parsons at manx dot _net | Date: | Wed, 20 Oct 2004 18:20:29 +0000 |
| Subject: | note 46705 added to function.mysql-stat | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-78848@lists.php.net to get a copy of this message | ||
The mysql_stat function only returns a string, so I wrote a function to convert the output into an
associative array:
<?php
//Usage is identical to mysql_stat, but returns the values as a 1D array instead of a string
function mysql_array_stat ($db = null)
{
$stat = $db ? mysql_stat ($db) : mysql_stat();
foreach (explode (' ', $stat) as $value)
{
$x = explode (': ', $value);
$stat_array[$x[0]] = $x[1];
}
return $stat_array;
}
?>
A print_r(mysql_array_stat()) would look like this:
Array
(
[Uptime] => 150062
[Threads] => 3
[Questions] => 9177
[Slow queries] => 0
[Opens] => 409
[Flush tables] => 1
[Open tables] => 11
[Queries per second avg] => 0.061
)
----
Manual Page -- http://www.php.net/manual/en/function.mysql-stat.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+46705
Delete -- http://master.php.net/manage/user-notes.php?action=delete+46705&report=yes
Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+46705&report=yes&reason=bad+code
Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+46705&report=yes&reason=spam
Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+46705&report=yes&reason=useless+example
Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+46705&report=yes&reason=contains+commercial+links
Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+46705&report=yes&reason=useless+note
Reject -- http://master.php.net/manage/user-notes.php?action=reject+46705&report=yes
Search -- http://master.php.net/manage/user-notes.php