This question already has an answer here:
How to enter the result into an html table? I can't seem to be able to accomplish this.. the result below only gives me the first row into the table. The rest of the results show up out of the HTML . How do I go about this? thank you
<?php
echo "<table style='width:960px;background-color:silver;text-align:center;'>
<tr>
<th>Customer ID</th>
<th>First Name</th>
<th>Last Name</th>
<th>Email</th>
<th>Registration Date</th>
</tr>";
require_once("PDOconn.php");
// DISPLAY THE ENTRY IN A FORM
//Define query
try{
$dsn = "mysql:host=$servername;dbname=$dbname";
$conn = new PDO($dsn,$username,$password);
$conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$stmt = $conn->query('SELECT * FROM `Demo_Guests` ORDER BY reg_date ASC');
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
echo "<tr><td>
<a href=\"click_link.php?id={$row['id']}\"> id # " . $row['id'] . "</a><br></td>";
<td>{$row['firstname']} </td>
<td>{$row['lastname']}</td>
<td><a href=\"send_email.php?id={$row['email']}\">" . $row['email'] . "</a>
</td>
<td> {$row['reg_date']}</td></tr>";
echo "</table><br>";*/
}
}
catch(PDOException $e){
echo $e->getMessage();
}
?>
</div>