Laravel中如何为单个输入字段同时配置EXIST与IN验证规则

Hey there, let’s dig into why your validation rule for section.2.model_of_vehicle isn’t working as expected. Based on the rule you shared and common gotchas with Laravel validation (I’m assuming you’re using Laravel given the syntax), here are the top issues to check and fix:

1. Trailing Spaces in the in Rule Options #

Looking at your in rule, you’ve got spaces after each comma (like Ford Transit, Ford Tourneo). Those spaces get treated as part of the option value—so if your vehicles table’s model_name entries don’t have that leading space, the validation will fail.

Fix: Remove the spaces after commas in the in list:

'in:Ford Transit,Ford Tourneo,Volkswagen Crafter,Mercedes Sprinter,Toyota Prius Hybrid,Volkswagen Caddy Maxi,Renault Master,Peugeot Boxer,Vauxhall Vivaro,Vauxhall Movano,Other'

2. Conflict Between exists and in Rules (Especially for "Other") #

Right now, your rule requires the value to both exist in the vehicles table AND be in your predefined list. But if "Other" is meant for custom entries that aren’t in the database, the exists rule will block it entirely.

Fix: Use a conditional validation rule to skip the exists check when the value is "Other":

'section.2.model_of_vehicle' => [
    'required',
    'in:Ford Transit,Ford Tourneo,Volkswagen Crafter,Mercedes Sprinter,Toyota Prius Hybrid,Volkswagen Caddy Maxi,Renault Master,Peugeot Boxer,Vauxhall Vivaro,Vauxhall Movano,Other',
    function ($attribute, $value, $fail) {
        // Only check existence if the value isn't "Other"
        if ($value !== 'Other' && !\Illuminate\Support\Facades\DB::table('vehicles')->where('model_name', $value)->exists()) {
            $fail("The selected {$attribute} is not a valid vehicle model in our system.");
        }
    },
]

3. Nested Field Structure Mismatch #

Double-check that your submitted form data actually matches the section.2.model_of_vehicle path. In HTML, nested fields should be named like section[2][model_of_vehicle] to generate the correct array structure in the request.

To confirm, dump the full request data in your controller:

dd($request->all());

Make sure you see section as an array with index 2, which contains model_of_vehicle with the submitted value.

4. Case Sensitivity Issues #

If your database’s collation is case-sensitive (like utf8mb4_bin), a value like ford transit in the table won’t match Ford Transit in your validation list.

Fix: Either:

• Standardize the case in your database and validation list (e.g., all title case), or
• Modify the exists check to be case-insensitive:

  function ($attribute, $value, $fail) {
      if ($value !== 'Other' && !\Illuminate\Support\Facades\DB::table('vehicles')->whereRaw('LOWER(model_name) = ?', [strtolower($value)])->exists()) {
          $fail("The selected {$attribute} is not valid.");
      }
  }
  

5. Missing Error Message Display #

Sometimes validation works, but you just don’t see the error. Ensure your view includes error rendering for this specific field:

@error('section.2.model_of_vehicle')
    <div class="text-red-500">{{ $message }}</div>
@enderror

内容的提问来源于stack exchange，提问作者Yogesh Shrimali