如何使用php将sql查询的结果输入到html表中 [英] How to enter enter the results from an sql query into a html table with php
问题描述
我正在寻找一种解决方案,通过它循环遍历我的数据库查询中的每条记录,并在具有固定表标题的 html 表中为其提供自己的行.下面是我用来查询数据并获得结果的当前 php.我的表的每个标题名称是:PropertyType、Description、RentPrice 和 Location.但是由于某种原因,当我尝试运行我的代码时,屏幕上没有显示任何内容
I'm looking for a solution whereby it loops through each record in my database query and gives it it's own row in a html table with fixed table headings. Below is the current php I use to query the data and get results. Each of the heading names for my table are: PropertyType, Description, RentPrice and Location. However for some reason when I try to run my code nothing is shown on the screen
<!DOCTYPE html>
<html lang="en">
<body>
<p style ="text-align: center" id="php_style">
<?php
error_reporting(E_ERROR | E_PARSE);
session_start();
$counter_name = "counter.txt";
// Check if a text file exists. If not create one and initialize it to zero.
if (!file_exists($counter_name)) {
$f = fopen($counter_name, "w");
fwrite($f,"0");
fclose($f);
}
// Read the current value of our counter file
$f = fopen($counter_name,"r");
$counterVal = fread($f, filesize($counter_name));
fclose($f);
// Has visitor been counted in this session?
// If not, increase counter value by one
if(!isset($_SESSION['hasVisited'])){
$_SESSION['hasVisited']="yes";
$counterVal++;
$f = fopen($counter_name, "w");
fwrite($f, $counterVal);
fclose($f);
}
echo nl2br ("You are visitor number ".$counterVal. " to this site \n Today's date is ". date("d/m/Y"));
$con=mysqli_connect("localhost:8889","root","root","booksmart_properties");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else{
echo "we connected";
}
// Perform queries
$result=mysqli_query("SELECT * FROM ListedProperties"); ?> </p>
<table border="2" style= "background-color: #84ed86; color: #761a9b; margin: 0 auto;" >
<thead>
<tr>
<th>PropertyType</th>
<th>Description</th>
<th>RentPrice</th>
<th>Location</th>
</tr>
</thead>
<tbody>
<?php
while( $row = mysqli_fetch_assoc( $result ) ){
echo
"<tr>
<td>{$row\['PropertyType'\]}</td>
<td>{$row\['Description'\]}</td>
<td>{$row\['RentPrice'\]}</td>
<td>{$row\['Location'\]}</td>
</tr>\n";
}
?>
</tbody>
</table>
<?php mysql_close($connector); ?>
//$result=mysqli_fetch_assoc($sql);
//foreach($result as $key => $val) {
//print $val;
//}
//echo $result['*'];
//mysqli_close($con);
//?>
我知道这可能是微不足道的,但我是 php 的新手,希望能得到所有帮助.
I know it may be trivial but I'm new to php and would appreciate all the help I could get.
推荐答案
这是一个简单的解决方案:
Here's a simple solution:
while ( $row = mysqli_fetch_assoc( $result ) ){?>
<tr>
<td><?=$row['PropertyType']?></td>
<td><?=$row['Description']?></td>
<td><?=$row['RentPrice']?></td>
<td><?=$row['Location']?></td>
</tr>
<?php
}
这篇关于如何使用php将sql查询的结果输入到html表中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!