note 15959 added to function.dblist
| From: | badpenguin at email dot it | Date: | Wed, 10 Oct 2001 13:44:58 +0000 |
| Subject: | note 15959 added to function.dblist | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-18769@lists.php.net to get a copy of this message | ||
<?
$user="";
$pass="";
$db="";
$link=mysql_connect("localhost",$user,$pass);
if (! $link)
die("Non posso connettermi a Mysql");
$db_res=mysql_list_dbs($link);
while ($db_rows=mysql_fetch_row($db_res))
{
print "<b>$db_rows[0]</b>\n";
if(!@mysql_select_db($db_rows[0],$link))
{
print "<dl><dd>Non e' possibile connettersi--".
mysql_error()."</dl>";
continue;
}
$tab_res=mysql_list_tables($db_rows[0],$link);
print "\t<dl><dd>\n";
while ($tab_rows=mysql_fetch_row($tab_res))
{
print"\t<b>$tab_rows[0]</b>\n";
$query_res=mysql_query("SELECT * from $tab_rows[0]");
$num_fields=mysql_num_fields($query_res);
print "\t\t<dl><dd>\n";
for ($x=0;$x<$num_fields;$x++)
{
print "\t\t<i>";
print mysql_field_type($query_res,$x);
print "</i><i>";
print mysql_field_len($query_res,$x);
print "</i><b>";
print mysql_field_name($query_res,$x);
print "</b><i>";
print mysql_field_flags($query_res,$$x);
print "</i><br>\n";
}
print "\t\t</dl>\n";
}
print "\t</dl>\n";
}
mysql_close($link);
?>
--
http://www.php.net/manual/en/function.dblist.php
http://master.php.net/manage/user-notes.php?action=edit+15959
http://master.php.net/manage/user-notes.php?action=delete+15959
http://master.php.net/manage/user-notes.php?action=reject+15959