How to update array to database in zend?

Question

I tried update my digit in array to database in zend but i can't My code is:

$tab = array(1,2,3,4,5);
$varData = array('res' => $tab);
$varWhere = array("id = $idUser");      
$this->objDB->update('table_name', $varData, $varWhere);

In database my field "res" is type integer[]. How can i should do it ?

conflict with format array from [] on {}

user3733929
– user3733929

2014-06-12 13:45:40 +00:00
Commented Jun 12, 2014 at 13:45 — user3733929
– user3733929, Commented Jun 12, 2014 at 13:45

Daniel Gadawski · Accepted Answer · 2014-06-12 13:37:47Z

1

It can't be done this way. You've got to prepare your $tab array to be ready to insert as a PostgreSQL array type.

For example:

$tab = array(1,2,3,4,5);
$tabValue = '{' . implode(',', $tab) . '}';
$varData = array('res' => $tabValue);
$varWhere = array('id = ?' => $idUser);      
$this->objDB->update('table_name', $varData, $varWhere);

answered Jun 12, 2014 at 13:37

Daniel Gadawski

1,9434 gold badges20 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

How to update array to database in zend?

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