DELETE row in php

Question

I'm trying to delete records from my database using a form. Can't get this to work. Any ideas?

include 'newsconnect.php';
$Id = $_POST['Id'];
if (empty($Id) === true {
    echo 'please input an Post ID.';
} else {
    if(!$_POST['Submit']) {
        header('Location: http://www.hidensecrets.yourwebsolution.net/forum.php');
    } else {
        mysql_query("DELETE * FROM forum WHERE id = '$Id'") or die(mysql_error());
        header('Location: http://www.hidensecrets.yourwebsolution.net/forum.php') ;
        echo "Deleted!";        
    }
}

I seem to land on this page which displays no errors.
Any help is really appreciated.

Need some storyboard about using `LIMIT 1` while intending to delete one record :D — Ejaz, Mar 29 '13 at 00:40
love that white screen error reporting.... if you change //include 'newsconnect.php'; and add die(1); do you see 1? — Nick Maroulis, Mar 29 '13 at 00:45
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request. — Matt Brady, Mar 29 '13 at 00:52

score 3 · Answer 1 · edited May 23 '17 at 12:33

3

Missing a closing bracket:

include 'newsconnect.php';
$Id = $_POST['Id'];
if (empty($Id)) {
           //-^    
    echo 'please input an Post ID.';
} else {
    if (!$_POST['Submit']) {
        header('Location: http://www.hidensecrets.yourwebsolution.net/forum.php');
    } else {
        mysql_query("DELETE FROM forum WHERE id = '$Id'") or die(mysql_error());
        header('Location: http://www.hidensecrets.yourwebsolution.net/forum.php');
        echo "Deleted!";
    }
}

Not sure which IDE you're using but most of them would show this error. You're also open to sql injection. Find out more.

edited May 23 '17 at 12:33

Community

1
1

answered Mar 29 '13 at 00:33

SeanWM

16,789
7
51
83

i have placed the missing bracket but still encounter same problem – Matt Brady Mar 29 '13 at 00:37
Check my edit. Try now. You had a `*` in the delete statement. – SeanWM Mar 29 '13 at 00:41
* removed, problem persists – Matt Brady Mar 29 '13 at 00:57
Did you check if it's hitting the else where the delete is happening? – SeanWM Mar 29 '13 at 13:55
how would i go about doing that?> – Matt Brady Mar 29 '13 at 14:05
Just echo anything before the `mysql_query` like `echo 'test';` – SeanWM Mar 29 '13 at 14:06

score 0 · Answer 2 · answered Mar 29 '13 at 00:36

0

What sort of issue are you facing? You're missing a closing parenthesis for if (empty($Id) === true in case the you're getting syntax error

answered Mar 29 '13 at 00:36

Ejaz

8,719
3
34
49

Try turning on error reporting. Add `error_reporting(E_ALL); ini_set('display_errors', 1);` before `include 'newsconnect.php';` and look for errors. – Ejaz Mar 29 '13 at 00:50
still displays blank screen. – Matt Brady Mar 29 '13 at 00:55

Last Breath · Answer 3 · 2013-03-29T01:13:42.527

0

I think that you must omit the asterisk in your delete query ! Try it and tell me the result :)

your code must use this query :

mysql_query("DELETE FROM forum WHERE id = '$Id'") or die(mysql_error());

instead of this one :

mysql_query("DELETE * FROM forum WHERE id = '$Id'") or die(mysql_error());

Hope this it will be the solution :)

edited Mar 29 '13 at 01:13

answered Mar 29 '13 at 00:40

Last Breath

530
2
12

@Matt Brady your code must use this query : mysql_query("DELETE FROM forum WHERE id = '$Id'") or die(mysql_error()); instead of this one : mysql_query("DELETE * FROM forum WHERE id = '$Id'") or die(mysql_error()); Hope this it will be the solution :) – Last Breath Mar 29 '13 at 00:43

DELETE row in php

3 Answers3