note 17297 deleted from function.mysql-list-fields by jimw
| From: | jimw@php.net | Date: | Tue, 18 Dec 2001 23:04:13 +0000 |
| Subject: | note 17297 deleted from function.mysql-list-fields by jimw | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-23300@lists.php.net to get a copy of this message | ||
Here is the same code in english
$Host = "localhost";
$USER = "";
$PASSWORD = "";
$DB = "DatabaseName";
$TableName = "TableName";
//$Link = mysql_connect ($Host, $User, $Password);
$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=0 width=100% style=\"border-style: outset; border-color: #C8C8C8;
border-width: 1px;\">";
echo "<TR><TH COLSPAN=4 bgcolor=#003399><font face=\"Verdana, Arial,
Helvetica, sans-serif\" size=2
color=#FFFFFF><b>".$TheTableName."</b></font></TH></TR>";
echo "<TR><TH WIDTH=30% bgcolor=#8CC6FF>ColumnName</TH><TH WIDTH=30%
bgcolor=#8CC6FF>ColumnType</TH>";
echo "<TH WIDTH=20% bgcolor=#8CC6FF>Maximum Length</TH><TH WIDTH=20%
bgcolor=#8CC6FF>ColumnFlag</TH></TR>";
for ( $i = 0; $i < $columns; $i++ )
{
echo "<TR>";
echo
"<TD bgcolor=#DFEFFF>".mysql_field_name($fields,$i)."</TD>";
echo
"<TD bgcolor=#DFEFFF>".mysql_field_type($fields,$i)."</TD>";
echo "<TD bgcolor=#DFEFFF>".
mysql_field_len($fields,$i)."</TD>";
$TheFlag=mysql_field_flags($fields,$i);
if ( empty($TheFlag) )
$TheFlag="null";
echo "<TD bgcolor=#DFEFFF>".$TheFlag."</TD>";
echo "</TR>";
}
echo "</TABLE>";
}