How to convert zend_db_table_rowset object to javascript array

Question

how to convert zend_db_table_rowset object to javascript array

$db=new Application_Model_DbTable_Books();
        $result=$db->showBooks();

showBooks:

class Application_Model_DbTable_Books extends Zend_Db_Table_Abstract
{

    protected $_name = 'books';
    protected $_primary = 'id';
    public function showBooks(){
            return $this->fetchAll();


}

} I want to convert the result set in to something liket this:

  var aDataSet = [
                ['Trident','Internet Explorer 4.0','Win 95+','4','X'],
                ['Trident','Internet Explorer 5.0','Win 95+','5','C'],
                ['Trident','Internet Explorer 5.5','Win 95+','5.5','A'],
                ['Trident','Internet Explorer 6','Win 98+','6','A']];

Where's the catch? Just foreach over the rowset, no?

bububaba
– bububaba

2012-08-09 07:43:24 +00:00
Commented Aug 9, 2012 at 7:43 — bububaba
– bububaba, Commented Aug 9, 2012 at 7:43

Vadyus · Accepted Answer · 2012-08-09 08:10:57Z

1

JSON fits bettew for such operations

Inside controller

$db=new Application_Model_DbTable_Books();
$result=$db->showBooks();    
$this->view->booksJson = Zend_Json::encode($result);

Inside view script

var aDataSet = JSON.parse(<?php echo $this->booksJson;?>);

answered Aug 9, 2012 at 8:10

Vadyus

1,3298 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

How to convert zend_db_table_rowset object to javascript array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related