How to get numeric types from MySQL using PDO?

by

To answer your last question first, “yes,” unfortunately it’s normal to receive numbers as strings. As the manual quoted by Pascal says, mysqlnd (PHP 5.3) will return native data types from prepared statements, provided you turn off the prepared statement emulation from PDO.

new PDO($dsn, $user, $pass, array(
    PDO::ATTR_EMULATE_PREPARES => false
))

PDO::ATTR_STRINGIFY_FETCHES is unrelated to MySQL.

If you look at the bright side, it’s good practice to use prepared statements anyway, so… 😉

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. Getting raw SQL query string from PDO prepared statements
  4. How do I use password hashing with PDO to make my code more secure? [closed]
  5. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  6. Insert/update helper function using PDO
  7. PDO with INSERT INTO through prepared statements [closed]
  8. PDO::fetchAll vs. PDO::fetch in a loop
  9. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  10. Real escape string and PDO [duplicate]
  11. PDO multiple queries
  12. PHP PDO vs normal mysql_connect
  13. Can I create a database using PDO in PHP?
  14. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  15. PHP PDO and MySQLi [duplicate]
  16. PDO fetch one column from table into 1-dimensional array
  17. Update query with PDO and MySQL
  18. Is “SET CHARACTER SET utf8” necessary?
  19. Getting a PHP PDO connection from a mysql_connect()?
  20. Having issue with matching rows in the database
  21. Set PDO to throw exceptions by default [duplicate]
  22. PDO: MySQL server has gone away
  23. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  24. PHP/SQL Insert Error when using Named Placeholders
  25. How to escape single-quote (apostrophe) in string using php
  26. PHP Laravel: No connection could be made because the target machine actively refused it
  27. PDO bindParam into one statement?
  28. Insert value list does not match column list: 1136 Column count doesn’t match value count
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment