Laravel API 用户注册：如何检测重复邮箱

Hey there! Let's sort out your user registration API step by step—first, I notice a critical bug in your current code, then we'll tackle the duplicate email check properly.

First off, looking at your code, you're assigning all fields to $user->name—that's definitely not right! You meant to set email and password to their respective properties, plus you should always hash passwords (never store plain text passwords!). Here's the quick fix for that part:

$user = new User;
if ($request->input('name')) {
    $user->name = $request->input('name');
}
if ($request->input('email')) {
    $user->email = $request->input('email'); // This was incorrectly set to `name` before!
}
if ($request->input('password')) {
    $user->password = bcrypt($request->input('password')); // Hash the password securely!
}

Now, let's solve the duplicate email problem with three reliable approaches, ordered by best practice:

#1 Use Laravel's Built-in Validation (Highly Recommended) #

Laravel has robust validation rules that handle duplicate checks out of the box, and it automatically returns meaningful error responses. This is the cleanest, most maintainable approach:

Route::post('users/', function(Request $request) {
    // Validate incoming data first—blocks duplicates before any database calls
    $validated = $request->validate([
        'name' => 'required|string|max:255',
        'email' => 'required|string|email|max:255|unique:users', // `unique` rule checks the users table
        'password' => 'required|string|min:8',
    ]);

    // If validation passes, create the user (use mass assignment for simplicity)
    $user = User::create([
        'name' => $validated['name'],
        'email' => $validated['email'],
        'password' => bcrypt($validated['password']),
    ]);

    return response()->json(['user' => $user], 201); // 201 = Created status code
});

Why this works:

• The unique:users rule automatically queries the users table to ensure the email doesn't already exist.
• If validation fails, Laravel sends a JSON response with detailed error messages (status code 422) so your frontend can handle it gracefully.
• Make sure your User model has these fields in the $fillable array to allow mass assignment:

  // app/User.php
  protected $fillable = ['name', 'email', 'password'];
  

#2 Manually Check for Duplicate Emails #

If you need more control over custom error messages or additional logic, you can query the database directly before creating the user:

Route::post('users/', function(Request $request) {
    // Check if email already exists in the database
    if (User::where('email', $request->input('email'))->exists()) {
        return response()->json(['error' => 'This email is already registered'], 409); // 409 = Conflict
    }

    // Validate remaining fields
    $request->validate([
        'name' => 'required|string|max:255',
        'password' => 'required|string|min:8',
    ]);

    // Create and save the user
    $user = new User;
    $user->name = $request->input('name');
    $user->email = $request->input('email');
    $user->password = bcrypt($request->input('password'));
    $user->save();

    return response()->json(['user' => $user], 201);
});

#3 Use firstOrCreate (For Silent Duplicate Handling) #

If your use case is "create the user only if the email doesn't exist, otherwise return the existing user", use Eloquent's firstOrCreate method:

Route::post('users/', function(Request $request) {
    $validated = $request->validate([
        'name' => 'required|string|max:255',
        'email' => 'required|string|email|max:255',
        'password' => 'required|string|min:8',
    ]);

    // Find user by email, or create a new one if it doesn't exist
    $user = User::firstOrCreate(
        ['email' => $validated['email']], // Unique identifier to check
        ['name' => $validated['name'], 'password' => bcrypt($validated['password'])] // Fields to set if creating
    );

    // Return 201 if user was just created, 200 if it already existed
    $statusCode = $user->wasRecentlyCreated ? 201 : 200;
    return response()->json(['user' => $user], $statusCode);
});

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