1 <?php

     2 

     3 /**

     4  * @author Bettina Schwarzer, Fritz-Haber-Institut

     5  * @copyright 09/2011

     6  *

     7  * Autocomplete Mitarbeitersuche

     8  */

     9 

    10     header('Content-type: text/html; charset="iso-8859-1',true); //wg. jquery ui autocomplete

    11     error_reporting(E_ALL ^ E_NOTICE);

    12     

    13     $q = strtolower($_GET["term"]); // wird in jquery in 'term' uebergeben

    14 

    15     

    16 	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");

    17 	$dbc = new dbconnection();

    18 

    19     $sql = "SELECT  CONCAT (nachname, ', ',vorname) as label, CONCAT (nachname, ', ',vorname) as val,persknr as id 

    20             FROM fhiiqm.Mitarbeiter

    21             WHERE nachname LIKE '%".$q."%' COLLATE latin1_general_ci 

    22             ORDER BY 1";

    23     $result = $dbc ->queryObjectArray($sql);

    24     if ($result)

    25     {

    26         foreach ($result as $row)

    27         {

    28  			$clist[] = "{\"label\": \"" . $row->label . "\",\"value\": \"" . $row->val . "\",\"id\": " . $row->id . "}";

    29 		}

    30         echo "[" . implode(", ", $clist) . "]"; // Format, das jquery source erwartet

    31     }

    32     $dbc -> close();

    33 ?>