Magento 选择查询未使用 foreach 循环正确循环 - Magento select query not looping properly using a foreach loop

Magento select query not looping properly using a foreach loop

我写了以下代码：

try {
    $json = array('success' => true);
    $read = $this->read;
    $readresult = $read->fetchAll("SELECT * FROM brand");
    foreach($readresult as $r) {
        $json['brands'][] = array(
            'id'          => $r['brand_id'],
            'name'        => $r['name'],
            'description' => $r['description'],          
        );
    }
    return $json;
} catch (Exception $e) {
    $message = $e->getMessage();
    echo json_encode(array("status" => "500", "error" => $message));
}

在此代码中，我尝试显示数据库表中的所有品牌记录。

但问题是当我尝试输出结果时，它只显示一条记录。

任何人都可以检查问题所在。

上面代码的输出是：

{
"success":true,
"products":[
    {
    "id":"4",
    "name":"Test",
    "href":"http:'/'/localhost:8‌1'/magento'/index.php'/catalog'/product'/view'/id'/4'/",
    "thumb":"http:'/'/localho‌st:81'/magento'/media'/catalog'/product'/cache'/0'/thumbnail'/9df78eab33525d08d6e‌5fb8d27136e95'/images'/catalog'/product'/placeholder'/thumbnail.jpg",
    "pirce":"$11‌1,111.00"
    }
]}

尝试这样，

     $json['brands'] = array();
     foreach($readresult as $r) {
            $brand = array(
                'id'          => $r['brand_id'],
                'name'        => $r['name'],
                'description' => $r['description'],          
            );
     array_push($json['brands'],$brand);
        }