1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
<?php
$without_send_header = true;
require_once(__DIR__ . '/../checkuser.php');
$q = $_GET['q'];
$sql = "
SELECT DISTINCT code FROM mis_event WHERE deleted = 0 AND code LIKE CONCAT('%', ?, '%') ORDER BY code";
$parameters = array($q);
$sth = Db\Util::execute($dbh, $sql, $parameters);
$records = $sth->fetchAll();
$codes = array();
foreach ($records as $record) {
$codes[] = $record['code'];
}
echo json_encode(array(
'results' => $codes,
));
|