MySQL integer field is returned as string in PHP MySQL integer field is returned as string in PHP mysql mysql

MySQL integer field is returned as string in PHP


php mysql types int gettype

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']);

php mysql types int gettype

Use the mysqlnd (native driver) for php.

If you're on Ubuntu:

sudo apt-get install php5-mysqlndsudo service apache2 restart

If you're on Centos:

sudo yum install php-mysqlndsudo service httpd restart

The native driver returns integer types appropriately.

As @Jeroen has pointed out, this method will only work out-of-the-box for PDO.
As @LarsMoelleken has pointed out, this method will work with mysqli if you also set the MYSQLI_OPT_INT_AND_FLOAT_NATIVE option to true.

Example:

$mysqli->options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, TRUE);

php mysql types int gettype

Easiest Solution I found:

You can force json_encode to use actual numbers for values that look like numbers: 

json_encode($data, JSON_NUMERIC_CHECK)

(since PHP 5.3.3).

Or you could just cast your ID to an int.

$row = $result->fetch_assoc();$id = (int) $row['userid'];

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last