July 1st, 2003, 10:01 AM
|
|
Hooner
|
|
Join Date: Jan 2003
Location: norwich
Posts: 51
Time spent in forums: < 1 sec
Reputation Power: 6
|
|
|
SHOW status question
i am writing some functions to show the current status of the database when the user logs in.
I have succesfully built a SHOW TABLE STATUS function which lists the status of all the tables in the database. I also wanted to display the system status and so have written the following:
PHP Code:
connect_db(ppukdb);
$sql = "SHOW status";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$system_summary = "System Summary:<p>
<table width=\"100%\" border=\"0\">
<tr bgcolor=\"#FFFFFF\">
<td>Up time in sec</td>
<td>$myrow[Uptime] </td>
</tr>
<tr bgcolor=\"#FFFFFF\">
<td>Bytes Received </td>
<td>$myrow[Bytes_received]</td>
</tr>
<tr bgcolor=\"#FFFFFF\">
<td height=\"25\">Bytes sent</td>
<td>$myrow[Bytes_sent]</td>
</tr>
<tr bgcolor=\"#FFFFFF\">
<td>Connections</td>
<td>$myrow[Connections]</td>
</tr>
<tr bgcolor=\"#FFFFFF\">
<td>Aborted connects</td>
<td>$myrow[Aborted_connects]</td>
</tr>
<tr bgcolor=\"#FFFFFF\">
<td>Aborted Clients</td>
<td>$myrow[Aborted_Clients]</td>
</tr>
<tr bgcolor=\"#FFFFFF\">
<td>Max used connections</td>
<td>$myrow[Max_used_connections]</td>
</tr>
<tr bgcolor=\"#FFFFFF\">
<td>Threads connected</td>
<td>$myrow[Threads_connected]</td>
</tr>
<tr bgcolor=\"#FFFFFF\">
<td>Threads running</td>
<td>$myrow[Threads_running] </td>
</tr>
<tr bgcolor=\"#FFFFFF\">
<td>Threads created</td>
<td>$myrow[Threads_created]</td>
</tr>
<tr bgcolor=\"#FFFFFF\">
<td>Threads cached</td>
<td>$myrow[Threads_cached]</td>
</tr>
</table>";
foreach ($myrow as $key => $value) {
$system_summary .= "key:$key - value:$value <br> ";
}
disconnect_db();
When i ran this code it ran with no errors but would not echo any of the variables. So i added the foreach loop to see what was going on in the array and it returned this:
key:0 - value:Aborted_clients
key:Variable_name - value:Aborted_clients
key:1 - value:558
key:Value - value:558
I am not sure if i have a problem with my SQL statement or my PHP so sorry if this is in the wrong forum.
If i type SHOW status into PHPMYadmin in returns the results fine.
anyone got any ideas?
Once i am finished i'll post them up
thanks
toby
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
