What is the best approach to output data from a MySQL table into multiple columns in an HTML table using PHP?

When outputting data from a MySQL table into multiple columns in an HTML table using PHP, the best approach is to fetch the data from the database and then loop through the results to populate the table rows and columns accordingly. This can be achieved by using a combination of HTML and PHP code to dynamically generate the table structure and populate it with the data retrieved from the database. 

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

// Check connection
if ($connection === false) {
    die("Error: Could not connect. " . mysqli_connect_error());
}

// Fetch data from MySQL table
$query = "SELECT * FROM table_name";
$result = mysqli_query($connection, $query);

// Output data into HTML table
echo "<table>";
while ($row = mysqli_fetch_assoc($result)) {
    echo "<tr>";
    echo "<td>" . $row['column1'] . "</td>";
    echo "<td>" . $row['column2'] . "</td>";
    echo "<td>" . $row['column3'] . "</td>";
    // Add more columns as needed
    echo "</tr>";
}
echo "</table>";

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

Keywords

PHP MySQL HTML table data output multiple columns

Related Questions