For money field integer or decimal?

The best way is to use decimal field for money.

But if you have to use integer field:

1. before saving value into db multiply it on 100.
2. after loading value from db divide it on 100.

What I do is store it as Integer and then add new accessors to the model so that I can get it out in currency format

for example $item->price will give me 4599 but $item->priceGBP will give me 45.99 because GBP works with two decimal places.

I used decimal but when I inserting into database it was getting changed. ie. 55400 to 55.0000 , format was (10,4)

Thanks @Snapey , could you explain a little more with example I really need it. Thanks

Check out Accessors and Mutators https://laravel.com/docs/5.2/eloquent-mutators#accessors-and-mutators

For retrieving the value;

Set the column to Integer and add to the model;

    public function getPriceAsCurrencyAttribute(){
        if(isset($this->attributes['price']))
        {
            return money_format('%i', $this->attributes['price']/100);
        }
        return False;        
    }

Use in view etc, $item->priceAsCurrency

See money_format http://php.net/manual/en/function.money-format.php

I used /100 because I only need to support two decimal places. If you need to support more then change as appropriate

to save a new price

Add to model

    public function setPriceFromCurrencyAttribute($value) {

        $this->attributes['price'] = $value*100; 
    }

saving price;

$item->priceFromCurrency = '14.99';

I know this is answered, but the possibility of an issue with using decimal or float is rounding. If your always going to use one type of currency (i.e.: USD) then what ever. But once you don't you'll have issues.