<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>sql_infos</title>
<style type="text/css" media="screen">
.db{
font-size:1.5em;
font-weight:bold;
}
.tb{
font-size:1.3em;
}
.resultat{
color:red;
}
</style>
</head>
<body>
<?php
$flux = mysql_connect('sql_host', 'user', 'password');
$regex = '/^[\w\.-]+@[\w\.-]+\.[a-z]+$/i';
$resultats = array();
//Listing des BDD
$db_list = mysql_list_dbs($flux);
$nb_db = mysql_num_rows($db_list);
//
echo "<ul> $nb_db Bases de données:";
//
for ($i = 0; $i< $nb_db; $i++){
$db_name = mysql_db_name($db_list, $i);
//
echo "<li><span class='db'>$db_name</span> \n";
//
//Listing des TABLES
$tables_list = mysql_list_tables($db_name);
$nb_tables = mysql_num_rows($tables_list);
//
echo "<ul> $nb_tables Tables:";
//
for ($j = 0; $j< $nb_tables; $j++){
$table_name = mysql_tablename($tables_list, $j);
//
echo "<li><span class='tb'>$table_name</span> \n";
//
//Listing des CHAMPS
mysql_select_db($db_name);
$query = "SHOW COLUMNS FROM $table_name";
$fields_list = mysql_query($query);
$nb_fields = mysql_num_rows($fields_list);
//
echo "<ul> $nb_fields Champs:";
//
while($row = mysql_fetch_assoc($fields_list)){
$field_name = $row['Field'];
//$db_tree[$db_name][$table_name][$field_name] = array();
//
echo "<li>$field_name \n";
//
$query = "SELECT $field_name FROM $table_name";
$results = mysql_query($query);
while($row = mysql_fetch_assoc($results)){
$str = $row[$field_name];
if(preg_match_all($regex, $str, $matches, PREG_SET_ORDER)){
echo "<ul> \n";
foreach($matches as $match){
foreach($match as $valeur){
echo "<li class='resultat'>$valeur \n";
$resultats[] = $valeur;
}
}
echo "</li></ul> \n";
}
}
}
echo "</li></ul> \n";
}
echo "</li></ul> \n";
}
echo "</ul> \n";
//
echo "<pre> \n";
print_r($resultats);
echo "</pre> \n";
//
?>
</body>
</html>
