note 14182 deleted from function.mysql-list-fields by jimw
| From: | jimw@php.net | Date: | Tue, 18 Dec 2001 23:04:09 +0000 |
| Subject: | note 14182 deleted from function.mysql-list-fields by jimw | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-23299@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>";
}