Example of a Multi Condition Delete with Zend framework

Question

Can someone give me an example of how I would delete a row in mysql with Zend framework when I have two conditions?

i.e: (trying to do this)

"DELETE FROM messages WHERE message_id = 1 AND user_id = 2"

My code (that is failing miserably looks like this)

// is this our message?
$condition = array(
                   'message_id = ' => $messageId,
                   'profile_id = ' => $userId
);

$n = $db->delete('messages', $condition);

robbie · Accepted Answer · 2010-07-31 12:16:31Z

29

Better to use this:

$condition = array(
    'message_id = ?' => $messageId,
    'profile_id = ?' => $userId
);

The placeholder symbols (?) get substituted with the values, escapes special characters, and applies quotes around it.

answered Jul 31, 2010 at 12:16

robbie

1,1031 gold badge10 silver badges13 bronze badges

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

Comments

great_llama · Accepted Answer · 2009-05-22 20:45:16Z

8

Instead of an associative array, you should just be passing in an array of criteria expressions, ala:

$condition = array(
    'message_id = ' . $messageId,
    'profile_id = ' . $userId
);

(and make sure you escape those values appropriately if they're coming from user input)

answered May 22, 2009 at 20:45

great_llama

11.8k4 gold badges36 silver badges29 bronze badges

2 Comments

Kladskull Over a year ago

Will this come out as: "DELETE FROM messages WHERE message_id = 1 AND user_id = 2" or "DELETE FROM messages WHERE (message_id = 1) AND (user_id = 2) ?

great_llama Over a year ago

If I read the source correctly, it'll actually put the parentheses around each... /library/Zend/Db/Adapter/Abstract.php, _whereExpr (line 564 or so...)

WrightsCS · Accepted Answer · 2011-12-16 06:54:24Z

-3

Use this , it is working...

$data = array(
    'bannerimage'=>$bannerimage
);

$where = $table->getAdapter()->quoteInto('id = ?', 5);

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

edited Dec 16, 2011 at 6:54

WrightsCS

50.7k23 gold badges139 silver badges188 bronze badges

answered Dec 16, 2011 at 5:48

sandeep

7

1 Comment

SSH This Over a year ago

Especially when the answer shows an "update" instead of a "delete".

Collectives™ on Stack Overflow

Example of a Multi Condition Delete with Zend framework

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related