Mysql delete multiple row in array [duplicate]

Question

$favour_delete=$_GET['favour_delete'];
$favour_delete=implode(",",$favour_delete);

$delete=$db->prepare("DELETE FROM favour WHERE post_id IN (:favour_delete) && user_id=:user_id");
$delete->bindValue(':favour_delete', $favour_delete, PDO::PARAM_STR);
$delete->bindValue(':user_id', $user_id, PDO::PARAM_STR);

I have a mysql delete multiple row in array. user tick checkbox and send it in array.

I implode it into string and use IN (), I don't know where is went wrong, it only delete one row.

post_id  user_id
2        1
3        1
4        2

So if user: 1 send $favour_delete=array(2,3); it should delete first and second row

depend what user tick, its array, if user tick 3, it should delete 3 row — user2178521
– user2178521, Commented Jul 15, 2013 at 15:22
Post a data example that can be sent in your favour_delete. — DontVoteMeDown
– DontVoteMeDown, Commented Jul 15, 2013 at 15:24
Did you try to print $favour_delete after the implode to make sure it contains 3 values? — Mash
– Mash, Commented Jul 15, 2013 at 15:24
You can't bind to the IN clause like that, you need to generate the placeholders. See duplicate. — MrCode
– MrCode, Commented Jul 15, 2013 at 15:24

Orangepill · Accepted Answer · 2013-07-15 16:35:03Z

0

Unfortunately as of now there is now way to parameterize the in clause in a query your best bet here is as follows.

<?php
$favour_delete=$_GET['favour_delete'];
$favour_delete=array_map('intval',$favour_delete);

$delete=$db->prepare("DELETE FROM favour WHERE post_id IN (".implode(",",$favor_delete).") && user_id=:user_id");
$delete->bindValue(':user_id', $user_id, PDO::PARAM_STR);

edited Jul 15, 2013 at 16:35

answered Jul 15, 2013 at 15:25

Orangepill

24.7k3 gold badges44 silver badges64 bronze badges

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

1 Comment

Sean Bone Over a year ago

Why are you using explode on line 2? $_GET['favour_delete']is already an array.

Collectives™ on Stack Overflow

Mysql delete multiple row in array [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related