1 <?php

     2 

     3 /**

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

     5  * @copyright 09/2011

     6  *

     7  * Autocomplete Funktionensuche

     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 fkt_bez as label, fkt_bez as val, fkt_ID as id FROM `fhiiqm`.`Funktion` 

    20             WHERE fkt_bez LIKE '%".$q."%' COLLATE latin1_general_ci 

    21             ORDER BY 1";

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

    23     if ($result)

    24     {

    25         foreach ($result as $row)

    26         {

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

    28 		}

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

    30     }

    31     $dbc -> close();

    32 ?>