Laravel 4 - How to validate unique with multiple fields?

Question

I have this schema:

Schema::create('members', function(Blueprint $table)
    {
        $table->increments('id');
        $table->string('lname');
        $table->string('fname');
        $table->integer('mname');

        $table->unique(array('lname', 'fname'));
    });

My problem is, how to validate these unique fields?

I tried this but I know this is wrong...

public static $rules = array(
    'lname' => 'unique:members',
    'fname' => 'unique:members'
);

Any help is appreciated.. :)

rahmat · Accepted Answer · 2014-08-09 10:00:02Z

6

You should use this package https://github.com/felixkiss/uniquewith-validator

use it like this:

$rules = array(
    '<field1>' => 'unique_with:<table>,<field2>[,<field3>,...,<ignore_rowid>]',
);

answered Aug 9, 2014 at 10:00

rahmat

1,75716 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anam · Accepted Answer · 2013-12-19 06:39:33Z

3

Try the following:

public static $rules = array(
    'lname' => 'unique:members,lname',
    'fname' => 'unique:members,fname'
);


 'lname' => 'unique:members,lname',
                            ^^^^^ "lname" is a column of members table

More info:

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

answered Dec 19, 2013 at 6:39

Anam

12.2k9 gold badges51 silver badges64 bronze badges

2 Comments

Melvin Over a year ago

I think this would validate if each lname and fname is unique.. What I need to to validate both as unique combined..

Anam Over a year ago

In that case, you need a custom validation.

Collectives™ on Stack Overflow

Laravel 4 - How to validate unique with multiple fields?

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related