add column to select object zend framework

Question

Here is my current code:

$Select=new Select();
$Select->from($this->getTable());

What I want now is to add the id column but as DT_RowId instead of id. How do I accomplish this? The goal would be to have all of the table columns as well as this new column.

Could you edit your post and add the rest of your table definition? preferably one of your current situation and one of the desired situation. — Dymen1, May 22 '17 at 09:07

score 1 · Answer 1 · answered May 22 '17 at 17:20

The simplest soloution would be to use the columns function with an associative array with aliases as the keys for example:

$select=new Select();
$select->from($this->getTable());
$select->columns(array(
 'DT_RowId' => 'id',
 'furtherColumn' => 'furtherColumn',
));

score 1 · Accepted Answer · answered May 31 '17 at 21:07

1

If you need both "old" and "new" fields, don't forget to add an asterisk.

$Select=new \Zend\Db\Sql\Select();
$Select->from($this->getTable());
$Select->columns([
  '*', 
  'DT_RowId' => 'id',
  'furtherColumn' => 'furtherColumn'
]);

answered May 31 '17 at 21:07

akond

15,865
4
35
55

add column to select object zend framework

2 Answers2