Zend db table - save() not saving

Question

I cannot update an entry in my table. The code I am using is below:

class Model_Notification extends Zend_Db_Table_Abstract
{
    protected $_name = "notifications";
    public function encrypt($id,$key)
    {
        $select = $this->select();
        $select->where('id = ?', $id);
        $row = $this->fetchRow($select);

        if( $row )
        {
            $row->key = $key;
            $row->save();
            return true;
        }
        return false;

    }
}

At first, I thought it might be the column name "key", so I changed it to "passkey" but no success. I am getting true returned to me every time!

I can still add/delete to the table, but I canon understand why this update save() does not work!

Cheers,

Sudhir Bastakoti · Accepted Answer · 2011-12-06 16:13:16Z

2

Try this:

$data = array(
    "field1" => "value1",
    "field2" => "value2"
);
$where = "id = " . $id;

$table = new Table();
$table->update($data, $where);

answered Dec 6, 2011 at 16:13

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

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

Comments

rizon · Accepted Answer · 2013-09-03 19:52:25Z

1

The more optimised way

$table = new Table();
$data = array(
    "field1" => "value1",
    "field2" => "value2"
);
$where = $table->getAdapter()->quoteInto("id = ?",$id);


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

edited Sep 3, 2013 at 19:52

rizon

8,1971 gold badge29 silver badges17 bronze badges

answered Dec 8, 2011 at 8:58

coolguy

7,9549 gold badges48 silver badges72 bronze badges

Collectives™ on Stack Overflow

Zend db table - save() not saving

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related