PHP会话变量与预处理语句：注册表单重复插入数据求助

Hey there, let's dig into why your registration form is inserting duplicate entries into the database! You mentioned all core functions (storing data, setting sessions, page redirect) work, but that double-insert issue is annoying—here are the most likely causes and fixes to check:

1. Accidental Double Submissions (User or Browser Triggered) #

• Double-clicked submit button: Users might accidentally click the submit button twice before the page redirects. A quick fix is to disable the button once it's clicked to prevent repeat clicks:

  <button type="submit" onclick="this.disabled = true; this.form.submit();">注册</button>
  

• Page refresh after submission: If the user refreshes the page right after submitting, browsers will re-send the POST request, causing a duplicate insert. You're already using a redirect, but make sure you follow the PRG (Post/Redirect/Get) pattern properly—always add exit; or die(); right after your header("Location: ..."); call to stop script execution immediately.

2. Duplicate Insert Logic in PHP Code #

Check your full PHP script for these oversights:

• Two identical INSERT statements: It's easy to accidentally copy-paste the insert query twice inside your if($_POST) block. For example:

  if($_POST) {
      $sql = "INSERT INTO users (email, password) VALUES ('$email', '$password')";
      mysqli_query($conn, $sql);
      mysqli_query($conn, $sql); // Oops, this second call creates a duplicate!
  }
  

• Included/required files running twice: If your form-handling code is included via include or require multiple times (e.g., in a header and footer), the insert logic will execute twice.

3. Missing exit; After Redirect #

Even if you have a redirect, if you don't terminate the script with exit;, the rest of the code might continue running (including re-executing the insert). Your code should look like this:

if($_POST) {
    // Insert data into database
    $sql = "INSERT INTO users (email, password) VALUES ('$email', '$password')";
    mysqli_query($conn, $sql);
    
    // Set session variable
    $_SESSION['email'] = $email;
    
    // Redirect and STOP script execution
    header("Location: second-page.php");
    exit; // Critical to prevent duplicate execution!
}

4. Database Safety Net (Prevent Future Duplicates) #

As a safeguard, add a unique constraint to your email column in the database. This will block duplicate inserts at the database level and throw an error if a duplicate submission is attempted:

ALTER TABLE users ADD UNIQUE KEY unique_email (email);

Start with checking if you added exit; after your redirect—it's the most common fix for this issue!

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