MySQL integer field is returned as string in PHP

by

When you select data from a MySQL database using PHP the datatype will always be converted to a string. You can convert it back to an integer using the following code:

$id = (int) $row['userid'];

Or by using the function intval():

$id = intval($row['userid']);

More Related Contents:

  1. Which MySQL datatype to use for an IP address? [duplicate]
  2. Php mysql tabs don’t output [closed]
  3. Update Mysql except when field not null
  4. How can I prevent SQL injection in PHP?
  5. UTF-8 all the way through
  6. SQL injection that gets around mysql_real_escape_string()
  7. Can I mix MySQL APIs in PHP?
  8. jQuery Validate remote method usage to check if username already exists
  9. MySQL query to get column names?
  10. How do you connect to multiple MySQL databases on a single webpage?
  11. PDO get the last ID inserted
  12. LIMIT keyword on MySQL with prepared statement [duplicate]
  13. Pagination using MySQL LIMIT, OFFSET
  14. How to call a MySQL stored procedure from within PHP code?
  15. Best way to check if mysql_query returned any results?
  16. mysql_fetch_array return only one row
  17. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  18. Insert multiple rows with PDO prepared statements
  19. a better approach than storing mysql password in plain text in config file?
  20. mysql query result in php variable
  21. mysql_real_escape_string is undefined
  22. Unknown database error in PHP but it exists in PHPMyAdmin
  23. Can I blindly replace all mysql_ functions with mysqli_?
  24. How do detect that transaction has already been started?
  25. return multiple response data in one response
  26. CakePHP Database connection “Mysql” is missing, or could not be created
  27. MySQL Alter Table Add Field Before or After a field already present
  28. mysql error ‘TYPE=MyISAM’
  29. Storing datetime as UTC in PHP/MySQL
  30. Escaping SQL queries in Codeigniter

Leave a Comment