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

check_admin();

$mdb2 = mdb2_open($dsn);


$mdb2->setLimit(15, 0);
$query = <<<EOT
SELECT ppl.ppl_login id, $concat_begin ppl.ppl_forename $concat_cont  ' ' $concat_cont ppl.ppl_prefix $concat_cont ' ' $concat_cont ppl.ppl_surname $concat_cont ' (' $concat_cont ppl.ppl_login $concat_cont ')' $concat_end value
FROM $kldv.ppl
WHERE ppl_name_normalized LIKE '%%%w%%'
EOT;

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

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

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

echo(json_encode($array));

$mdb2->disconnect();

?>