PHP MySql fatal error : bind_param() function on UPDATE query

Asked May 15 '17 at 12:13

Active May 15 '17 at 12:13

Viewed 16 times

I know these type of questions are asked here, I am trying to search about this problem from lot of time.

It is showing error message Fatal error: Call to a member function bind_param() on boolean in ... on line .... I am working on localhost

It is working fine with every other query.

I have tried echo-ing all the variables I used here it showing correct values

$stmt = $this->conn->prepare("UPDATE profile SET (lastlogin_date = '".$last_login_date."', lastlogin_ip = '".$ip_address."', login_last_try = '".$last_login_date."') WHERE profile_id = ?");
        $stmt->bind_param('s', $profile_id);
        $result = $stmt->execute();

What is the problem here?

asked May 15 '17 at 12:13

parish

Inspect `$stmt` because it's not an object – Scuzzy May 15 '17 at 12:15
If you are going to prepare a query, prepare *all* of the variable items. – Jay Blanchard May 15 '17 at 12:16
@JayBlanchard I tried it but it gives same error – parish May 15 '17 at 12:25
@Scuzzy $stmt working fine with other statements – parish May 15 '17 at 12:25
Well not in this instance because it's a boolean which means it's probably contains `false` meaning `$this->conn->prepare()` has failed. – Scuzzy May 16 '17 at 04:37

PHP MySql fatal error : bind_param() function on UPDATE query

0 Answers0