Advertisement
Guest User

Untitled

a guest
Apr 13th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. function loginall($username, $password)
  2. {
  3. $db_host="localhost";
  4. $db_username="root";
  5. $db_password="";
  6. $db_name="name";
  7. $con=mysqli_connect($db_host, $db_username,$db_password, $db_name);
  8. $mysqli = new mysqli("$db_host","$db_username","$db_password", "$db_name");
  9.  
  10. $qry = "SELECT username, password, level, active FROM businesses WHERE username=? AND password=?
  11. UNION SELECT username, password, level, active FROM employees WHERE username=? AND password=?";
  12. $stmt = $mysqli->prepare($qry);
  13. $stmt->bind_param("ssss", $u,$p,$uu,$pp);
  14. $u = $username;
  15. $p = $password;
  16. $uu = $username;
  17. $pp = $password;
  18. $stmt->execute();
  19. $result = $stmt->get_result();
  20. while($row = $result->fetch_array(MYSQLI_ASSOC))
  21. {
  22. return $row;
  23. }
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement