What is the issue with the PHP code provided for fetching data from a database and displaying it in a table with 4 columns?

The issue with the provided PHP code is that the loop that fetches and displays the data in the table only has one row, which means all the data will be displayed in a single row instead of multiple rows with 4 columns each. To solve this issue, you need to increment a counter variable inside the loop and start a new row every 4 iterations. 

// Fetch data from the database
$query = "SELECT * FROM your_table";
$result = mysqli_query($connection, $query);

// Display data in a table with 4 columns per row
echo "<table>";
$counter = 0;
while($row = mysqli_fetch_assoc($result)) {
    if($counter % 4 == 0) {
        echo "<tr>";
    }
    
    echo "<td>{$row['column1']}</td>";
    echo "<td>{$row['column2']}</td>";
    echo "<td>{$row['column3']}</td>";
    echo "<td>{$row['column4']}</td>";

    if($counter % 4 == 3) {
        echo "</tr>";
    }

    $counter++;
}
echo "</table>";

Keywords

PHP database fetch table columns

Related Questions