https://pastebin.com/TXEyKBZq

// Check input errors before inserting in database
if(empty($username_err) && empty($password_err) && empty($confirm_password_err) && empty($email_err)){
    $sql = "INSERT INTO user (username, user_name, user_password, user_email) VALUES (:username, :user_name, :password, :email)";
    if($statement = $connect->prepare($sql)){
        $statement->bindParam(':username', $param_username);
        $statement->bindParam(':password', $param_password);
        $statement->bindParam(':user_name', $param_user_name);
        $statement->bindParam(':email', $param_user_email);
        $param_username = $username;
        $param_password = password_hash($password, PASSWORD_DEFAULT);
        $param_user_email = $email;
        $param_user_name = $_POST['name'];
        if($statement->execute()){
            header("location: login.php");
        } else {
            echo "Something went wrong. Please try again later.";
        }
    }
    unset($statement);
}
unset($connect);