Question

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

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

我也这样做:

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

以及

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

以及

$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 ?

Answer 1

附有<代码>Zend_Db_Adapter,尝试:

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

或者,在这种情况下,你可以:

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

(如果你重新利用愤怒,你把它 cast!)

Answer 2

在您的模式中(Zend_Db_Table_Abstract):

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

或

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

友情链接