How to get Column Name With Zend DB

Question

Perhaps you should describe a little bit what you're trying to do... Apikot's answer is a starting point though. — Stefan Gehrig, Apr 02 '09 at 08:31

score 28 · Accepted Answer · edited Sep 21 '09 at 09:37

28

This is the correct answer, the older answers are wrong or outdated:

$cols = $table->info(Zend_Db_Table_Abstract::COLS);

edited Sep 21 '09 at 09:37

markus

40,136
23
97
142

answered Sep 21 '09 at 09:20

corné

788
7
14

3

rewrote your intro-text since SO doesn't know 'bumping' and questions/answers are not considered old. in fact SO is a wiki and updating it is one of the best things you can do! +1 – markus Sep 21 '09 at 09:39

vartec · Answer 2 · 2009-04-02T08:53:56.487

8

$metadata = $db->describeTable($tableName);
$columnNames = array_keys($metadata);

http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.list-describe

edited Apr 02 '09 at 08:53

answered Apr 02 '09 at 08:29

vartec

131,205
36
218
244

That's not really 100% correct as $metadata is an associative array ('column_name' => array()) of associative arrays (one for each column of the table). – Stefan Gehrig Apr 02 '09 at 08:34
add schame's name to $db->describeTable($tableName, $schema); , i just had an error using oracle which takes old column names if i had changed them and had to specify the schema for it to return right column names – Mouna Cheikhna Mar 05 '12 at 13:34

score 2 · Answer 3 · edited May 22 '13 at 11:16

Previous answer applies only to version < 2.
For current version of ZF (2.2) use:

$table = new Zend\Db\TableGateway\TableGateway('table', $Dbadapter, new Zend\Db\TableGateway\Feature\MetadataFeature());
$columns = $table->getColumns();

http://framework.zend.com/manual/2.2/en/modules/zend.db.table-gateway.html#tablegateway-features http://framework.zend.com/manual/2.2/en/modules/zend.db.metadata.html

score 0 · Answer 4 · answered May 23 '13 at 21:25

0

I like this way:

$table->info('cols');

answered May 23 '13 at 21:25

Diogo Alves

378
2
13

score 0 · Answer 5 · answered Apr 02 '09 at 08:23

0

You could use the describeTable method

answered Apr 02 '09 at 08:23

Andrei Serdeliuc ॐ

5,828
5
39
66

How to get Column Name With Zend DB

5 Answers5

Linked