prepared statement causes non-object error

Question

Using this insert-script:

$stmt = $mysqli->prepare("INSERT INTO table VALUES (?)");
$stmt->bind_param('s', $value); // echoing $value: 120.120
$stmt->execute();
$stmt->close();
$mysqli->close();

I get this error:

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

i already tried "s", "d" and "i" but none works, anybody could help me? greetings!

This question appears to be off-topic because it is about topic has been answered before a lot. — PeeHaa, Dec 01 '13 at 20:37

score 0 · Answer 1 · answered Dec 01 '13 at 20:37

The problem generally occurs because

$mysqli->prepare("INSERT INTO table VALUES (?)");

Does not return an object which means that prepare() failed to apply your definitions.

I used to see the bind_param non-object error when the actual SQL table did not actually have the field i wanted to write to. Please compare your query to your actual SQL table and see if all the fields you try to use are actually part of the table. Also make sure the table name is correct.

prepared statement causes non-object error

1 Answers1