Fatal error: Uncaught mysqli_sql_exception: Duplicate entry '[email protected]' for key 'email'

[Th0ngpv]

Fatal error: Uncaught mysqli_sql_exception: Duplicate entry '[email protected]' for key 'email' in C:\xampp\htdocs\php-signup-login\process-signup.php:45 Stack trace: #0 C:\xampp\htdocs\php-signup-login\process-signup.php(45): mysqli_stmt->execute() #1 {main} thrown in C:\xampp\htdocs\php-signup-login\process-signup.php on line 45

I keep getting this error and don't know what to do .

[daveh]

If you have a unique index on the email column, you'll get this error if you try and insert a new value - what code do you have for catching the duplicate index error?

[poetaetoh]

Try this. Instead of for example

if ($stmt->execute()) {

    header("Location: signup-success.html");
    exit;
    
} else {
    
    if ($mysqli->errno === 1062) {
        die("email already taken");
    } else {
        die($mysqli->error . " " . $mysqli->errno);
    }
}

Change the structure into something like

try
    {
      $stmt->execute();
      header("Location: signup-success.html");
      exit;
    }
catch(Throwable $e)
    {
      echo $e;
      if ($mysqli->errno === 1062) {
        echo "email already taken";
          } else {
              echo "$mysqli->error $mysqli->errno";
          }
    }

Hope it helps.

[Th0ngpv]

add this line of code before check for email

mysqli_report(MYSQLI_REPORT_OFF);