get_dept_user.php 559 B

12345678910111213141516
  1. <?php
  2. session_start();
  3. include('../permission/connect_sql.php');
  4. $sql = "SELECT [UserID],[Account],[UserName],[DepartmentID] FROM [User] WHERE [DepartmentID] = ?";
  5. $stmt = sqlsrv_query($conn, $sql, array($_SESSION['UserID']));
  6. $users = array();
  7. while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
  8. $temp = array();
  9. $temp["UserID"] = $row["UserID"];
  10. $temp["Account"] = $row["Account"];
  11. $temp["UserName"] = $row["UserName"];
  12. $temp["DepartmentID"] = $row["DepartmentID"];
  13. array_push($users, $temp);
  14. }
  15. echo json_encode($users);