Update query using dynamic data in zend?

Question

I am using zend, I have the following code like

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.');
    } 
}

Here,I want to subtract my qty from stock.For example 2 will be qty. qty will be dynamic data .How can i use zend update here. kindly help.

Updated my post

$db-> refers to a database object (class). Please can you post the class to which this piece of code refers? Or at least the 'update' function — Luke
– Luke, Commented Oct 4, 2011 at 10:35
@luc, I agree the question is a little vagueness but with the reference to zend framework you can imagine that it refers to framework.zend.com/manual/en/zend.db.adapter.html and his update method. — Guilhem Hoffmann
– Guilhem Hoffmann, Commented Oct 4, 2011 at 10:41
@LukeCoulton This is Zend Framework, update is a method from Zend_Db. — Matthieu Napoli
– Matthieu Napoli, Commented Oct 4, 2011 at 11:43
Apologies, I missed the zend-framework tag. I use the zend studio purely for programming. — Luke
– Luke, Commented Oct 4, 2011 at 11:56

Matthieu Napoli · Accepted Answer · 2011-10-04 11:45:53Z

2

 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.');
     }
 }

edited Oct 4, 2011 at 11:45

answered Oct 4, 2011 at 11:28

Matthieu Napoli

50k49 gold badges188 silver badges273 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

mymotherland Over a year ago

Actually i want to subtract the stock value from qty in test table

Matthieu Napoli Over a year ago

Well then read the current stock value from the database, and use the code of my answer (I am going to edit it)

mymotherland Over a year ago

Yes , But suppose if i have 10 products in my cart, I will loop this updateproductstock function .Then it will take some time to execute. This will not be effective then.

mymotherland Over a year ago

sorry for my mistake.I gave it for only example...will update the post now

Matthieu Napoli Over a year ago

Ok I finally got what you wanted to do. See my edit, maybe a Zend_Db_Expr will do, it will prevent the string from being escaped by Zend_Db (so it will be a valid SQL expression).

Guilhem Hoffmann · Accepted Answer · 2011-10-04 11:51:25Z

0

 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'");
     }
 }

ps: All the variables should be prefix with $

edited Oct 4, 2011 at 11:51

answered Oct 4, 2011 at 10:38

Guilhem Hoffmann

9625 silver badges13 bronze badges

3 Comments

mymotherland Over a year ago

$values = array('stock' => 'stock - 2'); $oDb->update('test', $values, 'product_id = 34'); this updates 0 value in current_stock, and when i run this $values = array('stock' => '41 -'.(string)2); $oDb->update('test', $values, 'product_id = 34'); it updates 41 as stock and it does not subtract the stock. SO this query is not working.

Matthieu Napoli Over a year ago

@Dinesh you are getting 0 probably because your column is INT, so if you fill it with a string, it will be converted to an integer (which will give here 0). See my answer, maybe it will work.

Guilhem Hoffmann Over a year ago

@Matthieu you're right, I don't understand as long as no variable could be recognized...

Collectives™ on Stack Overflow

Update query using dynamic data in zend?

2 Answers 2

5 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related