在网页上的HTML表格中显示MySQL数据库表中的值

问题描述

我想从数据库表中检索值并在页面的html表中显示它们。
我已经搜索了这个，但我找不到答案，虽然这肯定是容易的（这应该是数据库的基础知识lol）。我想我搜索过的词语有误导性。
数据库表名称是票证，它现在有6个字段（submission_id，formID，IP，名称，电子邮件和消息），但是应该有另一个名为ticket_number的字段。
如何在html表格中显示db中的所有值，如下所示：

I want to retrieve the values from a database table and show them in a html table in a page.I already searched for this but I couldn't find the answer, although this surely is something easy (this should be the basics of databases lol). I guess the terms I've searched are misleading.The database table name is tickets, it has 6 fields right now (submission_id, formID, IP, name, email and message) but should have another field called ticket_number.How can I get it to show all the values from the db in a html table like this:

<table border="1">
  <tr>
    <th>Submission ID</th>
    <th>Form ID</th>
    <th>IP</th>
    <th>Name</th>
    <th>E-mail</th>
    <th>Message</th>
  </tr>
  <tr>
    <td>123456789</td>
    <td>12345</td>
    <td>123.555.789</td>
    <td>John Johnny</td>
    <td>[email protected]</td>
    <td>This is the message John sent you</td>
  </tr>
</table>

然后是'john'以下的所有其他值。

And then all the other values below 'john'.

推荐答案

取自W3Schools的示例：

Example taken from W3Schools: PHP Select Data from MySQL

<?php
$con=mysqli_connect("example.com","peter","abc123","my_db");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM Persons");

echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";

while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['FirstName'] . "</td>";
echo "<td>" . $row['LastName'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysqli_close($con);
?>

这是一个值得学习的好地方！

It's a good place to learn from!

这篇关于在网页上的HTML表格中显示MySQL数据库表中的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！