PhP delete row from database onsubmit

Question

I am trying to delete a row of data from the data base, after a submit input is clicked.

if (isset($_POST['submit'])) {
   // sql to delete a record
$query = "DELETE * FROM wishList
     WHERE userID_FK = {$_SESSION['user_id']}
     AND itemName = {$row['itemName']}";

$result = mysqli_query($dbc, $query);

if($result)
{
    echo 'Data Deleted';
}else{
    echo 'Data Not Deleted';
}

}

Check the answer below. Might be helpful. – Kamran Jabbar Jul 28 '17 at 22:44 — Kamran Jabbar, Jul 28 '17 at 22:44

score 0 · Answer 1 · answered Jul 28 '17 at 22:41

0

Please remove * from DELETE Query. If you get any other issue please let me know.

$query = "DELETE  FROM wishList
     WHERE userID_FK = {$_SESSION['user_id']}
     AND itemName = {$row['itemName']}";

answered Jul 28 '17 at 22:41

Kamran Jabbar

858
7
21

This did not work. Thank you for your reply. – M Cangiano Jul 28 '17 at 23:19

PhP delete row from database onsubmit

1 Answers1