Laravel validate int or float numbers as string

Question

in my project. all mount maybe int or float or was even double.in database amount column type is varchar and for each choose amount by user i have simple limitation, for example amount must be more than some value and less that some value. but i get error validation in laravel.

$ps = DB::table('merchant_web_service')->whereCustomerKey($request->input('customer_key'))->first();

/* $ps->minimum_range_buy is 5 and $ps->maximum_range_buy is 10*/

$validate_amount      = Validator::make($request->all(), 
            ['amount' => "required|min:$ps->minimum_range_buy|max:$ps->maximum_range_buy"]);

validator error is:

"The amount must be at least 10 characters."

my test amount values: 1000,100.1

Muhammet · Accepted Answer · 2016-02-20 07:48:43Z

4

Since you didn't specify any rule for the input data type, it validates it as a string. Try numeric and between rules.

$validate_amount = Validator::make($request->all(), 
     ['amount'=>
      "required|numeric|between:$ps->minimum_range_buy,$ps->maximum_range_buy"
     ]);

edited Feb 20, 2016 at 7:48

answered Feb 20, 2016 at 7:41

Muhammet

3,31816 silver badges23 bronze badges

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

2 Comments

user4790312 Over a year ago

this values 1000, 10000.0 and 10000.00 supported by numeric ?

Muhammet Over a year ago

Yes numeric is like a decimal data type.

utsav · Accepted Answer · 2016-02-20 06:31:21Z

2

try this

$rules = [
'your_field' => 'required|regex:/^\d*(\.\d{2})?$/'
]

answered Feb 20, 2016 at 6:31

utsav

6225 silver badges17 bronze badges

3 Comments

user4790312 Over a year ago

for 100.1 i get this message: The amount format is invalid

utsav Over a year ago

are you tried numeric validation rule?

user4790312 Over a year ago

amout is not exactly int or float, is support amout values such as 1000 ,1000.1, 1000.02 ?

Collectives™ on Stack Overflow

Laravel validate int or float numbers as string

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related