Advertisement
Guest User

Untitled

a guest
Feb 3rd, 2017
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.94 KB | None | 0 0
  1. <?php
  2.     session_start();
  3.    
  4.     $sq_servername = "localhost";
  5.     $sq_username = "root";
  6.     $sq_password = "";
  7.     $sq_dbname = "music_library";
  8.    
  9.     // Create connection
  10.     $conn = new mysqli($sq_servername, $sq_username, $sq_password, $sq_dbname);
  11.     // Check connection
  12.     if ($conn->connect_error) {
  13.         die("Connection failed: " . $conn->connect_error);
  14.     }
  15.    
  16.     $stmt = $conn->prepare("SELECT id, email, password FROM users WHERE email=?");
  17.     $stmt->bind_param("s", $email);
  18.    
  19.     $email      = $conn->real_escape_string($_POST["email"]);  
  20.     $password   = $conn->real_escape_string($_POST["password"]);
  21.    
  22.     if($stmt->execute()){
  23.         $result = $stmt->get_result();
  24.         if($result->num_rows > 0){
  25.             $row = $result->fetch_assoc();
  26.             if (password_verify( $password, $row["password"])){
  27.                 $_SESSION["userid"] = $row["id"];
  28.                 echo "1";
  29.             } else {
  30.                 echo "2";
  31.             }          
  32.         }else{
  33.             echo "3";
  34.         }
  35.     }else{
  36.         echo "3";
  37.     }
  38.    
  39.     $stmt->close();
  40.     $conn->close();
  41. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement