Write update query in php to update set of rows - Zend framework

Question

I use the following code:

$str= array('createdid' => $creator_newid);  
$where = array();
$where['id IN']  = $instance_ids;
$this->_table->update($str, $where);

And here the $instance_ids contains set of string (that is 1, 2, 3, 4, 5, 6…) and I'm getting zend error.

How do I solve this?

As you mentioned, $instance_ids is a set of string, this might be the problem. Please check with an array. — prava
– prava, Commented May 29, 2014 at 10:55
yeah, got some alternative way, sending them in quotes ('1','2','3',...) and also changed the update statement.. thank you @Prava-MindfireSolutions — SantMania
– SantMania, Commented May 29, 2014 at 11:16

kaustubh badamikar · Accepted Answer · 2014-05-29 12:01:42Z

4

Use Zend_Db_Abstract methods like

public function updatestatus($updateAry,$id) {

            if(!empty($id)) {
                try{
                        $res = $this->getDbTable()->update($updateAry, array('user_id=?'=>$id));
                        if (false === $res) {
                            return 0;  // bool false returned, query failed
                        } else {
                            return 1;
                        }
                } catch (Zend_Exception $zex){}
            }
    }

here

$updateAry is the data you want to update.

array('user_id=?'=>$id) It is like were clause

answered May 29, 2014 at 12:01

kaustubh badamikar

6826 silver badges15 bronze badges

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

Comments

php-dev · Accepted Answer · 2014-05-29 11:42:06Z

1

Use the Zend_Db_Adapter methods

$str = array('createdid' => $creator_newid);  
$where = array(
    $this->_table->getAdapter()->quoteInto('id IN(?)', $instance_ids))
);
$this->_table->update($str, $where);

The adapter will carefully escape and quote params for you.

answered May 29, 2014 at 11:42

php-dev

7,1864 gold badges27 silver badges39 bronze badges

Collectives™ on Stack Overflow

Write update query in php to update set of rows - 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