Laravel - API return fields as string while they are int in the DB

Question

I have the following code:

$data['daily_missions'] = DailyMission::with(['userProgress' => function($q) use ($user){
            $q->where('user_id',$user->id);
            }])
        ->orderBy('diamonds')
        ->where('is_daily',1)
        ->get();

In the DB, most of the fields of the DailyMission / userProgress models are integers - but the API return them as string.

for example:

{
price: "123"
}

instead of:

{
price: 123
}

Any idea what can cause this issue?

Version:

"laravel/framework": "5.2.*",

Have you tried casting them to int? laravel.com/docs/5.2/eloquent-mutators#attribute-casting — user8034901
– user8034901, Commented Apr 1, 2020 at 8:21
I don't understand why I need to cast if it's already int in the DB. — TheUnreal
– TheUnreal, Commented Apr 1, 2020 at 8:29
Maybe because Laravel doesn't take the DB column type into consideration? — user8034901
– user8034901, Commented Apr 1, 2020 at 8:38

Tpojka · Accepted Answer · 2020-04-01 14:21:27Z

3

In your model, you should define the field as an integer in the $cast attribute.

protected $casts = [
    'field_name' => 'integer',
];

You can read the docs for more information by opening the following documentation link.

edited Apr 1, 2020 at 14:21

Tpojka

7,0812 gold badges32 silver badges41 bronze badges

answered Apr 1, 2020 at 8:33

Wotta

462 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Seha Karagöz · Accepted Answer · 2022-01-09 12:00:46Z

3

mysqlnd extension doesn't solve the issue on it's own. With it also install nd_pdo_mysql extension then it will solve the issue.

answered Jan 9, 2022 at 12:00

Seha Karagöz

1221 silver badge4 bronze badges

Comments

hehe bu · Accepted Answer · 2020-04-01 08:22:59Z

1

Installing and enabling mysqlnd extension can solve this problem. Hope it helps.

answered Apr 1, 2020 at 8:22

hehe bu

1011 silver badge6 bronze badges

1 Comment

John Smith Over a year ago

Ii doesn't. This problem happens on Homestead (tried on Homestead 10.1.1) which by default comes with mysqlnd enabled. The problem is still there.

Collectives™ on Stack Overflow

Laravel - API return fields as string while they are int in the DB

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related