Alex Rivera | Logout

How update a database table record in Zend?

Asked 2010-11-04T13:43:22.570
22

I am using select like this and it is fetching record successfully:

$table = new Bugs();
$select = $table->select();
$select->where('bug_status = ?', 'NEW');
$rows = $table->fetchAll($select);

But Now I want to update same record. For example in simple MySQL.

UPDATE TableName Set id='2' WHERE id='1';

How to execute above query in Zend ?

Thanks

php mysql sql zend-framework zend-db
Edit
Report

2 Answers

2
public function updateCampaign($id, $name, $value){
    $data = array(
        'name' => $name,
        'value' => $value,
    );
    $this->update($data, 'id = ?', $id );
}
answered 2012-09-07T09:33:39.577
1
   $data = array(
    "field1" => "value1",
    "field2" => "value2"
);

$where = "id = " . $id;

$table = new Table();

$table->update($data, $where);
answered 2010-11-04T13:49:43.207

Your Answer