fdsa fdsa - 5 months ago 10
PHP Question

How do I put booleans into a mysql database with prepared statements?

According to the PHP manual, the four variable types for

mysqli->bind_param
are


  1. integer,

  2. double,

  3. string and

  4. blob.



What is the best way to insert a boolean?

Answer

Mysql doesn't really store booleans anyway, it's a trick.

The actual format is TINYINT, which is I guess integer for pdo.

You will have to convert true/false to 1/0, with boolval for example.

Comments