Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- header('Access-Control-Allow-Origin: *');
- require_once('supports/connection.php');
- $username = (isset($_POST['username']) && !empty($_POST['username']))?$_POST['username']:"";
- $password = (isset($_POST['password']) && !empty($_POST['password']))?$_POST['password']:"";
- $sql = "SELECT * FROM GVEmployeeAccount WHERE username = ? and password = ?";
- $data = array($username,$password);
- $stmt = $conn->prepare($sql);
- $stmt->execute($data);
- $row = $stmt->fetch(PDO::FETCH_NUM,0);
- $result[] = array("employeeID" => $row[0],"username" => $row[1]);
- if(!empty($row)){
- $json = array("results" => $result);
- }else{
- $json = "Failed";
- }
- $conn = null;
- echo json_encode($json);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement