20 lines
812 B
PHP
Executable File
20 lines
812 B
PHP
Executable File
<?php
|
|
include("kurs/datenbankanbindung.php");
|
|
$db = dbconnect();
|
|
|
|
#header("Content-Type: text/html;charset=utf-8");
|
|
|
|
if(isset($_GET['getStadt']) && isset($_GET['letters'])){
|
|
$letters = $_GET['letters'];
|
|
$res = $db->query("select distinct bez, str, plz, ort, plz_postfach, postfach, bundesland, staat, mail
|
|
from stan_dienststellen
|
|
where bez like '%".$letters."%' OR plz LIKE '".$letters."%' OR ort LIKE '%".$letters."%'
|
|
ORDER BY name") or die(mysql_error());
|
|
#$row = $res->fetch_array();
|
|
#setcookie("str","$row[str]");
|
|
while($inf = $res->fetch_array()){
|
|
echo $inf["bez"]."~".$inf["str"]."~".$inf["plz"]."~".$inf["ort"]."~".$inf["plz_postfach"]."~".$inf["postfach"]."~".$inf["bundesland"]."~".$inf["staat"]."~".$inf["mail"]."|";
|
|
}
|
|
}
|
|
?>
|