getAgenciesByEDS.php 641 Bytes
Newer Older
Hamza Arfaoui's avatar
Hamza Arfaoui committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
<?php

include ('../../inc/confNetisse.php');

$TERM = $_REQUEST["term"];
$JSON = "";


// #######################################################################
$q = 'SELECT id_agence, eds, code_agence, nom_agence FROM ca_agences WHERE supp=0 AND eds LIKE :eds ORDER BY nom_agence ASC';
$values = array(':eds' => '%'.$TERM.'%');
$result = excuteQuery($q, $values);
$res = $result['stmt'];
$n = $res->rowCount();
if ($n > 0) {
	$JSON = array();
	while($o = $res->fetchObject()) {	
	    array_push($JSON, array("value"=>$o->eds, "label"=>$o->nom_agence, "agencyId" =>$o->id_agence, "agencyEDS" =>$o->eds));
	}
}

echo json_encode($JSON);

?>