Laravel - validate input with Rule::unique

Question

How can I validate variable if variable name is different then name of column in DB.

 'gameDetails.title' => [
                'required',
                'string',
                'between:3,100',
                Rule::unique('games')->ignore($this->input('gameId')),
            ],

In above example my input variable name is "gameDetails.title" but in DB my column name is just title. So in this case I have this error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'gameDetails.title' in 'where clause'

So how to tell "laravel" my column name is just "title"?

Thank you.

Is gameDetails the name of your database table?

Adam Rodriguez
– Adam Rodriguez

2018-10-16 19:52:50 +00:00
Commented Oct 16, 2018 at 19:52 — Adam Rodriguez
– Adam Rodriguez, Commented Oct 16, 2018 at 19:52

Angad Dubey · Accepted Answer · 2018-10-16 20:28:32Z

0

The unique validator takes a second param that is the name of the column in the database:

Rule::unique('games','title')->ignore($this->input('gameId'))

https://laravel.com/docs/5.7/validation#rule-unique

/**
 * Get a unique constraint builder instance.
 *
 * @param  string  $table
 * @param  string  $column
 * @return \Illuminate\Validation\Rules\Unique
 */
public static function unique($table, $column = 'NULL')
{
    return new Rules\Unique($table, $column);
}

edited Oct 16, 2018 at 20:28

answered Oct 16, 2018 at 19:48

Angad Dubey

5,4728 gold badges33 silver badges53 bronze badges

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

1 Comment

Klick Over a year ago

Thank you for information. You did a misspelling, should be "Rule::unique('games', 'title')" I guess. Because my version works.

Collectives™ on Stack Overflow

Laravel - validate input with Rule::unique

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related