How can one effectively access values in a PDO array when displaying database content in a table?

When displaying database content in a table using PDO, you can access values in the fetched array by using the column names as keys. This allows you to easily display the data in a structured format within the table. To access a specific value, simply use the column name as the key when iterating through the fetched array. 

// Assuming $stmt is the PDO statement object with fetched data

echo "<table>";
echo "<tr><th>ID</th><th>Name</th><th>Email</th></tr>";

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo "<tr>";
    echo "<td>" . $row['id'] . "</td>";
    echo "<td>" . $row['name'] . "</td>";
    echo "<td>" . $row['email'] . "</td>";
    echo "</tr>";
}

echo "</table>";

Keywords

PDO array database table values

Related Questions