10)) { header("location: /park-city-restaurants"); exit(); }; } else { header("location: /park-city-restaurants"); exit(); }; include($_SERVER['DOCUMENT_ROOT']."/_includes/_constants.php"); include($_SERVER['DOCUMENT_ROOT']."/_includes/_conn.php"); switch ($type) { case "search": $search = addslashes($_REQUEST['keyword']); if (strpos($search,"%") != false) { header("location: /500.php"); exit(); } else { $sql = "select * from Restaurants where RestaurantName like '%" . $search . "%'"; $result = mysqli_query($con,$sql); $num_rows = mysqli_num_rows($result); $desc = "Search results for restaurant keyword search"; $keywords = "Search results for restaurants in Park City"; $htmltitle = "Restaurant Search Results - Sundance Guide"; $pagetitle = "You searched for: " . $search; $pagesubtitle = $num_rows . " match(es) found | New Search"; }; break; case "area": if (is_numeric($_REQUEST['id']) === true) { $area = addslashes($_REQUEST['id']); } else { header("location: /500.php"); exit(); }; $sql = "select * from Restaurants where RestaurantArea = '" . $area . "' order by RestaurantName"; $result = mysqli_query($con,$sql); $num_rows = mysqli_num_rows($result); $areasql = "select * from restaurants_areas where AreaID = '" . $area . "'"; $result2 = mysqli_query($con,$areasql); $arearow = mysqli_fetch_array($result2); $areaname = $arearow['AreaName']; $desc = "Restaurants in the ". $areaname . " area of Park City - Sundance Guide"; $keywords = "Search results for restaurants in Park City"; $htmltitle = "Restaurants in the " . $areaname . " area of Park City - Sundance Guide"; $pagetitle = "Restaurants in " . $areaname . ", Park City"; $pagesubtitle = $num_rows . " match(es) found | New Search"; $resultarea = ""; break; case "price": if (is_numeric($_REQUEST['value']) === true) { $pricerange = addslashes($_REQUEST['value']); } else { header("location: /500.php"); exit(); }; switch($pricerange) { case "1": $pricerangename = "Cheap & Cheerful"; break; case "2": $pricerangename = "Middle of the Road"; break; case "3": $pricerangename = "Expense Account"; break; case "4": $pricerangename = "Someone Else's Tab"; break; }; $sql = "select * from Restaurants where PriceRange = '" . $pricerange . "' order by RestaurantName"; $result = mysqli_query($con,$sql); $num_rows = mysqli_num_rows($result); $desc = "Park City Restaurants in the ". $pricerangename . " Price Range - Sundance Guide"; $keywords = "Search results for restaurants in Park City"; $htmltitle = "Park City Restaurants in the ". $pricerangename . " Price Range - Sundance Guide"; $pagetitle = "Park City Restaurants in the '". $pricerangename . "' Price Range"; $pagesubtitle = $num_rows . " match(es) found | New Search"; break; case "cuisine": if (is_numeric($_REQUEST['id']) === true) { $cuisineid = addslashes($_REQUEST['id']); } else { header("location: /500.php"); exit(); }; $sql = "select * from Restaurants where Cuisine = " . $cuisineid . " order by RestaurantName"; $result = mysqli_query($con,$sql); $num_rows = mysqli_num_rows($result); $namesql = "select * from restaurants_cuisines where CuisineID = '" . $cuisineid . "'"; $result2 = mysqli_query($con,$namesql); $namerow = mysqli_fetch_array($result2); $cuisinename = $namerow['CuisineName']; $desc = $cuisinename . " Restaurants in Park City - Sundance Guide"; $keywords = "Search results for restaurants in Park City"; $htmltitle = $cuisinename . " Restaurants in Park City - Sundance Guide"; $pagetitle = $cuisinename . " Restaurants in Park City"; $pagesubtitle = $num_rows . " match(es) found | New Search"; break; case "food": if (is_numeric($_REQUEST['id']) === true) { $cuisineid = addslashes($_REQUEST['id']); } else { header("location: /500.php"); exit(); }; $sql = "select * from Restaurants where TypeFood like '%#" . $cuisineid . "#%' order by RestaurantName"; $result = mysqli_query($con,$sql); $num_rows = mysqli_num_rows($result); $namesql = "select * from restaurants_foodtypes where FoodTypeID = '" . $cuisineid . "'"; $result2 = mysqli_query($con,$namesql); $namerow = mysqli_fetch_array($result2); $cuisinename = $namerow['FoodTypeName']; $desc = "Park City " . $cuisinename . " Restaurants - Sundance Guide"; $keywords = "Search results for restaurants in Park City"; $htmltitle = "Park City " . $cuisinename . " Restaurants - Sundance Guide"; $pagetitle = "Park City " . $cuisinename . " Restaurants"; $pagesubtitle = $num_rows . " match(es) found | New Search"; }; //$htmltitle = "About this Site - Sundance Guide"; $metadesc = $desc; $metakeywords = $keywords; ?>

 

Search Again

Add a restaurant to our guide >