note 17297 added to function.mysql-list-fields
| From: | Jspierce at clarknexsen dot com | Date: | Mon, 03 Dec 2001 19:31:36 +0000 |
| Subject: | note 17297 added to function.mysql-list-fields | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-21572@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>";
}
--
http://www.php.net/manual/en/function.mysql-list-fields.php
http://master.php.net/manage/user-notes.php?action=edit+17297
http://master.php.net/manage/user-notes.php?action=delete+17297
http://master.php.net/manage/user-notes.php?action=reject+17297