Guest User

Untitled

a guest
Jun 30th, 2016
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.91 KB | None | 0 0
  1. <?php
  2.     $db = mysqli_connect("mysql5.000webhost.com", "a4990788_user", "abcd1234", "a4990788_user");
  3.    
  4.     $username = $_POST["username"];
  5.     $password = $_POST["password"];
  6.    
  7.     $statement = mysqli_prepare($con, "SELECT * FROM user WHERE username = ? AND password = ?");
  8.     mysqli_stmt_bind_param($statement, "ss", $username, $password);
  9.     mysqli_stmt_execute($statement);
  10.    
  11.     mysqli_stmt_store_result($statement);
  12.     mysqli_stmt_bind_result($statement, $userID, $name, $password, $username, $email, $rank );
  13.    
  14.     $response = array();
  15.     $response["success"] = false;  
  16.    
  17.     while(mysqli_stmt_fetch($statement)){
  18.         $response["success"] = true;  
  19.         $response["name"] = $name;
  20.         $response["password"] = $password;
  21.         $response["username"] = $username;
  22.         $response["email"] = $email;
  23.         $response["rank"] = $rank;
  24.    
  25.     json_encode($response);
  26. ?>
Add Comment
Please, Sign In to add comment