How to properly validate and store a price in DB?

Question

I have this Html where a user can introdue a price:

<div class="form-group col-md-6">
    <label for="price">Price</label>
    <input type="number" min="1" step="any"
           required value="{{ old('price', '0.00€') }}"
           name="price" id="price" placeholder="Price (Ex: 10.00)"/>
</div>

I have this jquery so if the user introduce for example "2" in the input will appear "2,00":

document.getElementById("price").onblur =function (){
    this.value = parseFloat(this.value.replace(/,|\€/g, ""))
        .toFixed(2)
        .toString()
        .replace(/\B(?=(\d{3})+(?!\d))/g, ".");
}

Now Im in doubt how to validate the price and how to store the price in db. In the database i created the column "price" as a decimal. It should be inserted in the database "2" or "2,00"?

And in validate method how to validate if the price has the valid format?

$this->validate($request, [
       ...
        'registration_type_price' => 'required|double',
 ]);

why you are using comma in price ? any specific reason. because it is not good practice , i think , you need only numeric value in this case, you can use comma delimeter in case of reports using number_format http://php.net/manual/en/function.number-format.php — Shawinder Jit Singh, Apr 06 '18 at 15:48

m1alesis · Accepted Answer · 2018-04-06T16:26:09.823

Its your choice how you want to display the price in the view. But in DB you want to store the currency as integer format and store the cents.

For example if you have $15.50 you would store 1550 (this applies to any currency and not just USD). Read more here: Why not use Double or Float to represent currency?

Also, if you handle multiple currency, create a varchar field to store currency such as GBP, USD etc. For info on currency codes : https://en.wikipedia.org/wiki/ISO_4217

score 0 · Answer 2 · answered Apr 06 '18 at 16:19

0

Your POST value seems to be a float so,

Use regex

$regex = "/^(?=.+)(?:[1-9]\d*|0)?(?:\.\d+)?$/";
$this->validate($request, [
   ...
    'registration_type_price' => 'required|regex:'.$regex,
 ]);

Let me know if not work

answered Apr 06 '18 at 16:19

afsal c

612
4
12

How to properly validate and store a price in DB?

2 Answers2