如何在没有定义列的html表中显示sqli select查询结果

问题描述：

I want to display the results of my select query on my webpage in a table, however the code im using at the moment uses a pre-defined set of columns. My code is this:

   $result= mysqli_query($con,"SELECT * FROM Customers where First_name = '$specFirstName'");

echo "<table border=\"1px solid black\" width=\"80%\"><tr><th>Customer ID</th><th >First Name</th><th>Last Name</th></tr>" ;
while($row = mysqli_fetch_array($result)){
   echo "<tr><td style=\"text-align:center;\">". $row[('CustomerID')] . "</td><td style=\"text-align:center;\">".$row[('First_name')]."</td><td style=\"text-align:center;\">".$row[('Last_name')];
  echo "</td></tr>";
  }
  echo "</table>"

Now, How can I do the same, but use the database headers in an automatically generated table? Can I also use this method to allow the user to specify the required columns in the query? Many thanks, Tommy

我想在表格的网页上显示我的选择查询的结果，但是我在时刻使用预定义的一组列。我的代码是： p>

  $ result = mysqli_query（$ con，“SELECT * FROM Customers其中First_name ='$ specFirstName'”）; 
 
echo“＆lt; table  border = \“1px solid black \”width = \“80％\”＆gt;＆lt; tr＆gt;＆lt; th＆gt;客户ID＆lt; / th＆gt;＆lt; th＆gt;名字＆lt; / th＆gt;＆lt; th＆gt;姓氏＆lt;  ; /第＆GT;＆LT; / TR＆gt;”中 ; 
while（$ row = mysqli_fetch_array（$ result））{
 echo“＆lt; tr＆gt;＆lt; td style = \”text-align：center; \“＆gt;”。  $ row [（'CustomerID'）]。  “＆lt; / td＆gt;＆lt; td style = \”text-align：center; \“＆gt;”。$ row [（'First_name'）]。“＆lt; / td＆gt;＆lt; td style = \”text-  align：center; \“＆gt;”。$ row [（'Last_name'）]; 
 echo“＆lt; / td＆gt;＆lt; / tr＆gt;”; 
} 
 echo“＆lt; / table＆gt;”\  n  code>  pre> 
 
 现在，我该怎么做，但在自动生成的表中使用数据库头？ 我是否也可以使用此方法允许用户在查询中指定所需的列？
很多，谢谢，
Tommy  p> 
  div>

答

Something like this should work. You only have to define the $columns you want to display in the array map. This also works once you write the code to allow the user to select the columns she/he wants, you will only have to set this map with the selected options.

// Define the columns title and name in this array map.
$columns = array(
  'Customer ID' => 'CustomerID', 
  'First Name' => 'First_name',
  'Last Name' => 'Last_name'
);
// Run the query
$result= mysqli_query($con,"SELECT * FROM Customers WHERE First_name = '$specFirstName'");

// Output table header
echo "<table border=\"1px solid black\" width=\"80%\"><tr>";
foreach ($column as $name => $col_name) {
  echo "<th>$name</th>";
}
echo "</tr>";

// Output rows 
while($row = mysqli_fetch_array($result)) {
  echo "<tr>";
  foreach ($column as $name => $col_name) {
    echo "<td style=\"text-align:center;\">". $row[$col_name] . "</td>";
  }
  echo "</tr>";
}
// Close table
echo "</table>"

答

You can fetch the fields before the while loop like

$fields = ($result->fetch_fields());

?> <table border="1px solid black" width="80%"><tr> <?php
foreach($fields as $field) { 
    ?> <th><?php echo $field->name; ?></th> <?php
}
?> </tr> <?php
while($row = mysqli_fetch_array($result)){
  ?><tr><?php

  foreach($row as $val) {
        ?> <td style="text-align: center;"> <?php echo $val; ?> </td> <?php
  } 

  ?> </tr> <?php
}
?> </table> <?php

如何在没有定义列的html表中显示sqli select查询结果

相关推荐