Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if(empty($username_err) && empty($password_err)){
- // Prepare a select statement
- $sql = "SELECT id, username, pasword FROM users WHERE username = ?";
- s
- if($stmt = mysqli_prepare($link, $sql)){
- // Bind variables to the prepared statement as parameters
- mysqli_stmt_bind_param($stmt, "s", $param_username);
- // Set parameters
- $param_username = $username;
- // Attempt to execute the prepared statement
- if(mysqli_stmt_execute($stmt)){
- // Store result
- mysqli_stmt_store_result($stmt);
- // Check if username exists, if yes then verify password
- if(mysqli_stmt_num_rows($stmt) == 1){
- // Bind result variables
- mysqli_stmt_bind_result($stmt, $id, $username, $hashed_password, $user_type_value);
- if(mysqli_stmt_fetch($stmt)){
- if(password_verify($password, $hashed_password)){
- // Password is correct, so start a new session
- session_start();
- // Store data in session variables
- $_SESSION["loggedin"] = true;
- $_SESSION["id"] = $id;
- $_SESSION["username"] = $username;
- $_SESSION["user_type_value"] = $user_type_value;
- // Redirect user to welcome page
- header("location: welcome.php");
- } else{
- // Display an error message if password is not valid
- $password_err = "The password you entered was not valid.";
- }
- }
- } else{
- // Display an error message if username doesn't exist
- $username_err = "No account found with that username.";
- }
- } else{
- echo "Oops! Something went wrong. Please try again later.";
- }
Add Comment
Please, Sign In to add comment