Read multiple rows from column + zend framework

Question

I want to load all my rows of column "name" in my table "districts".

I can already read the first row but not more then that.

My Controller:

public function showdataAction()
    {
        $districtMapper = new Backoffice_Model_DistrictMapper();
        $array = $districtMapper->read();    
        Zend_Debug::dump($array);     
    }

My DistrictMapper:

public function read()
    {
        $table = $this->_dbTable;    
        $columns = array('wijk' => 'wijk',   'coords' => 'coords', );    
        $select = $table->select() ->from($table, $columns) ->order('wijk ASC');
        if ($row = $table->fetchRow($select)) {
           return $row->toArray();
        }    
       throw new Exception('The requested data cannot be found');
    }

In my Controller I have Zend_Debug::dump($array) and the result is:

array(2) {
  ["wijk"] => string(10) "Binnenstad"
  ["coords"] => string(2186) "3.72448685517794,51.0601522198842,
                 0 3.72577413282654,51.0597215800093,0 3.72594328459339,
                 51.0600395135711,0 3.72699385985136, 51.060876600363,
                 0 3.72764765694006,51.0608474287073,
                 0 3.7281167878913,51.0605006616679,0 3.72955689560896,
                 51.059999738927"
}

Only the first row ... How can I can convert the read function so I can load all the rows?

RockyFord · Accepted Answer · 2013-01-23 09:59:16Z

1

public function read()
    {
        $table = $this->_dbTable;    
        $columns = array('wijk' => 'wijk',   'coords' => 'coords', );    
        $select = $table->select() ->from($table, $columns) ->order('wijk ASC');
        //try/catch might make more sense as fetchAll() returns an object or an exception.
        $result = $table->fetchAll($select)

        return $result->toArray();

    }

Change fetchRow() to fetchAll(). fetchRow() returns one row object or null, fetchAll() returns a rowset object (array of row objects) or an exception/fatal error.

answered Jan 23, 2013 at 9:59

RockyFord

8,5191 gold badge17 silver badges22 bronze badges

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

Comments

Arun Killu · Accepted Answer · 2013-01-22 13:53:57Z

0

if ($row = $table->fetchRow($select)) {
           return $row->toArray();
       }

change that portion of code to

return $your_database_object->fetchAll($select);

edited Jan 22, 2013 at 13:53

answered Jan 22, 2013 at 13:18

Arun Killu

14.3k5 gold badges38 silver badges66 bronze badges

Collectives™ on Stack Overflow

Read multiple rows from column + zend framework

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related