How to Display MySQL Database Table Data as an HTML Table on a Webpage?

Show Values from MySQL Database Table in HTML Table on a Webpage

Querying the Database

To retrieve the values from a MySQL database table, you'll first need to connect to the database and execute a query. Consider the following PHP code:

$con = mysqli_connect("localhost", "database_user", "database_password", "database_name");
$result = mysqli_query($con, "SELECT * FROM tickets");

Here, we connect to the database using mysqli_connect and then execute the SELECT * FROM tickets query to fetch all the rows from the tickets table.

Displaying the Results in HTML Table

Once the results are retrieved, you can use HTML to create a table and display the values.

echo "

"; echo ""; while ($row = mysqli_fetch_array($result)) { echo ""; } echo "

Submission ID	Form ID	IP	Name	E-mail	Message
{$row['submission_id']}	{$row['formID']}	{$row['IP']}	{$row['name']}	{$row['email']}	{$row['message']}

";

In this code, we start by creating a table with headers. Then, we use a while loop to iterate through the result and create a new row for each row in the table. The values from each row are obtained using the $row['column_name'] syntax.

Complete Code Example

Combining the query and display code, we get the following complete code:

";
echo "
Submission ID
Form ID
IP
Name
E-mail
Message
";
while ($row = mysqli_fetch_array($result)) {
    echo "
{$row['submission_id']}
{$row['formID']}
{$row['IP']}
{$row['name']}
{$row['email']}
{$row['message']}
";
}
echo "";
?>

This code will retrieve the values from the tickets table and display them in an HTML table on a webpage.

The above is the detailed content of How to Display MySQL Database Table Data as an HTML Table on a Webpage?. For more information, please follow other related articles on the PHP Chinese website!