Level 13
Oct 8, 2019
7
Level 4
Rule::exists Validation of Array
Hey Everyone, I have a requirement to validate a request attribute array contains values that exist in a database table. The submitted array is an array of objects, i can use the id attribute of each object to check that id exists on my database tabel. I think Rule::exists might be suitable to meet the requirement, but I'm unclear how to get access to the submitted values in the array to validate them. What I have so far is below, can you recommend how this requirement can be best solved?
// excerpt of validation rules
'cities' => 'required|array',
'cities.*' => [
Rule::exists('cities')->where(function ($query) {
// i woulld like something like
$query->where('id', $array_item->id)
// but i can't find how i access the array_item
}),
],
Level 7
exists:table,column https://laravel.com/docs/6.x/validation#rule-exists
'cities' => 'required|array',
'cities.*' => 'exists:cities,id'
2 likes
Level 4
Each element in the array I receive on the request is an object, one attribute of which is the id. eg
['id' => 1, 'city' => 'Paris'],
['id' => 2, 'city' => 'Dubai'],
]
How do you recommend getting access to the id attribute and comparing it to the id column in my cities table?
Level 7
'cities' => 'required|array',
'cities.*.id' => 'exists:cities,id'
2 likes
Level 4
Perfect
1 like
Level 4
Hey, maybe anyone know. If I have a huge array and I know that rule "exists" use database query like COUNT(*). So I wonder how many will be queries for DB. Is laravel so smart to do it "where in" way or I will have as many queries as I have array items. Thank you!
Level 1
https://stackoverflow.com/questions/42662579/validate-an-array-of-integers
According to above stackoverflow answer. Yes, laravel uses 'whereIn", when "exists" validation is applied on an array. I don't know how to verify this fact tho, I'm not pro enough.
Please or to participate in this conversation.