<?php

/**
 * @author Bettina Schwarzer, Fritz-Habet-Institut
 * @copyright 08/2011
 *
 * Autocomplete Partner
 */

    error_reporting(E_ALL ^ E_NOTICE);
    
    $su = array("ä","ö","ü","ß","Ä","Ö","Ü");
//    $er = array("&auml;","&ouml;","&uuml;","&szlig;","&Auml;","&Ouml;","&Uuml;");
    $er = array("ae","oe","ue","ss","Ae;","Oe","Ue");
    
    $q = strtolower($_GET["term"]); // wird in jquery ui in 'term' uebergeben
//    $q = strtolower($_GET["q"]);
    
	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
	$dbc = new dbconnection();

    $sql = "SELECT part_ID, part_firma FROM Partner 
            WHERE part_firma LIKE '%".$q."%' COLLATE latin1_general_ci 
            ORDER BY 2";
    $result = $dbc ->queryObjectArray($sql);
    if ($result)
    {
        foreach ($result as $row)
        {
 			$plist[] = "\"" . $row->part_ID . " - " . html_entity_decode( str_replace($su,$er,$row->part_firma)) ."\"";
		}
        echo "[" . implode(", ", $plist) . "]"; // Format, das jquery source erwartet
   }
    $dbc -> close();

    

?>