How to delete multiple rows from MYSQL database with PHP no frameworks

Question

I'm trying to handle a query to delete multiple items with checkboxes. I'm using react for my frontend and php for my backend.

My frontend sends the payload form data like this : P.S My Primary Key is the SKU.

sku: DVD0004
sku: DVD0005

I need to combine these values into 1 bracket like this (DVD0004,DVD0005) in order to put them in my query which is

My API

    public function deleteProduct($prdt_sku)
    {
        try {
            $this->db->query("DELETE FROM products WHERE product_sku = :sku");
            $this->db->bind(":sku", $prdt_sku);

            if ($this->db->execute()) {
                return true;
            } else {
                return false;
            }
        } catch (\Throwable) {
            header("HTTP/1.1 406 Error deleting product from database");
        }
    }

*My actual form destination *

$response = array();

if (isset($_POST['sku'])) {

    $sku = $_POST['sku'];

    $result = $api->deleteProduct($sku);

    if ($result) {
        header("HTTP/1.1 200 OK");
        header("Location: http://localhost:3000/");
        exit();
    } else {
        header("HTTP/1.1 406 Error deleting product");
    }
} else {
    header("HTTP/1.1 499 Required parameters missing");
}

You can do $sku = $_POST['sku']; foreach($sku as $Deletables){$result = $api->deleteProduct($Deletables);} it will loop and delete one sku at a time — stillKonfuzed
– stillKonfuzed, Commented Feb 9, 2022 at 1:01
It worked, just needed to turn all the SKUs into an array on the front end checkboxes using name="sku[]" Post this as an answer & I will upvote it — Metwesh
– Metwesh, Commented Feb 9, 2022 at 1:45

BrianT · Accepted Answer · 2022-02-09 04:20:43Z

3

To avoid running multiple delete queries, you can use WHERE IN (a, b, c) instead of deleting one record at a time. See this question for details.

answered Feb 9, 2022 at 4:20

BrianT

3392 silver badges10 bronze badges

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

Comments

Peter Csala · Accepted Answer · 2022-02-09 05:48:55Z

1

On the frontend I turned the multiple SKUs into an array using name="sku[]" & on the backend with the help of https://stackoverflow.com/users/9437124/stillkonfuzed by putting the database query into a foreach loop using

$sku = $_POST['sku']; 
foreach($sku as $Deletables){
  $result = $api->deleteProduct($Deletables);
}

It was fixed.

edited Feb 9, 2022 at 5:48

Peter Csala

23.7k16 gold badges51 silver badges96 bronze badges

answered Feb 9, 2022 at 2:04

Metwesh

852 silver badges8 bronze badges

1 Comment

stillKonfuzed Over a year ago

Good job there.

Collectives™ on Stack Overflow

How to delete multiple rows from MYSQL database with PHP no frameworks

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related