Display PHP results in HTML table

brrutzo

I apologize if this has been posted before. I am new to PHP and pretty much coding in general. My question is: how can I display the results from the following query in a html table? When I pull it, it comes out all bunched together. Is there a way to include row heading in the table as well?


// generate a list of all users.
$sql = "SELECT * FROM users";
$res = mysql_query($sql);
$num_rows = mysql_num_rows($res);


echo "There are a total of  ".($num_rows)." in this query.";
	echo "<br>";
	while($row = mysql_fetch_assoc($res))
		{	echo $row[firstname].$row[lastname].$row[phone].$row[email]."<br>";

}
echo "End of list";

Thank you very much for your time.

1042

brrutzo wrote:
I apologize if this has been posted before. I am new to PHP and pretty much coding in general. My question is: how can I display the results from the following query in a html table? When I pull it, it comes out all bunched together. Is there a way to include row heading in the table as well?
// generate a list of all users.
$sql = "SELECT * FROM users";
$res = mysql_query($sql);
$num_rows = mysql_num_rows($res);


echo "There are a total of  ".($num_rows)." in this query.";
	echo "<br>";
	while($row = mysql_fetch_assoc($res))
		{	echo $row[firstname].$row[lastname].$row[phone].$row[email]."<br>";

}
echo "End of list";
Thank you very much for your time.

Here is a way to do it;

echo "<table>";
echo "<tr>
    <td>First Name</td>
    <td>Last Name</td>
    <td>Email</td>
  </tr>";
while($row = mysql_fetch_assoc($res)) {
echo "<tr>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['email'] . "</td>";
echo "</tr>";
}
echo "</table>";
}

Code not tested but it should give you a general idea, cheers.

brrutzo

Thank you 1042! That worked like a charm. And actually makes sense how it worked. I'm sure there is a fancy way to do it with PHP, but that is perhaps a post for another day.

Thanks again!

guruparthi

$sql = "SELECT * FROM users";
$res = mysql_query($sql);
$num_rows = mysql_num_rows($res);

echo "There are a total of ".($num_rows)." in this query.";
echo'<table>';
echo "<br>";
while($row = mysql_fetch_assoc($res))
{

echo'<tr><td>'. $row[firstname].'</td><td>'.$row[lastname].'</td><td>'.$row[phone].'</td><td>'.$row[email].'</td></tr>';

} 
echo'</table>';
echo "End of list";

Reference: http://www.phponwebsites.com/2014/04/php-mysql-display-results-in-html-table.html