PHP PDO::bindParam() data types.. how does it work?

by

In other DB abstraction frameworks in other languages it can be used for things like making sure you’re doing the proper escaping for in-lining values (for drivers that don’t support proper bound parameters) and improving network efficiency by making sure numbers are binary packed appropriately (given protocol support). It looks like in PDO, it doesn’t do much.

   if (PDO_PARAM_TYPE(param->param_type) == PDO_PARAM_STR && param->max_value_len <= 0 && ! ZVAL_IS_NULL(param->parameter)) {
                if (Z_TYPE_P(param->parameter) == IS_DOUBLE) {
                        char *p;
                        int len = spprintf(&p, 0, "%F", Z_DVAL_P(param->parameter));
                        ZVAL_STRINGL(param->parameter, p, len, 0);
                } else {
                        convert_to_string(param->parameter);
                }
        } else if (PDO_PARAM_TYPE(param->param_type) == PDO_PARAM_INT && Z_TYPE_P(param->parameter) == IS_BOOL) {
                convert_to_long(param->parameter);
        } else if (PDO_PARAM_TYPE(param->param_type) == PDO_PARAM_BOOL && Z_TYPE_P(param->parameter) == IS_LONG) {
                convert_to_boolean(param->parameter);
        }

So, if you say it is a STR (or if you say nothing at all as that is the default) and your data’s internal type is a double then it will turn it into a string using one method, if it’s not a double then it will convert it to a string using a different method.

If you say it’s an int but it is really a bool then it will convert it to a long.

If you say it’s a bool but it’s really a number then it will convert it to a true boolean.

This is really all I saw (quickly) looking at the stmt source, I imagine once you pass the parameters into the driver they can do additional magic. So, I’d guess that all you get is a little bit of do the right and a whole lot of behavior ambiguity and variance between drivers.

More Related Contents:

  1. Can I bind an array to an IN() condition in a PDO query?
  2. PHP – Using PDO with IN clause array
  3. PDO Prepared Inserts multiple rows in single query
  4. PDO prepared statement – what are colons in parameter names used for?
  5. pdo prepared statements with wildcards
  6. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  7. Get last insert id after a prepared insert with PDO
  8. How do I use pdo’s prepared statement for order by and limit clauses?
  9. Insert multiple rows with PDO prepared statements
  10. Replacing mysql_* functions with PDO and prepared statements
  11. Binding params for PDO statement inside a loop
  12. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  13. Calling stored procedure with Out parameter using PDO
  14. When *not* to use prepared statements?
  15. Which tokens can be parameterized in PDO prepared statements?
  16. Retrieve (or simulate) full query from PDO prepared statement
  17. PDO error: SQLSTATE[HY000]: General error: 2031
  18. Use of PDO in classes [duplicate]
  19. Error while using PDO prepared statements and LIMIT in query [duplicate]
  20. How to apply bindValue method in LIMIT clause?
  21. Call to a member function bind_param() on a non-object [duplicate]
  22. PHP UPDATE prepared statement
  23. PDO multiple queries
  24. What is the advantage of using try {} catch {} versus if {} else {}
  25. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  26. Call to undefined method PDO::execute()
  27. return one value from database with mysql php pdo
  28. How to get a query error from prepare() in PDO PHP?
  29. How can I pass an array of PDO parameters yet still specify their types?
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment