Question

我使用zen,有以下法典。

class Admin_Model_DbTable_Inv extends Zend_Db_Table_Abstract
{
    protected $_name =  test ;
    public function updateproductstock($qty,$pid)
    {
        $data = array(
             stock  =>  stock - 2 
        );
        $this->_db->update($this->_name, $data, product =  .$pid. );
    } 
}

在此,我要从库存中减去我的q。举例来说,2将成为qty.qty 将是动态数据。如何在此使用zen更新。友好帮助。

更新我的职位

Answer 1

 class Admin_Model_DbTable_Inventory extends Zend_Db_Table_Abstract
 {
     protected $_name =  test ;

     public function updateproductstock($qty,$pid)
     {
         $data = array(
              stock  => new Zend_Db_Expr( stock -  .$qty);
         );
         $this->_db->update($this->_name, $data, product =  .$pid. );
     }
 }

Answer 2

 class Admin_Model_DbTable_Inv extends Zend_Db_Table_Abstract
 {
     protected $_name =  test ;

     public function updateproductstock($qty)
     {           
         $r = $this->fetchRow($this->select()->where( product  = ? , 1));
         $r->stock -= $qty;
         $r->save();
         $data = array(
              stock  =>  stock -  .(string) $qty;
         );
         $this->_db->update($this->_name, $data, "product =  1 ");
     }
 }

p: 所有变量均应在美元之前确定。

友情链接