Laravel - Validating Array Input Request Data for Uniqueness within Database

Question

I'm having trouble validating an input array and checking using the unique: validation rule, and I was hoping someone could help me further.

Input (multiple of) from view:

<input type="text" class="form-control" name="contactNames[]" required>

an example of my dd($request):

+request: ParameterBag {#44 ▼
    #parameters: array:6 [▼
        "_token" => "0WBYH4G4aB4XtkQ1Vx29cIvaH7SbYYVcXI6yOuNn"
        "name" => "Brand Name"
        "groupCheckbox" => array:3 [▶]
        "contactNames" => array:2 [▼
            0 => "Contact Name 1"
            1 => "Contact Name 2"
        ]
        "emails" => array:2 [▼
            0 => "[email protected]"
            1 => "[email protected]"
        ]
        "contactNumbers" => array:2 [▼
            0 => "07777777777"
            1 => "07777777777"
        ]
    ]
}

and within my controller, my validation:

$request->validate([
    'name' => 'required|string|max:255|unique:brands',
    'contactNames' => 'required|array',
    'contactNames.*' => 'required|max:255|string|distinct|unique:brand_managers',
    'emails' => 'required|array',
    'emails.*' => 'required|max:255|email|distinct|unique:brand_managers',
    'contactNumbers' => 'array',
    'contactNumbers.*' => 'numeric',
    'groupCheckbox' => 'required|min:1'
]);

I need to check whether a username is unique or not - the validation works fine if I don't use the unique: validation rule and the data posts correctly to my database, however I don't want multiple brand managers with the same details so need to validate the uniqueness of name and email address

The error I am getting is:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contactNames.0' in 'where clause' (SQL: select count(*) as aggregate from brand_managers where contactNames.0 = Contact Name 1)

Thanks for your help in advance

can you post the controller code that you have the validation, where you update the model ? — Vidal
– Vidal, Commented Feb 28, 2019 at 12:46

CodeBoyCode · Accepted Answer · 2019-02-28 12:52:31Z

4

I have found a solution - thanks for the help though - for anyone else in the future who may have the same problem here was my solution:

$request->validate([
    'name' => 'required|string|max:255|unique:brands',
    'contactNames' => 'required|array',
    'contactNames.*' => ['required', 'max:255', 'string', 'distinct', Rule::unique('brand_managers', 'name')],
    'emails' => 'required|array',
    'emails.*' => ['required', 'max:255', 'email', 'distinct', Rule::unique('brand_managers', 'email')],
    'contactNumbers' => 'array',
    'contactNumbers.*' => 'numeric',
    'groupCheckbox' => 'required|min:1'
]);

answered Feb 28, 2019 at 12:52

CodeBoyCode

2,27715 silver badges29 bronze badges

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

3 Comments

omitobi Over a year ago

You could do it with 'contactNames.*' => 'required|max:255|string|distinct|unique:brand_managers,name', also ;) You originally forgot to include the column name in the validation string, the same with email.

CodeBoyCode Over a year ago

yeah thanks man - i realised that after, i use the Rule::unique for the update method, but your way suits the rest of my code

omitobi Over a year ago

Glad you learnt two things with the same problem. All the best. Cheers!

Collectives™ on Stack Overflow

Laravel - Validating Array Input Request Data for Uniqueness within Database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related