1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
<?php
include ('include.php');
// Connexion à la base de donnée
$dbh = ConnectDB();
// Création de la requête
$req = "EXEC sp_Extranet_GetListeTicketsBB '12;14;21;27;31;35;39;55;61;64;67;71;76;79;85;89;','NC','','','','','','', 0, 20, '', 'ASC', 0";
$ret = array();
// Execution de la requête
$sth = $dbh->query($req);
$result = $sth->fetchAll(PDO::FETCH_ASSOC);
if($result)
{
foreach($result as $data)
{
$ticket = array ( 'one' => 1,
'noAppel' => htmlentities($data['noAppel']),
'x' => htmlentities($data['latitude']),
'y' => htmlentities($data['longitude']));
}
echo json_encode($ticket);
}
?> |
Partager