Advertisement
x-coder

API LOGIN

Feb 4th, 2017
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.72 KB | None | 0 0
  1. <?php
  2.   header('Access-Control-Allow-Origin: *');
  3.   require_once('supports/connection.php');
  4.   $username = (isset($_POST['username']) && !empty($_POST['username']))?$_POST['username']:"";
  5.   $password = (isset($_POST['password']) && !empty($_POST['password']))?$_POST['password']:"";
  6.  
  7.   $sql = "SELECT * FROM GVEmployeeAccount WHERE username = ? and password = ?";
  8.   $data = array($username,$password);
  9.   $stmt = $conn->prepare($sql);
  10.   $stmt->execute($data);
  11.   $row = $stmt->fetch(PDO::FETCH_NUM,0);
  12.  
  13.   $result[] = array("employeeID" => $row[0],"username" => $row[1]);
  14.  
  15.   if(!empty($row)){
  16.     $json = array("results" => $result);
  17.   }else{
  18.     $json = "Failed";
  19.   }
  20.  
  21.   $conn = null;
  22.   echo json_encode($json);
  23. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement