include("baglan.php");
include("include/sayfa.php");
if($_POST["q"]<>""){
$sql=" where sehir='$_POST[q]'";
$qq=$_POST["q"];
}else if($_GET["q"]<>""){
$sql=" where sehir='$_GET[q]'";
$qq=$_GET["q"];
}else{
$sql="";
$qq="0";
}
$st=$_GET["st"];
// Make query
if (!$st) $st=0;
$st=(int) $st;
if (!$adet) $adet=8;
$adet=(int) $adet;
if ($adet<1) $adet=8;
$rec=$db -> row("SELECT count(id) as sayi FROM bayiler ".$sql." order by sehir");
$pg=new page_creator();
$pg->TotalItems=$rec->sayi;
$pg->ItemsPerPage=$adet;
$pg->PrevNext=true;
$pg->FirstLast=true;
$pg->TrailingPages=2;
$pg->ShowTotalPages=false;
$pg->ShowTotalPagesString="Toplam Sayfa Sayisi: ";
if($_POST["q"]<>"" or $_GET["q"]<>""){
$pg->nolar="q=".$qq."";
}
$pg->ScriptVariable="st";
$pg->Parameters=array('amount'=>$adet);
$nav=$pg->Create_Pagelinks();
if($_POST["q"]<>""){
$rows = $db->rows("select * from bayiler ".$sql." order by adi asc limit $st,$adet");
}else if($_GET["q"]<>""){
$rows = $db->rows("select * from bayiler ".$sql." order by adi asc limit $st,$adet");
}else{
$rows = $db->rows("select * from bayiler order by sehir,adi asc limit $st,$adet");
}
if($rows){
foreach($rows as $row){
if($row->tel<>"")
$tel='Tel : '.$row->tel.'';
else
$tel="";
if($row->fax<>"")
$fax=' - Fax : '.$row->fax.'';
else
$fax="";
if($row->email<>"")
$email=' - Email : '.$row->email.'
';
else
$email="";
if($row->url<>"")
$web='Web Sitesi :'.$row->url.'';
else
$web="";
$bayiler.='
'.$row->adi.'
Adres : '.$row->adres.'
'.$tel.$fax.$email.$web.'
|
';
}
}else{
$bayiler='Kayıtlı Bayi Bulunamadı...';
}
?>
SANAT DUNYASI | www.sanatdunyasi.com.tr