//hier die mysql daten eintragen
$hostname = “localhost”;
//$dbname = “usr_web58_1”;
//$username = “web58”;
//$password = “Wtpjbt$1u”;
$dbname = “gratt_sschuhe1”;
$username = “gratt_sschuhe1”;
$password = “qV2YtejVeddvEmdj”;
$nebeneinander = 3;
function show_haendler2($row)
{
$bez = ““.$row[‘name’].”
“;
if($row[‘zusatz1’] != “”)
{
$bez .= $row[‘zusatz1’].”
“;
if($row[‘zusatz2’] != “”)
$bez .= $row[‘zusatz2’].”
“;
}
if($row[‘strasse’]!=””)
$bez .= $row[‘strasse’].”
“;
$bez .= $row[‘land’].”-“.$row[‘plz’].” “.$row[‘ort’].”
“;
if($row[‘tel’] != “”)
$bez .= $row[‘tel’].”
“;
if($row[‘fax’] != “”)
$bez .= $row[‘fax’].”
“;
if($row[’email’] != “”)
$bez .= “{$row[’email’]}
“;
if($row[‘homepage’] != “”)
$bez .= “{$row[‘homepage’]}
“;
echo $bez;
}
$mydb = @ mysql_connect($hostname, $username, $password);
if(!mydb) die(“Die Verbindung zu MySQL konnte nicht erstellt werden! Bitte benachrichtigen Sie den Administrator!”);
mysql_select_db($dbname, $mydb) or die(“Die Verbindung zur Datenbank konnte nicht erstellt werden! Bitte benachrichtigen Sie den Administrator!”);
//Länderunterscheidung
$country = array(“A” => “Österreich”, “D” => “Deutschland”, “CH” => “Schweiz”,
“B” => “Belgien”, “I” => “Italien”, “J” => “Japan”, “DK” => “Dänemark”,
“NL” => “Niederlande”, “PL” => “Polen”, “S” => “Schweden”);
$land = $_GET[‘land’];
if($country[$land] == “”)
$land = “”;
if($land == “” || $land == “A”)
{
$sql = “SELECT bundesland FROM haendler2 WHERE land=’A’ GROUP BY bundesland ORDER BY bundesland ASC”;
$res = mysql_query($sql);
$i = 0;
while($row = mysql_fetch_array($res))
{
$province[$i++] = $row[‘bundesland’];
}
$land = “A”;
$addL = ” AND land=’A'”;
}
elseif($land == “D”)
{
$sql = “SELECT bundesland FROM haendler2 WHERE land=’D’ GROUP BY bundesland ORDER BY bundesland ASC”;
$res = mysql_query($sql);
$i = 0;
while($row = mysql_fetch_array($res))
$province[$i++] = $row[‘bundesland’];
$addL = ” AND land=’D'”;
}
if($_POST[‘submit’] == “Suchen”)
{
$name = mysql_real_escape_string($_POST[‘name’]);
$plz = mysql_real_escape_string($_POST[‘plz’]);
$ort = mysql_real_escape_string($_POST[‘ort’]);
$bundesland = $_POST[‘bundesland’];
if($index = array_search($bundesland, $province))
$bundesland = $province[$index];
else
$bundesland = $province[0];
$add = “”;
if($name != “”)
{
$add .= “`name` LIKE ‘%{$name}%'”;
}
else if($plz != “”)
{
if(($land == “A” && strlen($plz) < 4) ||
$land == “D” && strlen($plz < 5)) { $add .= “`plz` LIKE ‘{$plz}%'”; } else { $add .= “`plz`='{$plz}'”; $add2 .= “`plz` LIKE ‘”.substr($plz, 0, strlen($plz)-1).”%’ AND plz!={$plz}”; $add3 .= “`plz` LIKE ‘”.substr($plz, 0, strlen($plz)-2).”%’ AND plz NOT LIKE ‘”.substr($plz, 0, strlen($plz)-1).”%’ AND plz!={$plz}”; } } else { if($ort != “”) $add .= “`ort` LIKE ‘%{$ort}%'”; } if($bundesland != “”) { if($add != “”) $addBL = ” AND “; $addBL .= “`bundesland`='{$bundesland}'”; } $order = ” ORDER BY plz ASC”; $sql_plz = “SELECT plz FROM haendler2 WHERE “.$add.$addBL.$addL.” GROUP by plz”.$order; $res = mysql_query($sql_plz); $p = 0; while($row = mysql_fetch_array($res)) { $gplz[$p] = $row[‘plz’]; ++$p; } if($add2 != “”) { $sql_plz = “SELECT plz FROM haendler2 WHERE “.$add2.$addBL.$addL.” GROUP by plz”.$order; $res = mysql_query($sql_plz); while($row = mysql_fetch_array($res)) { $gplz[$p] = $row[‘plz’]; ++$p; } } if($add3 != “”) { $sql_plz = “SELECT plz FROM haendler2 WHERE “.$add3.$addBL.$addL.” GROUP by plz”.$order; $res = mysql_query($sql_plz); while($row = mysql_fetch_array($res)) { $gplz[$p] = $row[‘plz’]; ++$p; } } if(is_array($gplz)) sort($gplz); $sql = “SELECT * FROM haendler2 WHERE “.$add.$addBL.$addL.$order; $res = mysql_query($sql); if(mysql_num_rows($res) == 0) { $noAdd = true; ?>
Es wurde kein Händler mit den exakten Suchkriterien gefunden.
Folgende Händler wurden für Ihre Suchkriterien gefunden:
for($i = 0; $i < count($gplz); $i++) { echo ““.$gplz[$i].” “; } ?> |
{
if($noAdd == true)
{
?>
for($i = 0; $i < count($gplz); $i++) { echo ““.$gplz[$i].” “; } ?> |
{
if($noAdd == true && $noAdd2 == true)
{
?>
for($i = 0; $i < count($gplz); $i++) { echo ““.$gplz[$i].” “; } ?> |