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

Question

I hate to ask this question but I have searched and searched and done all sorts of things to see if I can resolve on my own.

var_dump = bool(false)

$stmt = $mysqli->prepare("INSERT INTO resetPswd (userID,key,date,status) VALUES (?,?,NOW(),0)");

$stmt->bind_param('is', $userID,$key);

$stmt->execute();

I have removed everything then added all back the problem lies with "key", it works until I add that in.

I am creating a random 'key':

 $key = substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, $length);

db = key - varchar(12)

Any help would be great! Why am I using mysqli? It's required.

Try with backticles in tablename and column names – devpro Jan 18 '16 at 20:59 — devpro, Jan 18 '16 at 20:59

score 4 · Answer 1 · answered Jan 18 '16 at 20:58

4

KEY is a reserved word in MySQL.

You must escape it with backticks in order to use it as column name.

$stmt = $mysqli->prepare("INSERT INTO resetPswd (userID,`key`,date,status)  
                          VALUES (?,?,NOW(),0)");

answered Jan 18 '16 at 20:58

Alex Andrei

7,315
3
28
42

Thank You! I knew I was doing something stupid! – harkly Jan 18 '16 at 21:03
You're welcome @harkly – Alex Andrei Jan 18 '16 at 21:06
`status` and `date` are also in the list of reserved keywords, although MySQL doesn't seem to be strict/consistent when it comes to the `status` keyword – Elias Van Ootegem Jan 18 '16 at 21:06
1

those are just keywords, the reserved ones have an (R) next to them – Alex Andrei Jan 18 '16 at 21:07
@AlexAndrei exactly ^ ;-) – Funk Forty Niner Jan 18 '16 at 21:31
1

@Fred-ii- you only have to tell me once :) – Alex Andrei Jan 18 '16 at 21:37

score 0 · Answer 2 · answered Jan 18 '16 at 20:55

That error means that the call to $mysqli->prepare returned something that isn't an object, my guess would be it returns something like "false" which is not an object and thus you can't call "bind_param" on false. Doesn't sound like $key has anything to do with it.

score 0 · Answer 3 · edited Jan 18 '16 at 21:03

0

From the PHP documentation:

If the database server successfully prepares the statement, PDO::prepare() returns a PDOStatement object. If the database server cannot successfully prepare the statement, PDO::prepare() returns FALSE or emits PDOException (depending on error handling).

http://php.net/manual/en/pdo.prepare.php#refsect1-pdo.prepare-returnvalues

You have an error in your query. key is a reserved word and will make that statement return false

edited Jan 18 '16 at 21:03

devpro

16,184
3
27
38

answered Jan 18 '16 at 20:59

vsmoraes

194
2
7

1

Probably best quote something similar from the `mysqli::prepare` documentation – Elias Van Ootegem Jan 18 '16 at 21:07

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

3 Answers3