CODEWITHSUNDEEP
phpmysqlsqlzend-frameworkzend-db
Awan
Awan

Reputation: 18580

How update a database table record in Zend?

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

Upvotes: 22

Views: 43975

Answers (6)

Syed Waqas Bukhary
Syed Waqas Bukhary

Reputation: 5340

For more than one where statement use the following.

$data = array(
    "field1" => "value1",
    "field2" => "value2"
);
$where['id = ?'] = $id;
$where['status = ?'] = $status;

$table = new Table();

$table->update($data, $where);

Upvotes: 4

Alex Pliutau
Alex Pliutau

Reputation: 21957

$data = array(
   'field1' => 'value1',
   'field2' => 'value2'
);
$where = $table->getAdapter()->quoteInto('id = ?', $id)

$table = new Table();

$table->update($data, $where);

Upvotes: 40

zendframeworks
zendframeworks

Reputation: 21

public function updateCampaign($id, $name, $value){
    $data = array(
        'name' => $name,
        'value' => $value,
    );
    $this->update($data, 'id = ?', $id );
}

Upvotes: 2

Srinivas R
Srinivas R

Reputation: 101

just in case you wanna increment a column use Zend_Db_Expr eg: 

$table->update(array('views' => new Zend_Db_Expr('views + 1')),$where);

Upvotes: 10

Tim Lytle
Tim Lytle

Reputation: 17624

Since you're already fetching the row you want to change, it seems simplest to just do:

$row->id = 2;
$row->save();

Upvotes: 12

mitch
mitch

Reputation: 282

   $data = array(
    "field1" => "value1",
    "field2" => "value2"
);

$where = "id = " . $id;

$table = new Table();

$table->update($data, $where);

Upvotes: 1

Related Questions