Output multiple rows in json in Zend Framework 1

Question

I've searched and can't find an answer to my question.

I have the following code which is to loop through an array and then fetch back results for the different $id's.
The output when using echo json_encode($row); returns all results but the zend layout displays.
However when using $this->_helper->json($row,true); the layout doesn't display but only one result returns.

How can I return more than one result?

Any help would be much appreciated.

public function testAction()

{



    //Get latest revision from database and loop through $id's
    $id = array('308', '307', '306');

    //Connect to database

    foreach($id as $lId) {

        $db = Zend_Db_Table::getDefaultAdapter();


        $select = $db->select('')
            ->from('LinktagRevisions')
            ->where('linktagId = ?', $lId)
            ->order('updated DESC')
            ->limit(1);

        $stmt = $select->query();
        while ($row = $stmt->fetch()) {


            $this->_helper->json($row,true);
    //Encode as json and echo result
           // echo json_encode($row);
        }


    }

}

doydoy44 · Accepted Answer · 2015-01-28 10:59:38Z

1

I think you can try this:

$result = array();
foreach($id as $lId) {
    ....
    $stmt = $select->query();
    $result[$lId] = $stmt->fetchAll();

}
$this->_helper->json($result,true);

edited Jan 28, 2015 at 10:59

answered Jan 28, 2015 at 10:53

doydoy44

5,8004 gold badges31 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ripwinder Over a year ago

Thanks, but that still only seems to return one result.

doydoy44 Over a year ago

Sorry, I forget the 1rst loop. I update the answer. And I add Id index

doydoy44 Over a year ago

You're welcome! Thank's for your return. :) Good Luck.

Collectives™ on Stack Overflow

Output multiple rows in json in Zend Framework 1

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related