To output MySQL data in HTML, you will need to use a server-side scripting language such as PHP or ASP.NET to retrieve data from the MySQL database and generate the HTML output that is sent to the user’s web browser.
For example, in PHP, you can use the mysqli_query function to execute a SQL query and retrieve the results, and then use the mysqli_fetch_assoc function to iterate over the rows of the result set and create the HTML output. The following code demonstrates how to retrieve data from a MySQL table and generate an HTML table to display the results:
<?php
// Connect to the MySQL database
$mysqli = new mysqli("hostname", "username", "password", "database");
// Check for errors
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
// Execute the SQL query
$result = $mysqli->query("SELECT * FROM mytable");
// Check for errors
if (!$result) {
printf("Error: %s\n", $mysqli->error);
exit();
}
// Start the HTML table
echo "<table>\n";
// Print the table headers
echo "<tr>";
$field_info = mysqli_fetch_field($result);
while ($field_info) {
printf("<th>%s</th>", $field_info->name);
$field_info = mysqli_fetch_field($result);
}
echo "</tr>\n";
// Print the table rows
while ($row = $result->fetch_assoc()) {
echo "<tr>";
foreach ($row as $col_value) {
printf("<td>%s</td>", $col_value);
}
echo "</tr>\n";
}
// End the HTML table
echo "</table>\n";
// Free the result set
$result->free();
// Close the database connection
$mysqli->close();
?>
For more information and examples of how to output MySQL data in HTML using PHP, please refer to the PHP documentation and tutorials.
