unique_with Validator Rule For Laravel
This package contains a variant of the validateUnique rule for Laravel, that allows for validation of multi-column UNIQUE indexes.
Documentation for older versions
Installation
Install the package through Composer. On the command line:
composer require felixkiss/uniquewith-validator
Configuration
Add the following to your providers array in config/app.php:
'providers' => [
// ...
Felixkiss\UniqueWithValidator\ServiceProvider::class,
],
Usage
Use it like any Validator rule:
$rules = [
'<field1>' => 'unique_with:<table>,<field2>[,<field3>,...,<ignore_rowid>]',
];
See the Validation documentation of Laravel.
Specify different column names in the database
If your input field names are different from the corresponding database columns, you can specify the column names explicitly.
e.g. your input contains a field 'last_name', but the column in your database is called 'sur_name':
$rules = [
'first_name' => 'unique_with:users, middle_name, last_name = sur_name',
];
Ignore existing row (useful when updating)
You can also specify a row id to ignore (useful to solve unique constraint when updating)
This will ignore row with id 2
$rules = [
'first_name' => 'required|unique_with:users,last_name,2',
'last_name' => 'required',
];
To specify a custom column name for the id, pass it like
$rules = [
'first_name' => 'required|unique_with:users,last_name,2 = custom_id_column',
'last_name' => 'required',
];
If your id is not numeric, you can tell the validator
$rules = [
'first_name' => 'required|unique_with:users,last_name,ignore:abc123',
'last_name' => 'required',
];
Add additional clauses (e.g. when using soft deletes)
You can also set additional clauses. For example, if your model uses soft deleting then you can use the following code to select all existing rows but marked as deleted
$rules = [
'first_name' => 'required|unique_with:users,last_name,deleted_at,2 = custom_id_column',
'last_name' => 'required',
];
Soft delete caveat:
In Laravel 5 (tested on 5.5), if the validation is performed in form request class, field deleted_at is skipped, because it's not send in request. To solve this problem, add 'deleted_at' => null to Your validation parameters in request class., e.g.:
protected function validationData()
{
return array_merge($this->request->all(), [
'deleted_at' => null
]);
}
Specify specific database connection to use
If we have a connection named some-database, we can enforce this connection (rather than the default) like this:
$rules = [
'first_name' => 'unique_with:some-database.users, middle_name, last_name',
];
Example
Pretend you have a users table in your database plus User model like this:
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
class CreateUsersTable extends Migration {
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('users', function(Blueprint $table) {
$table->increments('id');
$table->timestamps();
$table->string('first_name');
$table->string('last_name');
$table->unique(['first_name', 'last_name']);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('users');
}
}
<?php
class User extends Eloquent { }
Now you can validate a given first_name, last_name combination with something like this:
Route::post('test', function() {
$rules = [
'first_name' => 'required|unique_with:users,last_name',
'last_name' => 'required',
];
$validator = Validator::make(Input::all(), $rules);
if($validator->fails()) {
return Redirect::back()->withErrors($validator);
}
$user = new User;
$user->first_name = Input::get('first_name');
$user->last_name = Input::get('last_name');
$user->save();
return Redirect::home()->with('success', 'User created!');
});
License
MIT
246 Jan 5, 2023
100 Sep 28, 2022
6 Sep 20, 2022
10.7k Jun 13, 2022
5 Oct 5, 2022
14 Mar 1, 2022
85 Apr 26, 2022
80 Dec 9, 2022
370 Dec 30, 2022
223 Jun 16, 2022
398 Nov 25, 2022
18 Dec 14, 2022
1 Mar 8, 2022
13 Apr 14, 2022
0 Apr 23, 2022
10.2k Jan 4, 2023
56 Oct 27, 2022
374 Dec 23, 2022