".pmb_sql_value("select count(*) as nb from notices")."
" ;
echo "
".pmb_sql_value("select count(*) as nb from exemplaires")."
" ;
echo "
".pmb_sql_value("select count(*) as nb from bulletins")."
" ;
echo "
".pmb_sql_value("select count(*) as nb from authors")."
" ;
echo "
".pmb_sql_value("select count(*) as nb from publishers")."
" ;
echo "
".pmb_sql_value("select count(*) as nb from empr")."
" ;
echo "
".pmb_sql_value("select count(*) as nb from pret")."
" ;
echo "
".pmb_sql_value("select count(*) as nb from pret_archive")."
" ;
echo "
" ;
echo "
".DATA_BASE." on ".SQL_SERVER.", user=".USER_NAME."
".pmb_mysql_get_server_info()."
" ;
echo "
".pmb_mysql_get_client_info()."
" ;
echo "
".pmb_mysql_get_host_info()."
" ;
echo "
".pmb_mysql_get_proto_info()."
" ;
echo "
".str_replace(' ','
',pmb_mysql_stat())."
";
echo "
" ;
$result = pmb_mysql_query('SHOW VARIABLES');
$parity=0 ;
while ($row = pmb_mysql_fetch_assoc($result)) {
if ($parity % 2) $pair_impair = "even";
else $pair_impair = "odd";
$parity+=1;
echo "| ".$row['Variable_name']." | ".$row['Value']." |
";
}
echo "
" ;
break;
case '':
default:
print "
";
/*
*/
break;
}
if($action) {
@set_time_limit($pmb_set_time_limit);
$db = DATA_BASE;
$tables = pmb_mysql_list_tables($db);
$num_tables = @pmb_mysql_num_rows($tables);
$i = 0;
while($i < $num_tables) {
$table[$i] = pmb_mysql_tablename($tables, $i);
$i++;
}
echo "
";
foreach ($table as $cle => $valeur) {
$requete = $action." TABLE ".$valeur." ";
$res = pmb_mysql_query($requete);
$nbr_lignes = @pmb_mysql_num_rows($res);
$nbr_champs = @pmb_mysql_num_fields($res);
if($nbr_lignes) {
if(!$cle) {
for($i=0; $i < $nbr_champs; $i++) {
printf("| %s | ", pmb_mysql_field_name($res, $i));
}
}
for($i=0; $i < $nbr_lignes; $i++) {
$row = pmb_mysql_fetch_row($res);
echo "";
foreach($row as $col) {
if(!$col) $col=" ";
print "| $col | ";
}
echo "
";
}
}
}
echo "
";
}