What improvements can be made to the code to ensure that all records in the database are displayed in separate table cells?

The issue with the current code is that it is only displaying the last record from the database in a single table cell. To ensure that all records are displayed in separate table cells, we need to iterate through each record and output them within individual table cells. This can be achieved by looping through the fetched results and echoing each record within its own table cell. 

<?php
// Connect to the database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check connection
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Fetch records from the database
$sql = "SELECT * FROM table_name";
$result = mysqli_query($connection, $sql);

// Display records in a table
echo "<table>";
while ($row = mysqli_fetch_assoc($result)) {
    echo "<tr>";
    foreach ($row as $value) {
        echo "<td>" . $value . "</td>";
    }
    echo "</tr>";
}
echo "</table>";

// Close connection
mysqli_close($connection);
?>

Keywords

PHP MySQL database table cells display

Related Questions