Delete multiple checkbox values in php

Question

I am new to php. I have inserted some multiple checkboxes' values into my database table using implode. Here is the code.

`$checkBox = implode(",", $_POST['car']);

if(isset($_POST['addcar']))
{       
   $username = $_SESSION['username'];
    $query1="INSERT INTO vehicle (username,car) VALUES ('$username', '" . $checkBox . "')   ";     

mysqli_query($db,$query1);



}`

But i can't find how to delete records. Could someone please help me. Thank you for the answers in advance.

See about sql injection and the importance of prepared and bound queries, and consider whether a hard delete is really something you want your users to be able to do — Strawberry
– Strawberry, Commented Dec 26, 2020 at 23:36
Side note: Do not use string interpolation or concatenation to get values into SQL queries. That's error prone and might make your program vulnerable to SQL injection attacks. Use parameterized queries. See "How to include a PHP variable inside a MySQL statement" and "How can I prevent SQL injection in PHP?". — sticky bit
– sticky bit, Commented Dec 26, 2020 at 23:38

anazititís gnósis · Accepted Answer · 2020-12-27 00:03:41Z

1

First of all, you've to be aware of SQL-injection. Since you are new at PHP, hope that you'll learn that terms. Now I am just going trough your code. Try this:

$checkBox = implode(",", $_POST['car']);

$query1="DELETE FROM table WHERE car IN ($checkBox) ";

mysqli_query($db,$query1);

answered Dec 27, 2020 at 0:03

anazititís gnósis

639 bronze badges

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

Collectives™ on Stack Overflow

Delete multiple checkbox values in php

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related