<?php
require_once '_db.php';

//$json = file_get_contents('php://input');
//$params = json_decode($json);

$stmt = $db->prepare("SELECT * FROM designation ORDER BY name");
$stmt->execute();
$designations = $stmt->fetchAll();

class Item {}

$result = array();

foreach($designations as $designation) {
  $r = new Item();
  $r->id = $designation['id'];
  $r->name = $designation['name'];
  $result[] = $r;
  
}

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