discover/uniquecombination-validation

unique check validation by any combination value like comma separated value duplicate entry check

v1.0 2019-04-01 20:31 UTC

Requires

• php: >=5.1.0

MIT

• Moinul Islam Sajib

README

This package is for unique validation with comma separated value('1,2,4') or other separated value('a-k-i') of sigle-column duplicate entry check.

Installation

Install the package through Composer. On the command line:

composer require discover/uniquecombination-validation

Configuration

Add the following to your providers array in config/app.php:

'providers' => [
    // ...

    Discover\UniqueCombination\UniqueCombinationServiceProvider::class,
],

Usage

Use it like any Validator :

$validator = Validator::make($request->all(), [
    'title' => 'required|unique_combination:table_name,column_name,separator',
]);

See the Validation documentation of Laravel.

Example

If you have a database table my_table and column which name is column_1 and the value is (25,36,21) already exists.

Your input field name is name_1 and value is (36,21,25). You want to check unique validation with your database column so that duplicate entry prevent with this comma separated combination:

$validator = Validator::make($request->all(), [
    'name_1' => 'required|unique_combination:my_table,column_1,","',
]);

Example-1

If you have a database table my_table and column which name is name_string and the value is (akash-jhon-jannat) already exists.

Your input field name is name and value is (Jannat-Jhon-akash). You want to check unique validation with your database column so that duplicate entry prevent with this comma separated combination:

$validator = Validator::make($request->all(), [
    'name' => 'required|unique_combination:my_table,name_string,"-"',
]);

You can also use any separator like('-','+') as your need. You can use and sort of combination this. This package is case-sensitive

License

MIT