Is there any way to validate a foreign key using Laravel's Validation syntax?

Question

Say I have an object which relates to a mission. Users can upload objects and say that it has a relationship with one of these missions. Is there anyway to check that the mission_id that the user has selected for this object actually exists in this database using Laravel's Validation class and rules?

This way, I can check that mission_id is not only an integer, but also exists in the database.

For example, I guess I'm looking for something like:

$rules = array(     'mission_id' => 'foreignKeyExistsInMissions|integer' ) 

Where foreignKeyExistsInMissions is the validation rule I'm looking for.

Answer 1

This should work:

'mission_id' => 'required|exists:missions,id', 

And the message:

'mission_id.exists' => 'Not an existing ID', 

Source (v4.2 docs)

Source (v5.5 docs)

Source (v7.x docs)

Source (v8.x docs)