Delete mysql Table row by clicking submit button php

Question

I have created a cart page from a table named booking .
The cart page has item name and asubmit button named "delete".
There has a lot of items in the cart sheet and every item has a "delete" submit type button.
The items are inside one form.

I need to delete one item from the table booking by clicking the "delete" button of the item.
How can I do it using PHP.

    <form action="delete.php" method="POST">
       <div>
           <h2>Item1</h2>
           <input type="submit" name="item1" value="delete">
       </div>
       <div>
           <h2>Item2</h2>
           <input type="submit" name="item2" value="delete">
       </div>
       <div>
           <h2>Item3</h2>
           <input type="submit" name="item3" value="delete">
       </div>
       ...
       <!--There has a lot of items like that-->
    </form>

Now for example I need to delete item100. How can I do it?

Edit: Here is the delete.php code-

<?php      
$query = mysql_query("delete from notification where item = 'item100'") or die(mysql_error());
?>

you should also show us your PHP code

cobarzan
– cobarzan

2015-12-12 13:37:43 +00:00
Commented Dec 12, 2015 at 13:37 — cobarzan
– cobarzan, Commented Dec 12, 2015 at 13:37

Guillaume Lapierre · Accepted Answer · 2015-12-12 13:21:05Z

3

You do not need form and submit input. You could use links:

<a href="delete.php?id=100">delete</a>

This is a GET so you need to perform a redirect to your incoming page to avoid back button problems or use Ajax or both.

If you want to use your form and submit button you could add some Javascript to set an hidden input or use a <button />

answered Dec 12, 2015 at 13:21

Guillaume Lapierre

463 bronze badges

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

1 Comment

Nicolas Over a year ago

NEVER delete data with just a link. Sure, it will work, but you might also have a web crawler delete every record in your database!

BigJohn863 · Accepted Answer · 2015-12-12 18:21:36Z

0

Although there is sql injection risks you will need to deal with, this is how you would do it using your current method. Keep in mind you will still need to modify your code to prevent sql injections.

    <?php $query = mysql_query("delete from notification where item = '".$_POST['name']."'") or die(mysql_error()); ?>

answered Dec 12, 2015 at 18:21

BigJohn863

478 bronze badges

Collectives™ on Stack Overflow

Delete mysql Table row by clicking submit button php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related