How to delete rows using checkboxes in php and mysql-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

How to delete rows using checkboxes in php and mysql

P粉982009874 2023-09-01 22:02:23

478

I created a table with the database information and tried creating checkboxes to be able to delete rows more easily, but something isn't working.

I have a button with a form:

I have rows with checkboxes:

Also delete-register.php:

if (isset($_POST['delete'])) { if (isset($_POST['selected'])) { foreach ($_POST['selected'] as $id) { $query = "DELETE FROM registers WHERE id = $id"; mysqli_query($conn, $query); } header('Location: registers.php'); exit; } }

The problem is that "selected" is always empty, so nothing is deleted from the database. How can I solve this problem?

P粉982009874

reply all (1)

P粉0065406002023-09-02 18:45:55 1 floor

Please note that the data submitted will be within the scope of

....

Since you have two forms, when you click the submit button in the first form, it will not send the second form's data to the server.

So change the second form to:

[Additional explanation]

If you want to stick with the first form to trigger the deletion then please:

In the first form, change delete from "Submit" to "Button"
Add an onclick event to this delete button to trigger the submission of the second form
Make sure there is a hidden field called "delete" in the second form since you specified to include this field in the PHP script
you may have noticed that I have addedid=form2in the 2nd form so as to facilitate triggering of the submission by form1

This is the modified code: