How to Do multiple Deletion using php jquery

Question

here I have a table which its data come from database (Mysql DBMS)

In this table I can delete a book one by one but what I need is to delete multiple Book in once Something like this

But Actually I have no Idea How to do That Can you guys do me a favor how to do that plz I will be thankful

What is your question exactly? Just give each row a checkbox and link them to the delete button. — Halcyon
– Halcyon, Commented Mar 3, 2016 at 18:04
My question is that part actually How to link that to a delete button — A. MO
– A. MO, Commented Mar 3, 2016 at 18:05
Ok Thanks Im trying to do I think I got it, I think Its somehow like multiple upload file — A. MO
– A. MO, Commented Mar 3, 2016 at 18:15

u_mulder · Accepted Answer · 2016-03-03 18:14:45Z

1

Create a list of checkboxes with the same name using [] notation, but different values, ids of records presumably:

<input type="checkbox" name="record_id[]" value="42" />
<input type="checkbox" name="record_id[]" value="43" />
<input type="checkbox" name="record_id[]" value="44" />
<input type="checkbox" name="record_id[]" value="45" />

After you select some of them, they will be passed to a server as $_POST['record_id'] array.

Do a foreach:

foreach ($_POST['record_id'] as $id) {
     // delete record with $id here
}

Or implode'em, for example:

$sql = "DELETE FROM `mytable` WHERE id IN (" . implode(', ', $_POST['record_id']) . ")";

answered Mar 3, 2016 at 18:14

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

How to Do multiple Deletion using php jquery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related