note 46705 added to function.mysql-stat

From: 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

« previous php.notes (#78848) next »