Рестораны Киева";
include ("inc/nameh.inc");
nameh($nameh,'list.phtml','Рестораны Киева');
// условия поиска
$s = $_GET['s'];
$filename = "list.phtml";
if ($s == "f") {
// результаты поиска
$rayon = $_GET['rayon'];
$kuh = $_GET['kuh'];
$cena = $_GET['cena'];
$card = $_GET['card'];
$sp_menu = $_GET['sp_menu'];
$cat_res = $_GET['cat_res'];
$zakaz = $_GET['zakaz'];
$menu = $_GET['menu'];
$skidka = $_GET['skidka'];
$partner = $_GET['partner'];
$summer = $_GET['summer'];
$coma = ""; $where = ""; $WHERE = "";
$max = 20;
$krit = "";
if ( (empty($begin)) OR ($begin < 0) ) {$begin = 0;}
//echo "1 rayon = $rayon
";
if (!empty($rayon)) {$where .= $coma."rayon = '$rayon'"; $coma = " AND ";
//echo "rayon = $rayon
";
$temp1 = mysql_query("SELECT * FROM `rayon` WHERE `id` = '$rayon'");
$raytemp = mysql_fetch_array($temp1);
$krit .= "район: $raytemp[name]
";
$temp1=""; $raytemp="";
}
if (!empty($kuh)) {$where .= $coma."kat1 LIKE '%$kuh%'"; $coma = " AND ";
$temp1 = mysql_query("SELECT kh, name FROM cuisine WHERE kh = '$kuh'");
$tempkuh = mysql_fetch_row($temp1);
$krit .= "кухня: $tempkuh[1]
";
$temp1="";$tempkuh="";
}
if (!empty($cena)) {$where .= $coma."cena = '$cena'"; $coma = " AND ";
$temp1 = mysql_query("SELECT id, name FROM cena WHERE id = '$cena'");
$tempcena = mysql_fetch_row($temp1);
$krit .= "стоимость: $tempcena[1] на человека
";
$temp1=""; $tempcena="";
}
if (!empty($card)) {$where .= $coma."tipe LIKE '%$card%'"; $coma = " AND ";
$temp1 = mysql_query("SELECT crd, name FROM cr_card WHERE crd = '$card'");
$tempcard = mysql_fetch_row($temp1);
$krit .= "кредитные карты: $tempcard[1]
";
$temp1="";$tempcard="";
}
if (!empty($sp_menu)) {$where .= $coma."sp_menu LIKE '%$sp_menu%'"; $coma = " AND ";
$temp1 = mysql_query("SELECT spm, name FROM sp_menu WHERE spm = '$sp_menu'");
$tempsp_menu = mysql_fetch_row($temp1);
$krit .= "Специальное меню: $tempsp_menu[1]
";
$temp1="";$tempsp_menu="";
}
if (!empty($cat_res)) {
$temp1 = mysql_query('SELECT name FROM vid WHERE id = "'.$cat_res.'"');
$tempcat_res = mysql_fetch_row($temp1);
$where .= $coma.'vid LIKE "%'.$tempcat_res[0].'%"';
$coma = ' AND ';
$krit .= 'Категория заведения: '.$tempcat_res[0].'
';
}
if ($menu == 1) {$where .= $coma."menu = '1'"; $coma = " AND "; $krit .= "с меню в он-лайн
";}
if ($zakaz == 1) {$where .= $coma."zakaz = '1'"; $coma = " AND "; $krit .= "с заказом столика он-лайн
";}
if ($summer == 1) {$where .= $coma."summer = '1'"; $coma = " AND "; $krit .= "с летней площадкой
";}
if ($skidka == 1) {$where .= $coma."skidka > '0'"; $coma = " AND "; $krit .= "со скидкой от Chicken.Kiev
";}
if ($partner == 1) {$where .= $coma."partner > '0'"; $coma = " AND "; $krit .= "Chicken.Kiev рекомендует
";}
$search_string = "$filename?s=f&rayon=$rayon&kuh=$kuh&cena=$cena&card=$card&sp_menu=$sp_menu&cat_res=$cat_res&zakaz=$zakaz&skidka=$skidka&summer=$summer&partner=$partner";
if (!empty($where)) {$WHERE = "WHERE $where";}
if ($temp = mysql_query("SELECT file FROM restoran $WHERE")) {
$total = mysql_num_rows($temp);
$temp = mysql_query("SELECT file FROM restoran");
$all = mysql_num_rows($temp);
echo "Выбрано $total ресторанов (из $all):
";
}
echo "$krit";
// навигация по результатам поиска
if ($begin > $all) {$begin = $begin - $max;}
$links = "страницы
";
for ($i=0; $i < $total; $i = $i + $max) {
$page++;
if ($i == $begin) {$links .= $l." $page"; $l = " |";}
else {$links .= $l." $page"; $l = " |";}
}
$linknext = $begin + $max;
if ($linknext >= $total) {$linknext = "";}
else {$linknext = " следующая";}
$linkbefore = $begin - $max;
if ($linkbefore < 0) {$linkbefore = "";}
else {$linkbefore = "предыдущая ";}
$linkstep = $linkbefore.$linknext;
//echo "$links
$linkstep
";
$linksall = "| $linkbefore | $links | $linknext |
";
//echo "$where, $WHERE
";
if (!empty($total)) {echo "$linksall";}
if ($temp = mysql_query("SELECT * FROM restoran ".$WHERE." ORDER BY partner DESC, name ASC LIMIT ".$begin.", ".$max."")) {
//echo "