note 14182 added to function.mysql-list-fields.php
| From: | php-general at lists dot php dot net | Date: | Fri, 20 Jul 2001 12:17:18 +0000 |
| Subject: | note 14182 added to function.mysql-list-fields.php | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-15611@lists.php.net to get a copy of this message | ||
this script will write all your tables from a database into a html-table each db-table you have.
$USER="{DB-USERNAME}";
$PASSWORD = "{DB-PASSWORD}";
$DB = "{DATABASE-NAME}";
$dbh = mysql_connect("localhost:",$USER,$PASSWORD);
mysql_select_db($DB);
$tables=mysql_list_tables($DB);
while (list($TheTableName)=mysql_fetch_array($tables))
{
$fields = mysql_list_fields($DB, $TheTableName);
$columns = mysql_num_fields($fields);
echo "<TABLE BORDER=1 width=100%>";
echo "<TR><TH COLSPAN=4><FONT COLOR=red
SIZE=+1>".$TheTableName."</TH></TR>";
echo "<TR><TH WIDTH=30%>Spaltenname</TH><TH
WIDTH=30%>Spaltentyp</TH>";
echo "<TH WIDTH=20%>Spaltenlänge</TH><TH
WIDTH=20%>SpaltenFlag</TH></TR>";
for ( $i = 0; $i < $columns; $i++ )
{
echo "<TR>";
echo "<TD>".mysql_field_name($fields,$i)."</TD>";
echo "<TD>".mysql_field_type($fields,$i)."</TD>";
echo "<TD>". mysql_field_len($fields,$i)."</TD>";
$TheFlag=mysql_field_flags($fields,$i);
if ( empty($TheFlag) )
$TheFlag="null";
echo "<TD>".$TheFlag."</TD>";
echo "</TR>";
}
echo "</TABLE>";
}
http://www.php.net/manual/en/function.mysql-list-fields.php