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

Question

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

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

<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>[e-mail]</td>
    <td>This is the message John sent you</td>
  </tr></table>

然后是“约翰”之下的所有其他值。

Answer 1

试试这个:(完全动态...）<?php $host&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;"localhost";$user&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;"username_here";$pass&nbsp;&nbsp;&nbsp;&nbsp;=&nbsp;"password_here";$db_name&nbsp;=&nbsp;"database_name_here";//create&nbsp;connection$connection&nbsp;=&nbsp;mysqli_connect($host,&nbsp;$user,&nbsp;$pass,&nbsp;$db_name);//test&nbsp;if&nbsp;connection&nbsp;failedif(mysqli_connect_errno()){ &nbsp;&nbsp;&nbsp;&nbsp;die("connection&nbsp;failed:&nbsp;" &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;mysqli_connect_error() &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;"&nbsp;("&nbsp;.&nbsp;mysqli_connect_errno() &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.&nbsp;")");}//get&nbsp;results&nbsp;from&nbsp;database$result&nbsp;=&nbsp;mysqli_query($connection,"SELECT&nbsp;*&nbsp;FROM&nbsp;products");$all_property&nbsp;=&nbsp;array();&nbsp;&nbsp;//declare&nbsp;an&nbsp;array&nbsp;for&nbsp;saving&nbsp;property//showing&nbsp;propertyecho&nbsp;'<table&nbsp;class="data-table"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<tr&nbsp;class="data-heading">';&nbsp;&nbsp;//initialize&nbsp;table&nbsp;tagwhile&nbsp;($property&nbsp;=&nbsp;mysqli_fetch_field($result))&nbsp;{ &nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;'<td>'&nbsp;.&nbsp;$property->name&nbsp;.&nbsp;'</td>';&nbsp;&nbsp;//get&nbsp;field&nbsp;name&nbsp;for&nbsp;header &nbsp;&nbsp;&nbsp;&nbsp;array_push($all_property,&nbsp;$property->name);&nbsp;&nbsp;//save&nbsp;those&nbsp;to&nbsp;array}echo&nbsp;'</tr>';&nbsp;//end&nbsp;tr&nbsp;tag//showing&nbsp;all&nbsp;datawhile&nbsp;($row&nbsp;=&nbsp;mysqli_fetch_array($result))&nbsp;{ &nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;"<tr>"; &nbsp;&nbsp;&nbsp;&nbsp;foreach&nbsp;($all_property&nbsp;as&nbsp;$item)&nbsp;{ &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;'<td>'&nbsp;.&nbsp;$row[$item]&nbsp;.&nbsp;'</td>';&nbsp;//get&nbsp;items&nbsp;using&nbsp;property&nbsp;value &nbsp;&nbsp;&nbsp;&nbsp;} &nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;'</tr>';}echo&nbsp;"</table>";?>

Answer 2

首先，连接到数据库：$conn=mysql_connect("hostname","username","password");mysql_select_db("databasename",$conn);您可以使用它来显示单个记录：例如，如果URL是/index.php?sequence=123，则下面的代码将从表中选择，其中sequence =&nbsp;123。<?php $sql="SELECT&nbsp;*&nbsp;from&nbsp;table&nbsp;where&nbsp;sequence&nbsp;=&nbsp;'".$_GET["sequence"]."'&nbsp;";$rs=mysql_query($sql,$conn)&nbsp;or&nbsp;die(mysql_error());$result=mysql_fetch_array($rs);echo&nbsp;'<table> <tr> <td>Forename</td> <td>Surname</td> </tr> <tr> <td>'.$result["forename"].'</td> <td>'.$result["surname"].'</td> </tr> </table>';?>或者，如果要列出与表中的条件匹配的所有值：<?php echo&nbsp;'<table> <tr> <td>Forename</td> <td>Surname</td> </tr>';$sql="SELECT&nbsp;*&nbsp;from&nbsp;table&nbsp;where&nbsp;sequence&nbsp;=&nbsp;'".$_GET["sequence"]."'&nbsp;";$rs=mysql_query($sql,$conn)&nbsp;or&nbsp;die(mysql_error());while($result=mysql_fetch_array($rs)){echo&nbsp;'<tr> <td>'.$result["forename"].'</td> <td>'.$result["surname"].'</td> </tr>';}echo&nbsp;'</table>';?>