Zend Framework DB table fetch array

Question

is it possible to fetch array from db, taking one column as array key and other column as array value?

My current code:

$table = new Zend_Db_Table('translations');

$where = $table->getAdapter()->quoteInto('lang = ?', $locale);      

$result = $table->fetchAll($where)->toArray();

Table structure:

id     key     lang     title
1      key1    en       Some english text
2      key2    de       Some german text

So after fetching an array I would like to get array that contains key value as a array key, and a title as a array key value.

Your help would be appreciated.

Just a small note. Similar, but more general function is ->fetchAssoc(). — sumid
– sumid, Commented May 23, 2013 at 19:27

Vadyus · Accepted Answer · 2012-11-30 12:58:02Z

4

If you need pairs, it's better to do like this

$table = new Zend_Db_Table ('translations');
$db = $table->getAdapter();
$select = $table->select ()
    ->columns(array('key','title'))
    ->where ('lang = ?', $locale);
$result = $db->fetchPairs($select);

answered Nov 30, 2012 at 12:58

Vadyus

1,3298 silver badges19 bronze badges

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

Comments

akond · Accepted Answer · 2012-11-30 12:28:20Z

1

I'm not sure what you mean, but let's try this:

    $table = new Zend_Db_Table ('translations');
    $query = $table->select ()
        ->where ('lang = ?', $locale);

    $results = $table->getAdapter ()
        ->fetchAll ($query, array (), Zend_Db::FETCH_GROUP);

    Zend_Debug::dump ($results);

answered Nov 30, 2012 at 12:28

akond

16.1k4 gold badges37 silver badges58 bronze badges

Collectives™ on Stack Overflow

Zend Framework DB table fetch array

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