Not able to display the message "email already exist"

[saqihussainkalan]

signup-process.php : an error occurred in mentioned file,
why these lines of codes doesn't work
}else {
if ($mysqli->errno === 1062) {
die("email already taken");
} else {
die($mysqli->error." ".$mysqli->errno);
}
}

[daveh]

What exactly is the error that you get?

[ProGen18]

it's because you have to replace :
$mysqli = new mysqli(hostname: $host, username: $username, password: $password, database: $dbname);

by :
$mysqli = new mysqli($host_name, $user_name, $password, $database);

I hope this was useful to you 😃

[daveh]

Just to be clear, the above fix is only if you're using a version of PHP prior to version 8. Named arguments are supported from PHP 8 onwards.

[BADBOY303]

signup-process.php : an error occurred in mentioned file,

Error showed in browser:

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

Mentioned error line:
why these lines of codes doesn't work

if ($stmt->execute()) {

header("Location: signup-success.html");
exit;

} else {

if ($mysqli->errno === 1062) {
    die("email already taken");
} else {
    die($mysqli->error . " " . $mysqli->errno);
}

}

[daveh]

Please see this issue to see if any of the fixes there work for you.