error_reporting(E_ALL ^ E_NOTICE); // Notices ausschalten
// Galeri/Bayi ID
$HID=$_REQUEST["HID"];
/*
araba=$_REQUEST["araba"];
yakit=$_REQUEST["yakit"];
marka=$_REQUEST["marka"];
*/
// ara
$Id = $_REQUEST["Id"];
include ("../scripts/open.php");
include ("../funct.php");
$sql = "SELECT firma, mail, yetkili, adres, bundeslaender.Name as il, semt, ort, ";
$sql .= "telefon, telefax, telarea, cep, ceparea, cep2, ceparea2 ";
$sql .= "FROM galerici ";
$sql .= "INNER JOIN bundeslaender ON ( bundeslaender.ID = galerici.bundesland) ";
$sql .= "WHERE galerici.ID=".$HID." LIMIT 1 ";
$res = mysqli_query($connect, $sql);
@$row = mysqli_fetch_array($res);
$firma = $row['firma'];
$mail = $row['mail'];
$yetkili = ascii_str($row['yetkili'], "No");
$adres = ascii_str($row['adres'], "No");
$il = $row['il'];
$ilce = $row['ort'];
$semt = $row['semt'];
if($row['telefon'])
$telefon = ascii_str($row['telarea'], "No").'-'.ascii_str($row['telefon'], "No");
if($row['telefax'])
$fax = ascii_str($row['telarea'], "No").'-'.ascii_str($row['telefax'], "No");
if($row['cep'])
$cep1 = ascii_str($row['ceparea'], "No").'-'.ascii_str($row['cep'], "No");
if($row['cep2'])
$cep2 = ascii_str($row['ceparea2'], "No").'-'.ascii_str($row['cep2'], "No");
?>
- Sıfır 2.el Satılık Araba ilani Otomobil ilan Sitesi
Sıfır ve 2. El Araba Ilanları
Sıfır ve 2. El Araba İlanları
$sql = "SELECT prautoListe.Marke, markenliste.Name, count( * ) anzahl ";
$sql .= "FROM prautoListe ";
$sql .= "inner join markenliste on ( markenliste.ID = prautoliste.Marke ) ";
$sql .= "WHERE prautoliste.Death = 0 ";
$sql .= "and prautoliste.HID = ".$HID." ";
//if($_REQUEST["marka"]>0)
//$sql .= "and Marke = ".$_REQUEST["marka"]." ";
//if($_REQUEST["yakit"]>0)
//$sql .= "and prautoliste.Kraftstoff = ".$_REQUEST["yakit"]." ";
//if($_REQUEST["kasa"]>0)
//$sql .= "and prautoliste.Schnitt = ".$_REQUEST["kasa"]." ";
$sql .= "GROUP BY prautoliste.Marke, markenliste.Name ";
$sql .= "ORDER BY markenliste.Name ";
$res = mysqli_query($connect, $sql);
@$num = mysqli_num_rows($res);
if($num>0){
$_table=0;
for ($i=1;$i<=$num;$i++)
{
$row = mysqli_fetch_array($res);
?>
- ()
if($_REQUEST["marka"]==$row[0])
$marka = $row[1];
}
}
?>
-
if($_REQUEST["marka"]>0) echo "";
?>Tüm
Markalar
$sql = "SELECT Schnitt, t.Name, count( * ) anzahl ";
$sql .= "FROM prautoliste ";
$sql .= "INNER JOIN schnittliste t ON ( t.ID = Schnitt ) ";
$sql .= "WHERE Death = 0 ";
$sql .= "and HID = ".$HID." ";
//if($_REQUEST["marka"]>0)
//$sql .= "and Marke = ".$_REQUEST["marka"]." ";
//if($_REQUEST["yakit"]>0)
//$sql .= "and Kraftstoff = ".$_REQUEST["yakit"]." ";
// if($_REQUEST["kasa"]>0)
// $sql .= "and Schnitt = ".$_REQUEST["kasa"]." ";
$sql .= "GROUP BY Schnitt, t.Name ";
$sql .= "ORDER BY t.Name ";
$res = mysqli_query($connect, $sql);
@$num = mysqli_num_rows($res);
if($num>0){
$_table=0;
for ($i=1;$i<=$num;$i++)
{
$row = mysqli_fetch_array($res);
?>
- ()
if($_REQUEST["kasa"]==$row[0])
$Kasa = $row[1];
}
}
?>
-
if($_REQUEST["kasa"]>0) echo "";
?>Tüm
Kasa Tipi
$sql = "SELECT Kraftstoff, t.Name, count( * ) anzahl ";
$sql .= "FROM prautoliste ";
$sql .= "INNER JOIN kraftstoffliste t ON ( t.ID = Kraftstoff ) ";
$sql .= "WHERE Death = 0 ";
$sql .= "and HID = ".$HID." ";
//if($_REQUEST["marka"]>0)
//$sql .= "and Marke = ".$_REQUEST["marka"]." ";
// if($_REQUEST["yakit"]>0)
// $sql .= "and Kraftstoff = ".$_REQUEST["yakit"]." ";
// if($_REQUEST["kasa"]>0)
// $sql .= "and Schnitt = ".$_REQUEST["kasa"]." ";
$sql .= "GROUP BY Kraftstoff, t.Name ";
$sql .= "ORDER BY t.Name ";
$res = mysqli_query($connect, $sql);
@$num = mysqli_num_rows($res);
if($num>0){
$_table=0;
for ($i=1;$i<=$num;$i++)
{
$row = mysqli_fetch_array($res);
?>
- ()
if($_REQUEST["yakit"]==$row[0])
$Yakit = $row[1];
}
}
?>
-
if($_REQUEST["yakit"]>0) {
echo "Tüm Yakıt ";
}
?>
$sql = "SELECT ";
$sql .= "prautoliste.ID, Titel, Marke, Modell, Schnitt, Preis, para, VB, EZJahr, tosell, takkas, Kraftstoff, PS, ";
$sql .= "Fotozahl, Foto1, Foto2, Foto3, Foto4, Foto5, Foto6, Foto7, Foto8 "; //, t.Name as yakit ";
$sql .= "FROM prautoliste ";
//$sql .= "INNER JOIN kraftstoffliste t ON ( t.ID = Kraftstoff ) ";
$sql .= "WHERE HID = ".$HID." ";
$sql .= "AND Death=0 ";
if($_REQUEST["araba"]>0)
$sql .= "and prautoliste.ID = ".$_REQUEST["araba"]." ";
if($_REQUEST["marka"]>0)
$sql .= "and Marke = ".$_REQUEST["marka"]." ";
if($_REQUEST["yakit"]>0)
$sql .= "and Kraftstoff = ".$_REQUEST["yakit"]." ";
if($_REQUEST["kasa"]>0)
$sql .= "and Schnitt = ".$_REQUEST["kasa"]." ";
$sql .= "ORDER BY Marke ";
$res = mysqli_query($connect, $sql);
$num = mysqli_num_rows($res);
if(!$_REQUEST["araba"] || $_REQUEST["araba"]==0){
?>
Otomobil Web Sitemize Hoşgeldiniz
for ($i=1;$i<=$num;$i++)
{
$row = mysqli_fetch_array($res);
$zeile++;
if($i==1){
echo '';
echo '';
$zeile=1;
}
$URL_LINK='?HID='.$_REQUEST["HID"].'&araba='.$row[0];
/**************************** ARABA ******************************************/
echo '";
/**************************** ARABA SON ******************************************/
echo '';
echo ' | ';
if($zeile==4){
$zeile=0;
echo ' ';
}
echo '';
} //for ($i=1;$i<=$num;$i++)
?>
|
|
} else { //if(!$_REQUEST["araba"]
?>
$AID=$_REQUEST["araba"];
include("zeigedetails.php");
//echo '';
?>
|
} //if(!$_REQUEST["araba"]
/*
*/
?>
/*
*/
?>