8 */ |
8 */ |
9 |
9 |
10 error_reporting(E_ALL ^ E_NOTICE); |
10 error_reporting(E_ALL ^ E_NOTICE); |
11 |
11 |
12 $su = array("ä","ö","ü","ß","Ä","Ö","Ü"); |
12 $su = array("ä","ö","ü","ß","Ä","Ö","Ü"); |
13 $er = array("ä","ö","ü","ß","Ä","Ö","Ü"); |
13 // $er = array("ä","ö","ü","ß","Ä","Ö","Ü"); |
|
14 $er = array("ae","oe","ue","ss","Ae;","Oe","Ue"); |
14 |
15 |
15 $q = strtolower($_GET["term"]); |
16 $q = strtolower($_GET["term"]); // wird in jquery in 'term' uebergeben |
|
17 // $q = strtolower($_GET["q"]); |
16 |
18 |
17 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
19 include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php"); |
18 $dbc = new dbconnection(); |
20 $dbc = new dbconnection(); |
19 |
21 |
20 $sql = "SELECT part_ID, part_firma FROM Partner |
22 $sql = "SELECT part_ID, part_firma FROM Partner |
23 $result = $dbc ->queryObjectArray($sql); |
25 $result = $dbc ->queryObjectArray($sql); |
24 if ($result) |
26 if ($result) |
25 { |
27 { |
26 foreach ($result as $row) |
28 foreach ($result as $row) |
27 { |
29 { |
28 echo $row->part_ID . " - " . str_replace($su,$er,$row->part_firma) . "\n"; |
30 $plist[] = "\"" . $row->part_ID . " - " . html_entity_decode( str_replace($su,$er,$row->part_firma)) ."\""; |
29 } |
31 } |
30 } |
32 } |
31 $dbc -> close(); |
33 $dbc -> close(); |
32 |
34 |
33 |
35 |
|
36 echo "[" . implode(", ", $plist) . "]"; // Format, das jquery source erwartet |
34 |
37 |
35 ?> |
38 ?> |