Can someone help me:
I got error when i write this
$check = $db->prepare("SELECT email FROM user WHERE email = ?");
if($check->rowCount() == 1){
$error = "<div class ='text-danger'> Email Telah Digunakan </div>";
} else {
$code = rand();
$status = 0;
try{
$query = $db->prepare("INSERT INTO users(first_name,last_name,email,password,gender,code,status) VALUES (?,?,?,?,?,?,?,)");
$query->execute([$first_name,$last_name,$email,password_hash($password,PASSWORD_DEFAULT),$gender,$code,$status]);
}
catch(PDOException $e){
echo"error: " .$e->getMessage();
}
}