Zend Db Library: How to delete multiple rows with different contraints?

Question

Is it possible to generate that SQL without hacking?

DELETE FROM product WHERE (type=1 AND deleted=1) OR (type=2 AND category=10);

Aref Anafgeh · Accepted Answer · 2016-01-27 10:25:35Z

1

use this sample:

$db->delete(array('(type=1 AND deleted=1) OR (type=2 AND category=10)'));

or if you have a model class for each table so:

$model = new Product();
$model->delete(array('(type=1 AND deleted=1) OR (type=2 AND category=10)'));

answered Jan 27, 2016 at 10:25

Aref Anafgeh

5121 gold badge6 silver badges20 bronze badges

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

4 Comments

Anıl Özselgin Over a year ago

Still it seems like a hacky solution.

Anıl Özselgin Over a year ago

Exec also solves my problem. I want to find a proper way. I was trying to find a more structured way like we do in selects.

Aref Anafgeh Over a year ago

first of all if this solved your problem then you sholud accept my answer..second,this methods create a query in zend db table or zend_db_table_abstract libraries....you can take a look at them to underestand the system

Anıl Özselgin Over a year ago

Thanks for your answer. But in the question i asked for a solution "without hacking". Maybe I was not clear enough. I was trying to find a solution like andX and orX of doctrine. Please check this solution for doctrine stackoverflow.com/questions/9815047/… I'll accept your solution. Thanks for your help.

Collectives™ on Stack Overflow

Zend Db Library: How to delete multiple rows with different contraints?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related