Laravel - Unique email & update

Question

I'm stuck with laravel and its unique verification on fields. (in this case, on the email adress's field');

Hampton Paulk Could you help me please ? (thank you for the great introduction to laravel).

When creating a new user:

No problem, It works, It detects if the e-mail has already been taken, and thus display the right message accordingly.

When updating the user information:

It doesn't work anymore.

When creating, my rule for the email field is this one:

    <?php

     $rules = array(
            'email'=>'required|email|unique:users' 
           );
?>

I had to change it to that one for my Update method:

    <?php

    $rules = array(
             'email'=>'required|email' 
                 );
    ?>

If I leave the unique:users rule, It doesn't work, which is logical. Because it detects the entry as being already used...

So, setting this rule with no unique:users rule works, It accepts the update with the same e-mail address left.

The problem is when I modify the email field and put inside this one an email address affected to another user and so already existing in the database.

Laravel display me this message, because the email column has a unique value in my users table.

Illuminate \ Database \ QueryException (23000)

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'geogeoPaige Coley

So how to deal with the error message, and display once again this time in my update form, just next to the email field that the email adress is already being used by another user ?

Answer 1 · 2014-08-12T13:16:05Z

August 12, 2014 1:16pm

I've finally found the way to do it, coudln't figure out how to do it reading the documentation, I was a bit lost.

The rule should be set this way for the update form.

<?php
$rules = array(
        'lastName'=>'required',
        'firstName'=>'required',
        'function'=>'required',
        'email'=>'required|email|unique:users,email,'.$id 
        );
?>

email is the name of my column where I put all my users's email, inside my users table. $id the $id of the current user we are editing the information, basically from what I understand.

This way, you can save the edited information for the user without having the message telling the email address is being used, and at the same time if you specify the e-mail address of someone else, It'll notify you the e-mail is already taken.

Welcome to the Treehouse Community

Looking to learn something new?

geoffrey

geoffrey

Laravel - Unique email & update

When creating a new user:

When updating the user information:

1 Answer

geoffrey

geoffrey