Zend_Db does not delete table row

Question

Does anyone know, if there is a bug in CRUD in delete operations. DB Adapter:

$this->_db = Zend_Registry::get("db");

I do like this:

$sql = "DELETE FROM premium_items WHERE id = '$id'";
                    $stmt = new Zend_Db_Statement_Pdo($this->_db, $sql); 
                    return $stmt->execute();

and

$sql = "DELETE FROM premium_items WHERE id = ?";
                $stmt = new Zend_Db_Statement_Pdo($this->_db, $sql); 
                return $stmt->execute(array($id));

and

$this->_db->delete('premium_items', "id = '$id'");

Each variant works without any errors but does not do what it has to do. What can I do in such situation ?

Rob Allen · Accepted Answer · 2012-04-11 10:05:02Z

1

With a Zend_Db_Adapter, try:

$this->_db->delete('premium_items', array("id = ?" => $id));

or, in this particular case you can do:

$this->_db->delete('premium_items', 'id = ' . (int)$id);

(but only do this one if you're using an integer and you cast it!)

answered Apr 11, 2012 at 10:05

Rob Allen

12.8k1 gold badge43 silver badges52 bronze badges

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

1 Comment

Nikita Gopkalo Over a year ago

Found the solution, everybody was right, one just always has to check if the transaction is committed :(

TeChn4K · Accepted Answer · 2012-04-11 10:07:49Z

1

In your model (Zend_Db_Table_Abstract):

$row = $this->find($id)->current();
$row->delete();

Or

$db = $this->getAdapter();
$db->delete($table, $db->quoteInto("id = ?", $id));

answered Apr 11, 2012 at 10:07

TeChn4K

2,4032 gold badges22 silver badges23 bronze badges

2 Comments

Nikita Gopkalo Over a year ago

I actually have this already:

public function __construct(Zend_Db_Table_Abstract $dbTable, $id) { 	$this->_dbTable = $dbTable; 	if ($id) { 		$this->_row = $this->_dbTable->find($id)->current(); 	} else { 		$this->_row = $this->_dbTable->createRow(); 	} }

then public function delete() { return $this->_row->delete(); }

TeChn4K Over a year ago

I already had this probleme, without find any solution with zend_db_table function.. I solve this with my last code

Collectives™ on Stack Overflow

Zend_Db does not delete table row

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related