zend framework update problem(update multiple rows)

Question

i want to update multiple rows in DB using Zend Framework(Zend_db). i want to add 2 to one field of each row what should i use? im a beginner to ZF.

karim79 · Accepted Answer · 2010-05-16 12:13:02Z

1

$row = array('theColumnName' => new Zend_Db_Expr('theColumnName + 2'));
$where = "id > 50"; 
// leave out the $where parameter to update all rows.
$nRowsUpdated = $db->update('tableName', $row, $where);

if you have multiple where conditions, you can do this:

$where = array();
$where[] = "foo = something";
$where[] = "id > something";

You should read the Zend_Db reference guide, which has plenty of examples.

edited May 16, 2010 at 12:13

answered May 16, 2010 at 11:41

karim79

343k67 gold badges420 silver badges409 bronze badges

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

1 Comment

armin etemadi Over a year ago

$row = array('theColumnName1' => new Zend_Db_Expr('theColumnName1 + 2') , 'theColumnName2' => new Zend_Db_Expr('theColumnName2 + 2')); $where = "condition1 and condition2"; is it right if i use that like this one?

Collectives™ on Stack Overflow

zend framework update problem(update multiple rows)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related