php - Zend Framework - 使用 WHERE 和 AND 更新数据库行

Question

要在 Zend Framework 的 MySQL 表行更新中使用 where，我有类似的东西:

public function updateBySiteId(array $data, $id) {
        $table = $this->gettable();

        $where = $table->getAdapter()->quoteInto('site_id = ?', $id);

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

我希望这能给我类似...

UPDATE foo SET ponies = 'sparkly' WHERE site_id = '1'

但是如果我想创建以下内容怎么办:

UPDATE foo SET ponies = 'sparkly' WHERE site_id = '1' AND type = 'zombie'

在手册中，我没有看到如何使用 quoteInto(或 quote 或其他一些安全方法...这可能只是意味着我找错了地方但是...叹息).

Answer 1

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.

http://framework.zend.com/manual/en/zend.db.table.html

$data = array(
'updated_on'      => '2007-03-23',
'bug_status'      => 'FIXED'
);
$where[] = "reported_by = 'goofy'";
$where[] = "bug_status = 'OPEN'";
$n = $db->update('bugs', $data, $where);

结果 SQL 是:

UPDATE "bugs" SET "update_on" = '2007-03-23', "bug_status" = 'FIXED' WHERE ("reported_by" = 'goofy') AND ("bug_status" = 'OPEN')

http://framework.zend.com/manual/en/zend.db.adapter.html#zend.db.adapter.write.update