get_group.php 498 B

1234567891011121314
  1. <?php
  2. session_start();
  3. include('../permission/connect_sql.php');
  4. $group = array();
  5. $sql = "SELECT [GroupID],[GroupName] FROM [Group] WHERE [GroupID] != 'Admin' AND [GroupID] != 'User' AND [GroupID] != 'Guest'";
  6. $stmt = sqlsrv_query($conn, $sql);
  7. while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
  8. $temp = array();
  9. $temp["GroupID"] = $row["GroupID"];
  10. $temp["GroupName"] = $row["GroupName"];
  11. array_push($group, $temp);
  12. }
  13. echo json_encode($group);