Validation Rule to ensure a value is within valid Mysql Integer ranges.

Works for signed and unsigned integers of type: TinyInt, SmallInt, Int, BigInt.

Installation

You just require using composer and you're good to go!

composer require rackbeat/laravel-validate-mysql-integers

The Service Provider is automatically registered.

Usage

Class

• Rackbeat\Rules\TinyInteger
• Rackbeat\Rules\SmallInteger
• Rackbeat\Rules\Integer
• Rackbeat\Rules\BigInteger

'number' => [
    new Rackbeat\Rules\BigInteger($unsigned = true),
],

Helper

The helpers are prefixed with "real_" to prevent overlapping. It can take an optional parameter to determine if its unsigned. Defaults to false.

• real_tiny_int
• real_small_int
• real_int
• real_big_int

'id'        => ['real_tiny_int:1'], // unsigned
'number'    => ['real_tiny_int:0'], // signed

Requirements

• PHP >= 7.1

Contributors