<?php
// dbstatus.php
// Par Charles Népote (charles@nepote.org)
// Version 0.2 du 17/01/2005
// License GPL.
/*
Si vous souhaitez avoir un tableau joliment encadré il faut ajouter
les styles suivant à wakka.css
.simple_table { border-collapse: collapse; }
.simple_table th, td { border: 1px solid #666; padding: 0.5em; text-align: right; }
*/
$status = $this->LoadAll('SHOW TABLE STATUS LIKE \''.$this->config["table_prefix"].'%\'');
echo "<div class=\"dbstatus\">\n",
"<p>Status :</p>\n",
"<table class=\"simple_table\">\n",
"<tr>\n",
"<th>Nom</th>\n",
"<th>Enreg.</th>\n",
"<th>Taille</th>\n",
"</tr>\n";
foreach ($status as $table)
{
echo
"<tr>\n",
"<td>", $table['Name'], "</td>\n",
"<td>", $table['Rows'], "</td>\n",
"<td>", round($table['Data_length']/1024, 0), " Ko</td>\n",
"</tr>\n";
}
echo "</table>\n",
"</div>\n";
?>
Status :
Nom | Enreg. | Taille |
---|---|---|
wikini_acls | 4221 | 120 Ko |
wikini_links | 8194 | 810 Ko |
wikini_pages | 1430 | 22377 Ko |
wikini_referrers | 0 | 2256 Ko |
wikini_users | 400 | 37 Ko |