PHP Prepared statement bind_param() error

Question

Many people on stackoverflow has had this problem, but i still cannot spot the mistake

This is the error:

Fatal error: Call to a member function bind_param() on boolean -

This is the lines of code:

$insertpost = $conn->prepare("INSERT INTO posts (title,post,user,img,date,short) VALUES(?,?,?,?,NOW(),?)");
$insertpost->bind_param("sssss",$title,$comment,$user,$url,$short);

$insertpost might be bool false, probably because the prepare() fails. — frz3993
– frz3993, Commented Apr 24, 2016 at 17:03
Possible duplicate of mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row() expects parameter 1 to be resource or mysqli_result, boolean given — alexander.polomodov
– alexander.polomodov, Commented Apr 24, 2016 at 17:04
You are defining all strings as parameter types, "sssss", looking at your parameters, you seem to have types other than the ones you are defining. I can at least see possible: date/datetime and integer types. It's just a suggestion, they may be implicit conversions, but I usually prefer to type things correctly regardless of if they have implicit conversions, just to be safe. — gmiley
– gmiley, Commented Apr 24, 2016 at 17:05
Basically the query FAILED therefore the variable $insertpost contains false If you test for this situation ALWAYS you wont get this problem. Aso use $conn->error to see a description of the error if $insertpost === false — RiggsFolly
– RiggsFolly, Commented Apr 24, 2016 at 17:09
$insertpost = "INSERT INTO posts (title,post,user,img,date,short) VALUES('".$title."','".$comment."','".$user."','".$url."','".$date."','".$short."')"; I know it works because this worked previously... — hayhay
– hayhay, Commented Apr 24, 2016 at 17:10

Community · Accepted Answer · 2017-03-20 10:29:34Z

2

UPDATE: My original answer was starkly incorrect for this question. date is not a reserved word and can be used without quoting (thanks for the schooling, guys). However, because unquoted reserved words can be a common issue which could result in the same error, I'm leaving this up for future readers in case it helps (https://meta.stackexchange.com/questions/37738/when-or-should-you-delete-your-incorrect-answer). Basically:

Check your column names. You may have unquoted reserved words.

https://dev.mysql.com/doc/refman/5.5/en/keywords.html

ORIGINAL ANSWER:

You need to quote your column names with backticks. Your date field is a reserved word.

$insertpost = $conn->prepare("INSERT INTO posts (`title`,`post`,`user`,`img`,`date`,`short`) VALUES(?,?,?,?,NOW(),?)");

https://dev.mysql.com/doc/refman/5.5/en/keywords.html

edited Mar 20, 2017 at 10:29

CommunityBot

11 silver badge

answered Apr 24, 2016 at 17:05

Bitwise Creative

4,0805 gold badges31 silver badges35 bronze badges

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

9 Comments

hayhay Over a year ago

Me using date has nothing to do with it, and encapsulating also does nothing in this case.

RiggsFolly Over a year ago

While date is a bad name to give a column MYSQL made a special case of it so it does not actually throw an error any more and does not caiuse queries to fail. But you should not use it as a column name

hayhay Over a year ago

I've used this in other places in my code, it works this way - $posts = $conn->prepare("SELECT id,title,post,short,user,img,date FROM posts ORDER BY posts.date DESC LIMIT ?"); $posts->bind_param("s",$limit);

Bitwise Creative Over a year ago

Well, it does though. prepare fails because the query is invalid when you don't encapsulate a reserved word field name...

Funk Forty Niner Over a year ago

date is not a reserved word, it's a keyword; two different animals here. Have look for yourself dev.mysql.com/doc/refman/5.5/en/keywords.html there's no (R) next to it. Let's lose that misconception about that ;-) You even included that link in your answer.

|

RiggsFolly · Accepted Answer · 2016-04-24 17:23:44Z

0

After every mysqli or PDO function that COULD return a bad/failed status you must test for that possibility.

The error Fatal error: Call to a member function bind_param() on boolean says it all. $insertpost is false so the prepare failed for SOME reason, it could be a bad query or it could be that the MYSQL Server has crashed and cannot prepare the statement.

So you must code accordingly

$insertpost = $conn->prepare("INSERT INTO posts 
                                    (title,post,user,img,date,short) 
                              VALUES(?,?,?,?,NOW(),?)");

if ( $insertpost === FALSE ) {
    // prepare failed for some reason, lets see why
    echo $conn->error;
    exit;
}
$insertpost->bind_param("sssss",$title,$comment,$user,$url,$short);

edited Apr 24, 2016 at 17:23

answered Apr 24, 2016 at 17:18

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

1 Comment

hayhay Over a year ago

Well, thanks. I added that and got the error - "Commands out of sync; you can't run this command now", so i realised i had to close my previous connections. Then i got the error - "Php mysqi bind_param Number of variables doesn't match number of parameters in prepared statement" So i had to get rid of the ' ' the previous guy told me to add.

Collectives™ on Stack Overflow

PHP Prepared statement bind_param() error

2 Answers 2

9 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related