Laravel unique validation on multiple columns

by

You can use Rule::unique to achieve your validation rule

$messages = [
    'data.ip.unique' => 'Given ip and hostname are not unique',
];

Validator::make($data, [
    'data.ip' => [
        'required',
        Rule::unique('servers')->where(function ($query) use($ip,$hostname) {
            return $query->where('ip', $ip)
            ->where('hostname', $hostname);
        }),
    ],
],
$messages
);

edit: Fixed message assignation

More Related Contents:

  1. Laravel 5.2 Validation Error not appearing in blade
  2. Laravel update model with unique validation rule for attribute
  3. Laravel password validation rule
  4. Laravel: Validation unique on update
  5. How validate unique email out of the user that is updating it in Laravel?
  6. How to Validate on Max File Size in Laravel?
  7. required_if Laravel 5 validation
  8. Custom validator in Laravel 5
  9. How to return custom error message from controller method validation
  10. Laravel: Validate maximum File size?
  11. Check if laravel model got saved or query got executed
  12. MySQLi Error: addcslashes() expects exactly 2 parameters, 1 given
  13. Get the Last Inserted Id Using Laravel Eloquent
  14. Laravel : Syntax error or access violation: 1055 Error
  15. What is ::class in PHP?
  16. How to validate array in Laravel?
  17. Laravel orderBy on a relationship
  18. Creating and Update Laravel Eloquent
  19. Can’t install laravel installer via composer
  20. Laravel 4 – logging SQL queries
  21. Setting up Laravel on a Mac php artisan migrate error: No such file or directory [duplicate]
  22. disable csrf in laravel for specific route
  23. Laravel pluck fields from relations
  24. checking if a number is float in PHP
  25. Regex for password PHP [duplicate]
  26. Natural ORDER in Laravel Eloquent ORM
  27. How to login using Github, Facebook, Gmail and Twitter in Laravel 5.1?
  28. Laravel Auth:attempt() will not persist login
  29. Avoid public folder of laravel and open directly the root in web server
  30. Laravel Eloquent update just if changes have been made

Leave a Comment