我整晚都在编码,所以我可能忽略了一些东西,但我的输出看起来是这样的:
Apartment Name #1 Apartment Name #1
5.0 5.0
1 1
我希望它看起来像这样:
Apartment Name #1 5.0
这是我的类的方法,称为:
public function apartmentList($zip = '')
{
$this->_zip = $zip;
$list = array();
$sql = 'SELECT DISTINCT apartment.apartmentName, ratings.apartmentOverall, apartment.apartmentID
FROM apartment_information apartment, apartment_ratings ratings, user_user user
WHERE user.preferred_zip = :zip
ORDER BY ratings.apartmentOverall';
try{
$stmt = $this->_db->prepare($sql);
$stmt->bindParam(":zip", $this->_zip, PDO::PARAM_STR);
$stmt->execute();
while($row = $stmt->fetch())
{
$list['apartmentName'] = $row['apartmentName'];
$list['apartmentOverall'] = $row['apartmentOverall'];
$list['apartmentID'] = $row['apartmentID'];
print_r($list);
}
return $list;
}
catch(PDOException $e)
{
echo $e->getMessage();
}
}
这就是我称之为时的样子
include_once 'class.apartment.php';
$apartment = new Apartment($db);
$apartmentList = $apartment->apartmentList($_SESSION['zip']);
foreach($apartmentList as $key => $value){
?>
<li id="listing">
<a href="../template/apartment.php">
<span class="arrow"> </span>
<span class="title">
<?php echo $value; ?>
</span>
<span class="rating">
<?php echo $value; ?>
</span>
</a>
</li>
代码很好,实际上是css的问题。但是,如果您想要确切的格式,请确保使用容器(ul
)包装列表项(li
)。无论如何,这是必须的。
另外,卸下id="listing"
。它不是id应该有的唯一节点。
您要打印两次值,而不是键和值