Laravel Validate Array of Inputs

Question

I have a form:

<input type="text" name="name[1]">
<input type="text" name="name[2]">
<input type="text" name="name[3]">
<input type="submit" value="Submit">

I've created form validation file with rules:

class formRequest extends FormRequest {
....
public function rules()
{
    return ['name.*' => 'unique:names'];
}

public function messages()
{
    return ['name.unique' => 'Name is already in DB!'];
}

After submitting the form with value (e.g. 'John') in input (e.g. name[1]), which already exists in the DB, I get:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name.1' in 'where clause' (SQL: select count(*) as aggregate from `names` where `name`.`1` = John)

So it's treating name.* as for creating another field name, instead of looping through the array.

My Laravel Framework is version 5.4.19. According to the docs, the name.* should work to iterate through an array during validation.

What I am doing wrong?

Laravel validator with a wildcard

LF-DevJourney
– LF-DevJourney

2017-06-16 02:58:04 +00:00
Commented Jun 16, 2017 at 2:58 — LF-DevJourney
– LF-DevJourney, Commented Jun 16, 2017 at 2:58

Aboudeh87 · Accepted Answer · 2017-06-11 19:19:48Z

2

by default if you didn't provide a column name for the unique rule, Laravel will add the input name, and in your case the input name is a number.

to fix this issue change the rule to the following instead:

return ['name.*' => 'unique:names,name'];

answered Jun 11, 2017 at 19:19

Aboudeh87

7155 silver badges17 bronze badges

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

4 Comments

Sergej Fomin Over a year ago

Hey, man! I've spent a day looking for this solution. Where did they write it that I should provide column name???:) This really makes learning programming so hard, because you just don't know where to look for the needed information and spend days trying this and that...

Sergej Fomin Over a year ago

Do you have an advice on how to learn programming, or, particularly, Laravel?:)

Aboudeh87 Over a year ago

Actually the documentation of Laravel is good when you faced a problem i suggest to start from there, and the best website to learn Laravel is Laracast but it is not free :( check unique validation here

Sergej Fomin Over a year ago

thank you! I've read that page several times before posting this question, but didn't get to the end where they list 'Availbale Validation Rules"... Next time I'll read whole page:)

Collectives™ on Stack Overflow

Laravel Validate Array of Inputs

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related