Delete multiple records from database

Question

I have a dashboard of product.On dashboard it display all product details.There is check box to delete multiple product at a time. For that I am using this code:

    $id=array('0'=> 'ab','1'=> 'bc','2'=> 'cd','3'=> 'de',.......);
    $packids=implode("','", $id);
    $packids= ('ab','bc','cd','ef',.....);// n numbers of record
    $sql = "DELETE from app_and_page where `Package` IN ($packids) and `user_created`=$uid";
    $retval = mysql_query( $sql, $link );

This query is deleting only one row.How can I delete all the selected rows at a time.

All $packids are for $uid Yes. User add multiple product and can delete. — Urvashi, Jun 19 '17 at 06:54
@hungrykoala $uid comes correct.It is deleting only one row not all what I given in query — Urvashi, Jun 19 '17 at 06:55
Possible duplicate of [Delete many rows from a table using id in Mysql](https://stackoverflow.com/questions/15504020/delete-many-rows-from-a-table-using-id-in-mysql) — Hamza Zafeer, Jun 19 '17 at 06:55
Is `$packids` an array? If yes, you need to `implode(',', $packids)`. — Milan Chheda, Jun 19 '17 at 06:56
@HamzaZafeer yes.But i am not getting desired out put.It is deleting one row only instead of all what I given. — Urvashi, Jun 19 '17 at 06:56
I assume `$packids = array('ab', 'bd', .....);` or change it to `$packids = ['ab', 'bc',....];` — Ritobroto Mukherjee, Jun 19 '17 at 06:57
@MilanChheda yes after implode I am passing this like $packids= ('ab','bc','cd','ef',.....). — Urvashi, Jun 19 '17 at 06:57
If yes, then it should be `$packids="'" . implode("','", $id) . "'";` — Milan Chheda, Jun 19 '17 at 07:05
@MilanChheda Echo query comes like DELETE from app_and_page where `Package` IN ('ab','bc','cd','de') and `user_created`=2 but delete only one row — Urvashi, Jun 19 '17 at 07:15
@all Now working Problem is while implode extra space is coming.After removing it is working fine.Thanks again — Urvashi, Jun 19 '17 at 07:22

Bibhudatta Sahoo · Accepted Answer · 2017-06-19T07:28:50.253

1

I thing the issue in pack ids just try this In place of

$id=array('0'=> 'ab','1'=> 'bc','2'=> 'cd','3'=> 'de',.......);
$packids=implode("','", $id);
$packids= ('ab','bc','cd','ef',.....);// n numbers of record
$sql = "DELETE from app_and_page where `Package` IN ($packids) and `user_created`=$uid";
$retval = mysql_query( $sql, $link );

Use this

$id=array('0'=> 'ab','1'=> 'bc','2'=> 'cd','3'=> 'de',.......);
$packids=implode("','", $id);
$packids="('".$packids."')";
$sql = "DELETE from app_and_page where `Package` IN $packids and `user_created`=$uid";
$retval = mysql_query( $sql, $link );

It will work for you.

EDIT

Try like this

$sql = "DELETE from app_and_page where trim(`Package`) IN $packids and `user_created`=$uid";

edited Jun 19 '17 at 07:28

answered Jun 19 '17 at 06:59

Bibhudatta Sahoo

4,808
2
27
51

Echo query comes like DELETE from app_and_page where Package IN ('ab','bc','cd','de') and user_created=2 but delete only one row – Urvashi Jun 19 '17 at 07:19
1

Just make sure that in Package there is no space in value like 'ab ' or ' cd' if so then use trim(`Package `) – Bibhudatta Sahoo Jun 19 '17 at 07:27
Right .That was the problem.Thanks.Working fine now. – Urvashi Jun 19 '17 at 07:29

score 0 · Answer 2 · edited Jun 19 '17 at 07:07

0

$packids= ('ab','bc','cd','ef',.....);// n numbers of record $sql = "DELETE from app_and_page where Package IN (substr($packids, 0, strlen($packids)-1)) and user_created=$uid"; $retval = mysql_query( $sql, $link );

Try this one. I think you have to remove last comma from our packids string.

edited Jun 19 '17 at 07:07

Bibhudatta Sahoo

4,808
2
27
51

answered Jun 19 '17 at 06:59

Shimul

87
1
3
12

Echo query comes like DELETE from app_and_page where Package IN ('ab','bc','cd','de') and user_created=2 but delete only one row – Urvashi Jun 19 '17 at 07:18

Delete multiple records from database

2 Answers2