<?php
require_once '_db.php';

if($_GET["resource"]){

  if ($_GET["resource"]) {
    $stmt = $db->prepare('SELECT * FROM person WHERE designation_id = :resource ORDER BY last, first ');
    $stmt->bindParam(':resource', $_GET['resource']);

 
}
else
{
  $stmt = $db->prepare("SELECT * FROM person ORDER BY last, first ");
}
  $stmt->execute();
  $list = $stmt->fetchAll();


class Employee {}

$result = array();

foreach($list as $employee) {
  $r = new Employee();
  $r->id = $employee['id'];
  $r->name = $employee['last'].', '.$employee['first'];
  //$r->Designation = $employee['Designation'];
  $r->resource=$row['designation_id']
  $result[] = $r;
  
}

header('Content-Type: application/json');
echo json_encode($result);

?>