I've been debugging this for hours. Double-checking my table and variables carefully. But I couldn't find the problem.
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$user = $_POST['user'];
$pass = $_POST['password'];
$conpass = $_POST['conpass'];
$sql = "SELECT useame FROM account WHERE useame = '$user'";
$result = mysqli_query($co, $sql);
$check_user = mysqli_num_rows($result);
if($check_user > 0){
header("Location: ../signup.php?error=useame");
exit();
}else
{
$encryption = password_hash($pass, PASSWORD_DEFAULT);
$sql = "INSERT INTO account (first_name, last_name, useame, password)
VALUES ('$fname', '$lname', '$user', '$encryption')";
$result = mysqli_query($co, $sql);
if($result){
header("Location: ../index.php?successful");
}else{
header("Location: ../signup.php?error=hahahah");
exit();
}
}
?>
