Zend: How to use multiple conditions at delete time?

September 20, 2011 | In: mysql, php, web development, Zend Framework

Zend provides a facility to delete a row from the database table using the delete() method. This method takes one argument, which is an SQL expression that is used in a WHERE clause, as criteria for the rows to delete.

For example :

$modelObj = new ModelName();
$where = $modelObj >getAdapter()->quoteInto('id = ?', '1235');
$modelObj >delete($where);

The second argument can be an array of SQL expressions. The expressions are combined as Boolean terms using an AND operator.
Since the table delete() method proxies to the database adapter delete() method, the second argument can be an array of SQL expressions. The expressions are combined as Boolean terms using an AND operator.

Sometimes, we need to use multiple conditions to delete a row from database.

We can do this by:

$condition = array(
    'conditionField1 = ?' => 'value1',
    'conditionField2 = ?' => 'value2'
);

We can create an array of conditions and pass to zend db delete function.

$db = Zend_Registry::get("db");
$db->delete('TABLE_NAME', $condition);

It will create query like below to delete records from table:

<i>DELETE FROM tbl_name WHERE conditionField1 = 'value1' AND conditionField2 = 'value2';</i>

That’t it.

You may also like these related posts

Categories

By Google