Laravel Eloquent attribute casting doesn't work

Question

I have a field in my database that stores a decimal value. It's defined in my database migration as such:

$table->decimal('buy_amount', 16, 8)->default(0);

Now reading from the database using Laravel Eloquent it returns a string value instead. According to the documentation, I tried casting it in the model file using the $casts array however it makes no difference. It's worth mentioning that every other cast works fine except for decimals.

protected $casts = [ 'buy_amount' => 'decimal:8', ];

This is the result I get:

What am I missing?

Store price as int.

Tpojka
– Tpojka

2021-01-16 00:07:16 +00:00
Commented Jan 16, 2021 at 0:07 — Tpojka
– Tpojka, Commented Jan 16, 2021 at 0:07

Preston · Accepted Answer · 2021-01-15 21:19:22Z

This happens because PHP doesn't have a decimal type, so the value is converted to a string (see this Laracasts post)

When casting to a decimal, the asDecimal(...) function in Illuminate\Database\Eloquent\Concerns\HasAttributes is called; this function uses the native PHP function number_format, which returns a string.

Collectives™ on Stack Overflow

Laravel Eloquent attribute casting doesn't work

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related