Support the ongoing development of Laravel.io →

Forum
Articles
Pastebin
- Discord
- Larachat
- IRC
- Github
- Twitter
- Laravel
- Laracasts
- Laravel News
- Podcast
- Ecosystem

Forum Laravel unique validation on multiple columns for unique relations

(sponsored) Haven't tried PhpStorm yet? Get a special discount on PhpStorm + Laravel plugin bundle ->

jschouwstra

posted 7 years ago

Authentication Database Validation

Last updated 1 year ago.

rdelorier

replied 7 years ago

Solution

Try the unique rule with with additional where clause

'name' => 'unique:games,name,NULL,id,user_id,'.$user->id

http://laravel.com/docs/5.1/validation#rule-unique

Last updated 7 years ago.

jschouwstra

replied 7 years ago

Thank you so much, it works perfectly!

sineld

replied 6 years ago

If using auth:

public function rules() {
	return [
		'email' => 'required|email|unique:users,email,NULL,id,deleted_at,NULL,department_id,' . auth()->user()->department_id,
	];
}

Last updated 6 years ago.

Your banner here too?

jschouwstra jschouwstra Joined 30 Oct 2015

Moderators

driesvints Joined 16 Dec 2013
joedixon Joined 23 Jun 2014
tvbeek Joined 8 Jan 2018
tomhatzer Joined 28 Oct 2021

We'd like to thank these amazing companies for supporting us

Your logo here?

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Forum Articles Pastebin

Socials

Twitter GitHub

The community

Laravel

Laravel News

Laracasts

Laravel Podcast