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

this question has answer here:

• how mysqli error in different environments? 1 answer

i trying bind variable in prepared statement, keep receiving error:

call member function bind_param() on non-object 

the function called, , variables passed it. when change function echo variable, variable prints on page fine, if try bind here receive error. can help?

//call page 1 check($username);  //function on page 2 function check($username){ $dbh = getdbh(); $qselect = $dbh->prepare("select * users username = ?"); $qselect->bind_param("s", $username); } 

i know function not written here, shouldn't problem. don't understand why receiving error.

as error-message says, $qselect seems not object. try debug using var_dump($qselect); right after prepare-call. check if getdbh() returns need.

sounds prepare-call fails (don't know why) , returns false - false not object, can't call bind_param() on that.

edit: havn't given info, looks you're using php's pdo. in case, take @ the documentation.

if database server prepares statement, pdo::prepare() returns pdostatement object. if database server cannot prepare statement, pdo::prepare() returns false or emits pdoexception (depending on error handling).

you should configure server return pdo-exceptions, tell why prepare call fails.