Skip to content
PHP Logo

How can the user ensure that the table is displayed even if it is empty in the PHP code provided?

To ensure that the table is displayed even if it is empty in the PHP code, the user can add a conditional check to display a message if there are no rows in the database query result. This can be achieved by checking if the number of rows fetched from the query is zero and displaying a message accordingly. By implementing this check, the table will still be displayed with a message indicating that there are no records to show.

php 
<?php
// Perform database query to fetch data
$query = "SELECT * FROM table_name";
$result = mysqli_query($connection, $query);

// Display table header
echo "<table border='1'>";
echo "<tr><th>Column 1</th><th>Column 2</th></tr>";

// Check if there are rows in the result
if(mysqli_num_rows($result) > 0) {
    // Display data rows
    while($row = mysqli_fetch_assoc($result)) {
        echo "<tr><td>".$row['column1']."</td><td>".$row['column2']."</td></tr>";
    }
} else {
    // Display message if no records found
    echo "<tr><td colspan='2'>No records found</td></tr>";
}

echo "</table>";
?>

Related questions