How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option

That’s why I’m wondering why is WordPress stuck to this pre-PHP-5.3
limitation.

Because WordPress has made the decision to support PHP 5.2 due to the large number of hosts that continue to use it. This is an ongoing debate and there’s no point rehashing it all here.

But this means that I have to know in advance each end every data type returned from the MYSQL query, which is by far an anti-pattern programming technique.

What? MySQL in PHP, by default, only returns strings. So there you go. That’s “each and every data type” that you need to know.

Regardless, you should know what your query is likely to return before outputting it to a page. And you should be verifying and escaping it before outputting it in the browser or an API response.

Most things like this have some sort of model that represents the data that sits between the front-end and the database. What is an anti-pattern is having your front-end so tightly coupled to the minutiae of how the data is stored.

Related Posts:

  1. How do you properly prepare a %LIKE% SQL statement?
  2. $wpdb and MySQL Create Trigger
  3. wpdb->prepare function remove single quote for %s in SQL statment
  4. Alternative to mysql_real_escape_string
  5. Increment value (value = value+1) of $wpdb->update
  6. wpdb Custom Meta Data with 2 conditions
  7. wpdb prepare syntax
  8. SQL query not working in alphabetical post title/content search
  9. MySQL LIKE not working
  10. Proper way to work with wpdb to get user’s firstname
  11. How to check for empty and not a failure
  12. Database: Custom table: sprintf value for DateTime column
  13. Converting mysql to $wpdb
  14. WP_USE_EXT_MYSQL
  15. wpdb insert and boolean fields
  16. Join new table with SQL query
  17. writing inner join in wpdb
  18. How to split the a table in database?
  19. MySQL Rank & $wpdb
  20. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  21. How do I join a $wpdb query with user meta using default value if not exist?
  22. How to translate this mySQL query to $wpdb query
  23. $wpdb select all meta for each post
  24. $wpdb to insert html form information
  25. Proper usage of $wpdb->update()?
  26. WordPress(wpdb class) and mysql stored procedures
  27. Can’t run database query
  28. Using WPDB->Insert()
  29. Active DB queries in WordPress?
  30. How to stop $wpdb from prepending database name
  31. WordPress $wpdb get posts from category and sort by custom meta
  32. How to get INSERT errors from $wpdb?
  33. Getting Error Trying to Create Table
  34. Understanding custom php that reads from WP MYSQL
  35. How to insert dash (-) into database using wpdb and new_to_publish hook?
  36. $wpdb->get_var multiple queries in one database check
  37. List users with the most posts in the last 30 days
  38. Insert two row in wordpress database
  39. WordPress $wpdb no result
  40. PHP variables in mysql query
  41. MySQL ‘duplicate entry’ error
  42. User set date and time from frontend doesn’t get stored into database
  43. Wpdb query with dynamic table name
  44. get posts whether meta_key exists or not
  45. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  46. How to search usermeta table
  47. How to add virtual column in wpdb get_result statement
  48. wpdb insert into point column in db
  49. WPDB delivers wrong results from complex queries
  50. $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
  51. CONCAT_WS in custom sql query
  52. Geographical proximity query using post_meta
  53. MySQL Select within WP Page template
  54. Saving custom term value to the database in new table
  55. why is $wpdb->update() causing a DB error from within wp_set_password()
  56. $wpdb->get_var returns 0
  57. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  58. MySQL error 2006: mysql server has gone away
  59. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  60. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  61. what does “/index.php?admin/admin_dashboard” in my url mean
  62. How to join two tables by multiple columns in SQL?
  63. How to get size of mysql database?
  64. mysqladmin: connect to server at ‘localhost’ failed
  65. mysql update multiple columns with same now()
  66. Usage of MySQL’s “IF EXISTS”
  67. Generating a random & unique 8 character string using MySQL
  68. MySQL > Table doesn’t exist. But it does (or it should)
  69. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  70. Can’t create test file lower test start server mysql
  71. MySQL delete multiple rows in one query conditions unique to each row
  72. CAST to DECIMAL in MySQL
  73. SQL query to update post_date (one post = one single date & time)
  74. How to copy post titles to post slug in phpmyadmin
  75. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  76. What is the most secure way to set up the MySQL user in WPMU?
  77. Distinction on meta value on pre_get_posts
  78. WSoD being caused by this piece of code
  79. Creating mySQL procedure with $wpdb
  80. WordPress post_status is future, manually added
  81. Return terms from multiple taxonomies using $wpdb
  82. How are multiple WordPress WPDB queries handled?
  83. Regarding “Insert query error” in wordpress
  84. $wpdb->insert() does not Insert record in a table
  85. WordPress plugin overloading with tmp tables
  86. WordPress plugins for database queries
  87. Mixing variables into an array when inserting values
  88. Output: “Array”
  89. Array Formation Issue
  90. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  91. How to get product order by two custom taxonomy in wordpress
  92. form $_post action value gets truncated after it passes through two forms
  93. Updating with $qpdb->query() always returns 0 rows affected
  94. Add row to custom database Table and delete all rows older than 1 day
  95. $wpdb is queried but results don’t show
  96. edit_user_created_user hook – using to update Groups
  97. Improving performance of SQL sub-queries in WordPress
  98. MYSQL Join on meta key value?
  99. mysqldump to a tar.gz
  100. Where is my mysql log on OS X?