How to get correct data type from MYSQL in Laravel?

Question

PHP

Hello.
I work with Laravel 5.6
The MYSQL database has columns of type int
But when I get data from the database in any way, be it models or a direct query
, I always get back all the data from the database in string format and this makes the development process very difficult, since I have to translate everything manually in Integer
Can I set some PDO settings in the connection?

Answer 1

Discussed the same here. Check that you have the normal version of php and mysql installed.

Answer 2

https://github.com/laravel/framework/blob/1eb1314d...
If I fix it to true, I get the ID as a string.
PDO::ATTR_STRINGIFY_FETCHES => true ,
PDO::ATTR_EMULATE_PREPARES => true ,
If using pure PDO try these options.

Answer 3

For models https://laravel.com/docs/5.6/eloquent-mutators#att...
For regular DB queries you really need to invent something. Why does pdo driver return int as string?

Answer 4

There is some solution on SO , but it looks like something non-standard, IMHO it’s easier in the db class to add a type check when returning from the select, and return already in finished form, something like:

if($row = $sql->fetch(PDO::FETCH_ASSOC) !== false){
       foreach($row as $k=>$v) {
            if(is_numeric($v)) $row[$k] = intval($v);
        }
}

This is also a crutch, but at least you don’t have to wrap everything in checks in every request.