PHP & MySQLi Fatal error: Call to a member function bind_param() on a non-object

Question

I'm facing this problem and I've searching for hours now.. I can't see any problem in this piece of code... What's wrong here?

db.php:

<?php
$mysqli = mysqli_connect('localhost', 'root', '', 'site');
if(mysqli_connect_errno()) 
    {
          echo "Erro BD";
          exit();
    }
?>

update.php:

include 'db.php';

$zzz = '';
$email = 'asdsaf@gmail.com';

$ins = $mysqli->prepare("update USER set cod_valida =? where email =?");
$ins->bind_param('ss', $zzz, $email);

   if ($result = $ins->execute()){

      $ins->free_result();
      echo "It works";
   }
   else
   {
     echo "Error";
   }
$ins->close();
$mysqli->close();

Is there anyway to echo the query I'm trying to send or the mysql error?

Thank you for your help instead of downvote my thread since I already checked everything and found no answer.

check your initialization of $mysqli. add your code of initialization of $mysqli. — Awlad Liton, Jan 15 '14 at 12:25
the $mysqli initializes in a separated file wich starts the mysql connection and it runs fine with other querys including this one — B1GB0Y, Jan 15 '14 at 12:32
I think the error here must be in query... If only I could "echo" the query I'm trying to send or the mysql error... — B1GB0Y, Jan 15 '14 at 12:40
@B1GB0Y : i tried locally it give me table does not exist error — Awlad Liton, Jan 15 '14 at 12:53
If I run "echo $mysqli->error;" right after the prepared statement it says: "Commands out of sync; you can't run this command now" — B1GB0Y, Jan 15 '14 at 12:57

score 0 · Answer 1 · edited May 23 '17 at 12:29

0

It seems that you have wrong in your query table name. table name is case sensetive and check your column name with database table.

ref: mysql case sensitive table names in queries

change

$ins = $mysqli->prepare("update USER set cod_valida =? where email =?");

to

$ins = $mysqli->prepare("update user set cod_valida =? where email =?");

edited May 23 '17 at 12:29

Community

1
1

answered Jan 15 '14 at 12:50

Awlad Liton

9,366
2
27
53

Still not working.. Is there anyway to echo the query I'm trying to send? Thank you. – B1GB0Y Jan 15 '14 at 12:58
@B1GB0Y: after binding : $ins->error ? give me the error – Awlad Liton Jan 15 '14 at 13:03

PHP & MySQLi Fatal error: Call to a member function bind_param() on a non-object

1 Answers1