需要一行数组值而不是一列


Want a row of array values not a column

我整晚都在编码,所以我可能忽略了一些东西,但我的输出看起来是这样的:

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">&nbsp;</span>
                                <span class="title">
                                    <?php echo $value; ?>
                                </span>
                                <span class="rating">
                                    <?php echo $value; ?>
                                </span>
                            </a>    
                            </li>                   

代码很好,实际上是css的问题。但是,如果您想要确切的格式,请确保使用容器(ul)包装列表项(li)。无论如何,这是必须的。

另外,卸下id="listing"。它不是id应该有的唯一节点。

您要打印两次值,而不是键和值