如何将mysqli_stmt_bind_param用于整数，布尔值等

Question

I am trying to use this method to bind the parameters to their specific types:

mysqli_stmt_bind_param(mysqli_stmt stmt, string types, mixed &var1 [, mixed &...])

I understand that the second parameter is a string of types where

* s is for strings
* d is for decimals
* i is for integers
* b is for blob

I'm not sure what "blob" is.

Now my question is, how could I bind boolean-type variables into this method? Is there such a way to do that?

More information below. These are my variables: (roomType, roomPrice, roomQty, numBeds, smokingAvail, accessibleRm)

   roomType: string coming from web form
   roomPrice: decimal coming from a web form 
   roomQty: integer coming from web form
   numBeds: integer coming from web form
   smokingAvail: Boolean coming from web form
   accessibleRm: Boolean coming from web form

Answer 1

You can use string for all the types. Mysql will sort them out.