You can update rows in a database table using the update()
method of a Table class. This method takes two arguments: an associative array of
columns to change and new values to assign to these columns; and an
SQL expression that is used in a WHERE clause,
as criteria for the rows to change in the UPDATE operation.
Example 275. Example of updating rows in a Table
<?php
$table = new Bugs();
$data = array(
'updated_on' => '2007-03-23',
'bug_status' => 'FIXED'
);
$where = $table->getAdapter()->quoteInto('bug_id = ?', 1234);
$table->update($data, $where);
Since the table update() method proxies to the database adapter
update()
method, the second argument can be an array of SQL expressions. The
expressions are combined as Boolean terms using an AND operator.
Note
The values and identifiers in the SQL expression are not quoted
for you. If you have values or identifiers that require quoting, you are responsible
for doing this. Use the quote(),
quoteInto(), and quoteIdentifier()
methods of the database adapter.