<? require_once('phplib/phplib.php');

check_admin();

$db = mdb2_open($dsn);

$query = <<<EOT
SELECT altlogin id, CONCAT(ppl_login, ' (', altlogin, ')') value
FROM $kldv.ppl
JOIN $kldv.ppl2altlogin USING (ppl_id)
WHERE ppl_login LIKE '%q'
LIMIT 15
EOT;

$result = mdb2_query($db, $query, $_GET['term']);

header("Content-Type: application/json; charset=UTF-8");

$array = $result->fetchAll(MDB2_FETCHMODE_ASSOC);

echo(json_encode($array));

?>