duanji2002 2010-08-24 13:18
浏览 19
已采纳

Zend框架Mysql更新

I need to execute this simple mysql query in Zend;

"UPDATE `table` SET `field`='field'+1 WHERE `field`>'" . $var . "'"

How can I do this with Zend update;

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

But we hasn't data, we have only where.

  • 写回答

1条回答 默认 最新

  • dso407787736 2010-08-24 13:29
    关注

    How can you update a table if you don't know what are you going to update.

    By the way, this is what I found in the Zend Framework Documentation

    $table = new Bugs();
    $data = array(
    'updated_on' => '2007-03-23',
    'bug_status' => 'FIXED'
    );
    
    $where = $table->getAdapter()->quoteInto('bug_id = ?', 1234);
    $table->update($data, $where);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 微信小程序协议怎么写
  • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
  • ¥15 java写代码遇到问题,求帮助
  • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
  • ¥15 有了解d3和topogram.js库的吗?有偿请教
  • ¥100 任意维数的K均值聚类
  • ¥15 stamps做sbas-insar,时序沉降图怎么画
  • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看