Dynamically build a form from mySQL table
| From: | Martin E. Koss | Date: | Tue, 20 Mar 2001 15:02:35 +0000 |
| Subject: | Dynamically build a form from mySQL table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7645@lists.php.net to get a copy of this message | ||
Hi,
I've been trying to figure this out by looking through the code in
phpMyAdmin but I'm not getting very far.
What I want to do is dynamically generate a form where I get a table row
containing the field name in one cell and the input field in the next cell,
for example:
$DatabaseName = "FocusDynamics";
$TableName = "Items";
// open the table and get all field names, sizes, etc.,
// for each Field name, print something like:
PRINT "<tr>\n";
PRINT "<td>$FieldName</td>\n";
PRINT "<td><input type=\"text\" name=\"$FieldName\"
value=\"$FieldValue\"
maxlength=\"FieldSize\"></td>\n";
PRINT "</tr>";
How do I get all this info from the table?
Thanks for any help.
Martin E. Koss
M: 07946-706459
E: mek@mek.co.uk