Advertisement
Guest User

Untitled

a guest
Aug 25th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 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. }
  25.  
  26. if(!($stmt=$mysqli->prepare($qry))){
  27. return ["Prepare failed: ".mysqli_error($mysqli)]; // what does this say?
  28. }elseif(!$stmt->bind_param("ssss",$u,$p,$uu,$pp)){
  29. return ["Binding parameters failed: (" . $stmt->errno . ") " . $stmt->error];
  30. }else{
  31. $u = $username;
  32. $p = $password;
  33. $uu = $username;
  34. $pp = $password;
  35. if (!$stmt->execute()){
  36. return ["Execute failed: (" . $stmt->errno . ") " . $stmt->error];
  37. }else{
  38. $result = $stmt->get_result();
  39. while($row = $result->fetch_array(MYSQLI_ASSOC)){
  40. $rows[]=$row;
  41. }
  42. return $rows;
  43. }
  44. }
  45.  
  46. .....
  47. ...
  48. .
  49. $stmt->bind_param("ssss", $username, $password, $username, $password);
  50. $stmt->execute();
  51. $stmt->store_result();
  52. $numRows = $stmt->num_rows;
  53. $stmt->bind_result($usernameRow, $passwordRow, $levelRow, $activeRow);
  54. if($numRows > 0) {
  55. while ($stmt->fetch()) {
  56. $u[] = $usernameRow;
  57. $p[] = $passwordRow;
  58. $uu[] = $levelRow;
  59. $pp[] = $activeRow;
  60. }
  61. }
  62. $stmt->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement