PHP MYSQL DELETE and bind_param()

Asked Nov 12 '17 at 15:53

Active Nov 12 '17 at 19:16

Viewed 38 times

I can get this to delete. Getting error: "PHP Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in"

If i change DELETE FROM to SELECT* FROM, it works. Is it any special with DELETE?

$stmt = $conn->prepare("DELETE FROM password_request WHERE email = ?");
$stmt->bind_param("s", $email);
if($stmt->execute()) { 
  echo 'Deleted';
} else {
  echo 'Not deleted';
}

I tried the stuff from: Fatal error: Call to a member function bind_param() on boolean Not same issue i think.

edited Nov 12 '17 at 19:16

asked Nov 12 '17 at 15:53

Alex

1

it suggests to me that the prepared statement failed – Professor Abronsius Nov 12 '17 at 15:56
be sure you are really connect to the db – ScaisEdge Nov 12 '17 at 15:56
If i just change the text DELETE FROM to SELECT * FROM, it works. So it is not the connection. – Alex Nov 12 '17 at 15:58
That seems like it should work, let it tell you what it thinks is wrong, http://php.net/manual/en/mysqli.error.php. – chris85 Nov 12 '17 at 16:00
I added the error reporting. It does not change anything. Page is blank and same error message is posted in php error_log. – Alex Nov 12 '17 at 19:16
I found the error.. User rights.. Thanks for you time guys! – Alex Nov 12 '17 at 19:23

PHP MYSQL DELETE and bind_param()

0 Answers0