Re: explode? (table field to a variable of same name)
| From: | Christopher William Wesley | Date: | Tue, 19 Feb 2002 22:26:14 +0000 |
| Subject: | Re: explode? (table field to a variable of same name) | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-85448@lists.php.net to get a copy of this message | ||
This may not be what you want to do, but should give you some hints.
(This is my code which I use to simply dump any SQL table into an HTML
table I can view in a browser ... for small tables, of course.)
Using MySQL as an example:
// assuming you ran a query and stored results in $mysql_result_set
// Get the number of fields to work with
$num_fields = mysql_num_fields( $mysql_result_set );
// http://www.php.net/manual/en/function.mysql-num-fields.php
// Print out a row of column headers
print( "<tr>" );
for( $i = 0; $i < $num_fields; $i++ ){
$fieldName = mysql_fetch_field( $mysql_result_set, $i );
// http://www.php.net/manual/en/function.mysql-fetch-field.php
print( "<td>" . $fieldName->name . "</td>" );
}
print( "</tr>" );
// Print out the data from the result records
while( $record = mysql_fetch_row( $mysql_result_set ) ){
// http://www.php.net/manual/en/function.mysql-fetch-row.php
print( "<tr>" );
foreach( $record as $field ){
${$field} = $field;
// The above is unnecessary, but answers your question.
// It assigns a variable, named after a table column,
// the value of that column (in this record).
print( "<td>${field}</td>" );
}
print( "<tr>" );
}
Hope that gives you something to work with.
g.luck,
~Chris
On Tue, 19 Feb 2002, Baloo :0) wrote:
> How can I assign automatically all fields of a database to a variable of
> the same name?
>
> Instead of having to manually do
> $user_id=$row["user_id"];
> etc
>
> Then how could I know the number of fields in the table so I can do a
> loop to print them all in html?