/* * ============================================================ * Database Options * Change $dbhost, $dbport, $dbuser, $dbpass and $dbname please * ------------------------------------------------------------ */ $db = 'usr_web1_2'; $dbuser = 'web1'; $dbpass = 'sf071262ts'; $dbhost = 'localhost'; mysql_connect($dbhost,$dbuser,$dbpass) or die("could not connect"); mysql_select_db("$db") or die("could not open database"); $breite = $_GET["breite"]; $laenge = $_GET["laenge"]; $aid = $_GET["aid"]; $sort = $_GET["sort"]; $distance = $_GET["distance"]; $lng = $breite / 180 * M_PI; $lat = $laenge / 180 * M_PI; switch ($sort) { case 0: $sqlstring2 = "SELECT DISTINCT hotels.name, hotels.city_hotel,hotels.currencycode,hotels.minrate,hotels.public_ranking,hotels.hotel_url,hotels.photo_url,hotels.desc_de, (6367.41*SQRT(2*(1-cos(RADIANS(hotels.latitude))*cos(".$lat.")*(sin(RADIANS(hotels.longitude))*sin(".$lng.")+cos(RADIANS(hotels.longitude))*cos(".$lng."))-sin(RADIANS(hotels.latitude))* sin(".$lat.")))) AS distance FROM hotels AS hotels WHERE (6367.41*SQRT(2*(1-cos(RADIANS(hotels.latitude))*cos(".$lat.")*(sin(RADIANS(hotels.longitude))*sin(".$lng.")+cos(RADIANS(hotels.longitude))*cos(".$lng."))-sin(RADIANS(hotels.latitude))*sin(".$lat."))) <= '".$distance."') ORDER BY distance Limit 0,4"; break; case 1: $sqlstring2 = "SELECT DISTINCT hotels.name, hotels.city_hotel,hotels.currencycode,hotels.minrate,hotels.public_ranking,hotels.hotel_url,hotels.photo_url,hotels.desc_de, (6367.41*SQRT(2*(1-cos(RADIANS(hotels.latitude))*cos(".$lat.")*(sin(RADIANS(hotels.longitude))*sin(".$lng.")+cos(RADIANS(hotels.longitude))*cos(".$lng."))-sin(RADIANS(hotels.latitude))* sin(".$lat.")))) AS distance FROM hotels AS hotels WHERE (6367.41*SQRT(2*(1-cos(RADIANS(hotels.latitude))*cos(".$lat.")*(sin(RADIANS(hotels.longitude))*sin(".$lng.")+cos(RADIANS(hotels.longitude))*cos(".$lng."))-sin(RADIANS(hotels.latitude))*sin(".$lat."))) <= '".$distance."') ORDER BY minrate Limit 0,4"; break; case 2: $sqlstring2 = "SELECT DISTINCT hotels.name, hotels.city_hotel,hotels.currencycode,hotels.minrate,hotels.public_ranking,hotels.hotel_url,hotels.photo_url,hotels.desc_de, (6367.41*SQRT(2*(1-cos(RADIANS(hotels.latitude))*cos(".$lat.")*(sin(RADIANS(hotels.longitude))*sin(".$lng.")+cos(RADIANS(hotels.longitude))*cos(".$lng."))-sin(RADIANS(hotels.latitude))* sin(".$lat.")))) AS distance FROM hotels AS hotels WHERE (6367.41*SQRT(2*(1-cos(RADIANS(hotels.latitude))*cos(".$lat.")*(sin(RADIANS(hotels.longitude))*sin(".$lng.")+cos(RADIANS(hotels.longitude))*cos(".$lng."))-sin(RADIANS(hotels.latitude))*sin(".$lat."))) <= '".$distance."') ORDER BY public_ranking DESC Limit 0,4"; break; } $result = mysql_query($sqlstring2) or die('query failed: ' . mysql_error()); echo "
"; echo ""; echo $row['name']; echo " - ".$row['city_hotel'].""; echo " | "; echo "Preise ab: "; echo $row['minrate']; echo " "; echo $row['currencycode']; echo " |
";
echo " |