Echo Out All Field Names Along With Their Respective Values

Question

I would like to print a list with all field names and their values from a table in a mysql database. How would i use a loop to print:

FIELD NAME

Solution 1:

This is very basic PHP, a simple while-loop combined with a foreach would suffice:

echo'<table>';
$query = mysql_query("SELECT * FROM `your_table`");
// Loop over all result rowswhile($row = mysql_fetch_assoc($query)) {
    // Loop over all fields per rowforeach($rowas$field => $value) {
        echo'<tr><td>' . htmlentities($field) . '</td><td>' . htmlentities($value) . '</td></tr>';
    }
    // New data row can optionally be seperated with a blank line hereecho'<tr><td colspan="2">&nbsp;</td></tr>';
}
echo'</table>';

Solution 2:

Use mysql_field_name(), mysql_num_fields(), mysql_fetch_field(), mysql_field_seek().

Or keys(mysql_fetch_assoc())

Solution 3:

This is something I did a few days ago:

mysql_connect('localhost','user','password');
mysql_select_db('database');

$sql = "SELECT * FROM  your_table";
$result = mysql_query($sql);

echo"<table border='1'>";
echo"<tr>";
$i = 0;
while ($i < mysql_num_fields($result))
{
    $meta = mysql_fetch_field($result, $i);   
    echo"<th>".$meta->name."</th>";
    $i++;
}

while ($row = mysql_fetch_row($result))
{
    echo'<tr>';

    foreach($rowas$item)
    {
        echo"<td>".$item."</td>";
    }

    echo'</tr>';
}

echo"</table>";

Learn Html5

Echo Out All Field Names Along With Their Respective Values

Solution 1:

Solution 2:

Solution 3:

Post a Comment for "Echo Out All Field Names Along With Their Respective Values"