Android注册失败：PHP返回用户已存在但数据库无该用户记录

Alright, let's tackle this weird issue where your registration flow connects to the server successfully, but the PHP backend incorrectly says "Hmmm Look Like User Already Exist..." even though the user isn't in your database. Here are the most common causes and how to fix them:

1. 数据库查询逻辑的低级错误 #

This is by far the most frequent culprit. Let's break down what could go wrong here:

• Wrong field used in the query: Double-check if your PHP code is querying the correct column (e.g., you meant to check email but accidentally used name). For example, if your code has:

  $query = "SELECT * FROM users WHERE name = '$email'"; // Oops! Using name instead of email
  

  This would match any existing user with the same name as the input email, leading to a false positive.

• Unsanitized input with extra spaces: Users might accidentally add spaces before/after their email (e.g., test@example.com ). If your backend doesn't trim these spaces, the query would look for that exact string, but if you later check the database manually, you might miss the space. Fix this by trimming inputs first:

  $email = trim($_POST['email']); // Remove leading/trailing whitespace
  

2. 前端-后端参数不匹配 #

Make sure the parameter names your Android app sends match exactly what the PHP backend expects. For example:

• If your EditText for email is sent as Email (capital E) in the request body, but your PHP code uses $_POST['email'] (lowercase e), the $email variable will be empty. A query with an empty email might return all users (if your database allows empty emails), triggering the "user exists" message.

Fix this by aligning parameter names. In your Android code, ensure you're sending the correct keys:

// When building your request parameters (e.g., using Volley or Retrofit)
HashMap<String, String> params = new HashMap<>();
params.put("email", Email.getText().toString().trim()); // Match PHP's $_POST['email']
params.put("name", Name.getText().toString().trim());

3. 错误的数据库/表连接 #

It sounds silly, but it happens: your PHP code might be connecting to a test database instead of your production one, or querying the wrong table. Double-check your database connection credentials in PHP:

$conn = mysqli_connect("localhost", "username", "password", "correct_database_name");

Then run the exact query from your PHP code directly in your database client (like phpMyAdmin or MySQL Workbench) to confirm it returns zero rows.

4. 调试技巧：Print Everything! #

The fastest way to diagnose this is to log every step in your PHP backend. Add these lines to see exactly what's happening:

// Log the input being checked
error_log("Attempting to register email: " . trim($_POST['email']));

// Log the exact query being executed
$email = trim($_POST['email']);
$query = "SELECT * FROM users WHERE email = '$email'";
error_log("Registration check query: " . $query);

// Log the number of rows returned
$result = mysqli_query($conn, $query);
error_log("Rows returned: " . mysqli_num_rows($result));

Check your server's error log (usually in /var/log/apache2/error.log or similar) to see:

• Is the email being captured correctly?
• Does the query look as expected?
• How many rows is it actually returning?

修复示例（安全且正确的PHP代码） #

While you're fixing this, take the opportunity to secure your code against SQL injection using prepared statements:

// Sanitize inputs
$name = trim($_POST['name']);
$email = trim($_POST['email']);
$password = trim($_POST['password']);

// Check if user exists with prepared statement
$checkQuery = "SELECT id FROM users WHERE email = ?";
$stmt = mysqli_prepare($conn, $checkQuery);
mysqli_stmt_bind_param($stmt, "s", $email);
mysqli_stmt_execute($stmt);
mysqli_stmt_store_result($stmt);

if(mysqli_stmt_num_rows($stmt) > 0) {
    echo "Hmmm Look Like User Already Exist...";
} else {
    // Insert new user with prepared statement
    $insertQuery = "INSERT INTO users (name, email, password) VALUES (?, ?, ?)";
    $insertStmt = mysqli_prepare($conn, $insertQuery);
    // Hash the password before storing!
    $hashedPass = password_hash($password, PASSWORD_DEFAULT);
    mysqli_stmt_bind_param($insertStmt, "sss", $name, $email, $hashedPass);
    
    if(mysqli_stmt_execute($insertStmt)) {
        echo "Registration successful!";
    } else {
        echo "Registration failed: " . mysqli_error($conn);
    }
}

// Clean up
mysqli_stmt_close($stmt);
mysqli_close($conn);

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