Monday, 28 August 2017

php - Call to a member function bind_param() on a non-object MySQLi



Okay, so I'm trying to update a blog entry, and I'm getting Call to a member function bind_param() on a non-object when I try to run the script. I have done extensive research to see if I could fix it myself, but I must be missing something.



$stmt = $mysqli->prepare("UPDATE blogentries SET 
headline = ?,

image = ?,
caption = ?,
article = ?
WHERE id = ?");
$stmt->bind_param('ssssi',
$_POST['headline'],
$_POST['image'],
$_POST['caption'],
$_POST['article'],
$_POST['id']);

$stmt->execute();
$stmt->close();

?>


Thanks in advance,



Austen




Update: Here's the db connect



I added the extra $mysqli connection for debugging purposes, and the error occurs even without it.


Answer



$stmt is probably false.



if ($stmt = $mysqli->prepare(...)) {
$stmt->bind_param(...);
...
}

else {
printf("Errormessage: %s\n", $mysqli->error);
}

No comments:

Post a Comment

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...