Рестораны Киева"; 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 "
"; include ('inc/resinfo.inc'); $viewtype = "searchpage"; while ($res = mysql_fetch_array($temp)) { //echo "
\n"; resinfo($res, $viewtype); echo "
\n"; } echo "
"; if (!empty($total)) {echo "$linksall";} } else {printf ("Ошибка на сервере: %s\n", mysql_error ());} //else {printf ("Ошибка на сервере: %s\n", mysql_error ());} } // begin else alpha elseif ($s == "a") { //$filename = "list.phtml"; $link2 = "$filename?s=a"; include ("inc/alpha.inc"); echo "
"; alpha($link2); echo "
"; echo "
"; $temp = mysql_query("SELECT $lang FROM alphabet WHERE id='$alpha'"); $lett = mysql_fetch_row($temp); $letter = $lett[0]; echo "

".$letter."

"; if ($temp = mysql_query("SELECT * FROM restoran WHERE name LIKE '".$letter."%' ORDER BY name")) { //$res = mysql_fetch_array($temp); //$total = mysql_num_rows($temp); //echo "

$total

"; include ('inc/resinfo.inc'); $viewtype = "searchpage"; while ($res = mysql_fetch_array($temp)) { //echo "
\n"; resinfo($res, $viewtype); echo "
\n"; } } else {printf ("Ошибка на сервере: %s\n", mysql_error ());} echo "
"; echo "
"; alpha($link2); echo "
"; } // end else alpha else { // begin step function step($link) { echo "

Шаг за шагом

"; $temp = mysql_query ("SELECT * FROM restoran"); $links = "страницы "; $total = mysql_num_rows($temp); $max = 20; for ($i=0; $i < $total; $i = $i + $max) { $page++; $links .= $l." ".$page.""; $l = " |"; } echo $links; } // end step // begin rayon function rayon($link) { $temp = mysql_query ("SELECT * FROM rayon ORDER BY alpha"); $mcount = mysql_num_rows($temp); $tab = round ($mcount/3); $i = 0; $tab++; echo "Расположение

"; ?> "; while ($mrayon = mysql_fetch_array($temp)) { $i++; if ($i == $tab) {echo "
";} if ($i == (2*$tab-1)) {echo "";} echo "".$mrayon['name']."
"; } echo "

"; } // end rayon // begin stoimost function stoim($link) { $temp = mysql_query ("SELECT * FROM cena ORDER BY id"); echo "Стоимость

"; while ($msto = mysql_fetch_array($temp)) { echo "".$msto['name']."
"; } echo "
"; }//end stoim // begin kuhni function mkuh($link) { $temp = mysql_query ("SELECT * FROM cuisine ORDER BY name"); $mcount = mysql_num_rows($temp); $tab = round ($mcount/3); $i = 0; $tab++; ?> Кухня

"; while ($mkuh = mysql_fetch_array($temp)) { $i++; if ($i == $tab) {echo "
";} if ($i == (2*$tab)) {echo "";} echo "".$mkuh['name']."
"; } echo "
"; echo "
"; } // end mkuh include ("inc/alpha.inc"); $link = "list.phtml?s=f"; $link2 = "$filename?s=a"; ?> От «А» до «Я»

"; ?>

См. также - «Рестораны в гостиницах Киева»