Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function loginall($username, $password)
- {
- $db_host="localhost";
- $db_username="root";
- $db_password="";
- $db_name="name";
- $con=mysqli_connect($db_host, $db_username,$db_password, $db_name);
- $mysqli = new mysqli("$db_host","$db_username","$db_password", "$db_name");
- $qry = "SELECT username, password, level, active FROM businesses WHERE username=? AND password=?
- UNION SELECT username, password, level, active FROM employees WHERE username=? AND password=?";
- $stmt = $mysqli->prepare($qry);
- $stmt->bind_param("ssss", $u,$p,$uu,$pp);
- $u = $username;
- $p = $password;
- $uu = $username;
- $pp = $password;
- $stmt->execute();
- $result = $stmt->get_result();
- while($row = $result->fetch_array(MYSQLI_ASSOC))
- {
- return $row;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement