如何在Zend中更新数据库表记录？

Question

我使用 select 语句进行如下查询，它可以成功地获取记录：

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

但现在我想更新同一条记录。例如，在简单的MySQL中。

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

如何在Zend中执行上述查询？

谢谢

- Awan

Answer 1

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

$table = new Table();

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

- Alex Pliutau

---

你先生因使用$where = $table->getAdapter()->quoteInto('id = ?', $id)的快捷方式获得奖励分数。 - Richard Ayotte

Answer 2

既然您已经获取了要更改的行，似乎最简单的方法就是执行：

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

- Tim Lytle

Answer 3

如果您想增加一列，请使用Zend_Db_Expr 例如：

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

- Srinivas R

Answer 4

若要使用多个where语句，请按照以下方式操作。

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

$table = new Table();

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

- Syed Waqas Bukhary

Answer 5

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

- zendframeworks

Answer 6

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

$where = "id = " . $id;

$table = new Table();

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

- mitch