note 15959 added to function.dblist

From: 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

« previous php.notes (#18769) next »