Guest User

left join query

a guest
May 17th, 2015
318
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.92 KB | None | 0 0
  1. <?php
  2. session_start();
  3. if(isset($_POST['is_ajax']) && $_POST['is_ajax'])
  4.   {
  5.     $username = mysql_real_escape_string($_POST['username']);
  6.     $password = mysql_real_escape_string($_POST['password']);
  7.        
  8.     include "_class/fpldb.php";
  9.     $logins    = new fpldb();
  10.     $logselect = "users left join posit on users.id_posit = posit.id_posit";
  11.     $logfield  = "users.username, users.password, posit.nm_posit";
  12.     $logwhere  = "users.username ='".$username."' AND users.password ='".$password."'";
  13.     $logselque = $logins->select($logselect,$logfield);
  14.     $logselres = $logins->getResult();
  15.  
  16.     foreach($logselres as $arrlog) :
  17.       $_SESSION['username'] = $arrlog['username'];
  18.       $_SESSION['password'] = $arrlog['password'];
  19.       $_SESSION['position'] = $arrlog['nm_posit'];
  20.       if($username == $_SESSION['username'] && $password == $_SESSION['password'] && $position = $_SESSION['position'])
  21.       {
  22.         echo "success";
  23.       }
  24.     endforeach;
  25.   }
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment