bind_param problem with binding boolean values

php mysqli boolean prepared-statement bindparam
ian picture ian · Jan 20, 2009 · Viewed 19k times · Source

I have a problem binding booleans using mysqli_stmt::bind_param in PHP5.

The SQL query is the following:

insert into `nvp_notes` (subject,messageid,receivedate,read) values (?,?,?,?)

Where 'read' is a tinyint, either 0 or 1, as I've had issues with bit using mysqli. So the types that I list in bind_param are:

$stmt->bind_param('sdsd', ...);

I've also tried 'sdsb' and 'sdss' but nothing seems to work, and I always get the message:

Warning: mysqli_stmt::bind_param(): Number of variables doesn't match number of parameters in prepared statement

When I remove the read field in the statement everything works fine. I've run out of ideas with this one. Surely bind_param works with booleans?

Answer

Paige Ruten picture Paige Ruten · Jan 20, 2009

You could convert the boolean to a 1 or 0 using intval() (or cast it with (int) or (integer)). According to mysqli_stmt::bind_param()'s documentation, the only types you may bind are ints, doubles, strings, and blobs.

Related questions

mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in

I'm have some trouble checking if a Facebook User_id already exists in my database (if it doesn't it should then accept the user as a new one and else just load the canvas application). I ran it on my …

Read More
How can I enable the MySQLi extension in PHP 7?

I have installed PHP 7 and MySQL 5.5.47 on Ubuntu 14.04 (Trusty Tahr). I have checked installed extension using: sudo apt-cache search php7-* It outputs: php7.0-common - Common files for packages built from the PHP source libapache2-mod-php7.0 - server-side, HTML-embedded …

Read More
How to install MySQLi on MacOS

I cannot find instructions about installing MySQLi on a Mac. Just to be clear, MySQL is up to date and I am running PHP 5. How do I install it? Where do I even get it from? Thanks for your help. …

Read More