database returning string value for integer columns

Solutions on MaxInterview for database returning string value for integer columns by the best coders in the world

Search
showing results for - "database returning string value for integer columns"
Adèle
16 Aug 2018
1When you select data from a MySQL database using PHP the datatype will always 
2be converted to a string. You can convert it back to an integer using the 
3following code:
4
51. $id = (int) $row['userid'];
6
72. For Laravel you can also use cast variable inside your model where you can 
8   set them as integer.
9   
10   Example :  protected $casts = [
11                  'default' => 'integer',
12                  'phonecode' => 'integer',
13              ];
14    
15############################ OR ######################################
16
17The Other solution is from the server where you need to have access to change
18your PHP extensions so inside that you just need to revert some extensions
19
20mysql && mysqli && pdo_mysql
21
22###################### TO ########################
23
24mysqlnd && nd_mysql && nd_mysqli && nd_pdo_mysql
25
26For more details regarding these extensions are mentioned here
27https://cloudlinux.zendesk.com/hc/en-us/articles/115004347574-Missing-MySQL-extension-or-MySQL-ND-vs-MySQL-
28
similar questions
get number of columns sqlprint integer and string in sqlsql value of stringget the db column names from a sqldatareaderparsing float to int in mysqlhow to find columns with null values in sqlsql query print strings and intget columns number sqlsql query to get column names and data types in sql serverconvert float to int sqlsql number columnssql convert to integer from decimalstring to int mysqlcheck if string is a number sqlmysql select columns as string
queries leading to this page
php mysql type inthtml option selected string in sql database shows number instead stringphp use mysqli field as stringmysql integer field is returned as string in phpphp mysqli retrieve data inthow to create automatic value string in php using mysqlphp mysql fetch row as intnumber to string php mysqldatabase returning string value for integer columnsphp mysql converts numeric to stringnu cannot use where for integerdatabase returning string value for integer columns