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

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 = '[email protected]';

$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
– Awlad Liton, Commented Jan 15, 2014 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
– B1GB0Y, Commented Jan 15, 2014 at 12:32

Community · Accepted Answer · 2017-05-23 12:29:16Z

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, 2017 at 12:29

CommunityBot

11 silver badge

answered Jan 15, 2014 at 12:50

Awlad Liton

9,3513 gold badges30 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

B1GB0Y Over a year ago

Still not working.. Is there anyway to echo the query I'm trying to send? Thank you.

Awlad Liton Over a year ago

@B1GB0Y: after binding : $ins->error ? give me the error

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related