Name:
Age:
Email:
Password:
Phonenumber:
Register
prepare("SELECT * FROM register WHERE Email= :Email");
$email = $_POST['email'];
$checkEmail->bindParam("Email", $email);
$checkEmail->execute();
if ($checkEmail->rowCount() > 0) {
echo 'Email already used before try to use another one please';
} else {
$email = $_GET['email'];
$phonenumber = $_POST['phonenumber'];
$age = $_POST['age'];
$name = $_GET['name'];
$password = $_POST['password'];
$addUser = $database->prepare("INSERT INTO register (name,Email,Phonenumber,Birthdate,Password)
VALUES(:Name,:Email,:Phonenumber,:Birthdate,:Password) ");
$addUser->bindParam("Name", $name);
$addUser->bindParam("Email", $email);
$addUser->bindParam("Phonenumber", $phonenumber);
$addUser->bindParam("Age", $age);
$addUser->bindParam("Password", $password);
if ($addUser->execute()) {
echo "Signed up successfully";
} else {
echo "failed to sign up";
}
}
}
?>
What I have tried:
how can i solve that error pls?