How can I validate amount

digits_between accepts a number of decimals.

so in your case it would be : digits_between:1,12

Have you tried:

$request->validate([
    'amount' => 'required|numeric|between:1,99999999999999',
]);

When using numeric or integer the between rule will validate against numeric values.

See here:

https://laravel.com/docs/6.x/validation#rule-between

The field under validation must have a size between the given min and max. Strings, numerics, arrays, and files are evaluated in the same fashion as the size rule.

It uses the assumption from the size rule:

https://laravel.com/docs/6.x/validation#rule-size

It can't validate more than the size of the database field throws an exception

SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'amount' at row 1 (SQL: insert into `debits` (`amount`, `particulars`, `debit_date`, `created_by`, `updated_at`, `created_at`) values (999999999999.50, fdsfdsf, 2020-03-04, 1, 2020-03-06 14:03:42, 2020-03-06 14:03:42))

Haven't seen @stereoh answer before posting mine, so this seems a better approach:

$request->validate([
    'amount' => 'required|numeric|digits_between:1,12',
]);

Also if only non-negative amounts are allowed you can try adding:

$request->validate([
    'amount' => 'required|numeric|min:0|digits_between:1,12',
]);

Considering that digits_between expects a digit-only string, if you need to validate the decimal part you could use a custom validation rule:

$request->validate([
    'amount' => ['required', 'numeric', 'min:0', 
        function ($attribute, $value, $fail) {
            $value = floatval($value);

            if ($value < 0 || $value >= 1e12) {
                $fail($attribute . ' is invalid');
            }
        } ],
]);

Where 1e12 is a scientific notation for 1,000,000,000,000.00

You can read about custom closure validators here:

https://laravel.com/docs/6.x/validation#using-closures

I tried @stereoh,

if I input this 9999999999.12

my form will validate The amount must be between 1 and 12 digits. even that amount is accepted.

Which validations rules are you using?

In the last snippet from my last post I removed the digits_between rule as it ignores the decimal separator, see the comment I did there:

Considering that digits_between expects a digit-only string, if you need to validate the decimal part you could use a custom validation rule:

Switch to integer in database and divide by 100 to get the decimal value when retrieving and multiply by 100 when storing in the database.

public function getAmountAttribute($value)
{
	// divide by 100
}

public function setAmountAttribute($value)
{
	// multiply by 100
}

https://laravel.com/docs/7.x/eloquent-mutators#accessors-and-mutators

Then your validation will be easier.

Either use @bugsysha 's option

or

'required|numeric|between:-9999999999.99,9999999999.99'

or if you want only positives

'required|numeric|between:0,9999999999.99'

@stereoh ,

I think your's is working :)

Thank you

There is a rule for decimal decimal:2. This means numeric with 2 decimal places.

https://laravel.com/docs/10.x/validation#rule-decimal