donglin9068
2010-09-20 23:26
浏览 86
已采纳

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

To use where in a MySQL table row update in Zend Framework I have something like:

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

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

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

and this, I expect, gives me something like...

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

But what if I want to create the following:

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

In the manual I don't see how to do this with quoteInto (or quote or some other safe method... which could just mean I'm looking in the wrong place but... sigh).

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douyouyi8878 2010-09-20 23:44
    已采纳

    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);
    

    Resulting SQL is:

    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

    已采纳该答案
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题