예제 #1
0
function addHotelData()
{
    $ab = "SELECT DISTINCT * FROM Zimmerbuchung JOIN Hotel ON hotelid=Hotel.id WHERE personenid='" . $_SESSION["username"] . "'\n\t\t\tGROUP BY hotelid ORDER BY Hotel.name";
    $res = mysql_query($ab);
    // echo $ab;
    if (mysql_num_rows($res) == 0) {
        echo "keine Daten verfügbar";
    } else {
        while ($hotel = mysql_fetch_object($res)) {
            $belegung = getBelegteZimmerZahl($hotel->id, TRUE) . "/" . $hotel->zimmerzahl;
            echo '<div class="hotel">
								<div class="hotelBildDiv">
									<img id="hotelBild" src="images/hotels/' . getHotelBild($hotel->name) . '" />
								</div>
								<div class="hotelBeschreibungDiv">
									<div class="hotelBeschreibung">
										<div class="hotelHeader">
											<div class="hotelName">' . $hotel->name . '</div>
											<div class="sterndiv">' . addSterne($hotel->sterne, "images/") . '</div>
										</div>
										<div class="adresseDiv">
											<div class="adresse">' . $hotel->strasse . '</div>
											<div class="adresse">' . $hotel->ort . '</div>
											<div class="adresse">' . getLandNameByISO($hotel->land) . ' ' . getFlagByFlughafenID($hotel->naherFlughafen) . '</div>
										</div>
										<div class="naherFlughafen">
											Naher Flughafen:</br>
											' . getFlughafenOrtByID($hotel->naherFlughafen) . ' (' . $hotel->naherFlughafen . ')
										</div>
										<div class="belegung">
											Zimmerbelegung:</br>
											' . $belegung . '
										</div>
									</div>
								</div>
							</div>';
        }
    }
}
예제 #2
0
파일: hotels.php 프로젝트: class142/proj
function addTableData()
{
    $abfrage = "SELECT * FROM Hotel";
    $ergebnis = mysql_query($abfrage);
    if (mysql_num_rows($ergebnis) == 0) {
        echo "keine Daten vorhanden";
    }
    while ($row = mysql_fetch_row($ergebnis)) {
        //Land besorgen
        $ab = "SELECT * FROM Countries WHERE iso2='" . $row[6] . "'";
        $land = mysql_fetch_object(mysql_query($ab));
        //Zimmerbuchungen besorgen
        $ab1 = "SELECT * FROM Zimmerbuchung WHERE hotelid='" . $row[0] . "' AND von<'" . date("Y-m-d H:i:s") . "' AND bis>'" . date("Y-m-d H:i:s") . "'";
        $zimmer = mysql_num_rows(mysql_query($ab1));
        $zimmer = !$zimmer ? "0" : $zimmer;
        $hotelname = getHotelNameByID($row[0]);
        //Tabellenzeile einfügen
        echo "<tr>";
        echo '<td><div class="box">
		<p class"hover">' . $row[0] . '</p>
		<div class="mask"><img class="minipic" src="../images/hotels/' . getHotelBild($hotelname) . '" width="250" height="270" border="0" alt=' . $hotelname . '></div>
		</td>';
        // echo "<td>" . $row[0] . "</td>";
        echo '<td class="name">' . $row[1] . '<input type="button" class="showZimmer" value="Zimmer" onclick=\'window.location.href = "#' . $row[0] . '"\'/></td>';
        echo "<td style='width:125px;'><p hidden>" . $row[2] . "</p>" . addSterne($row[2]) . "</td>";
        echo '<td><span class="pie">' . $zimmer . '/' . $row[3] . '</span><br>' . $zimmer . '/' . $row[3] . '</td>';
        echo "<td>" . $row[4] . "<br>" . $row[5] . "<br>" . $land->country . "<img src='../images/flags/" . strtolower($row[6]) . ".png'></td>";
        $flughafen = getDistance($row[4] . " " . $row[5], "airport " . $row[8]);
        echo "<td>" . getOrtAndFlag($row[8]) . "<br>" . $flughafen . " km</td>";
        echo "<td><a href='" . $row[7] . "'>Link</a></td>";
        echo "<td><a href='../phpdata/hotelAendern.php?";
        echo addEditList($row[0], "Hotel");
        echo "#openModal'><img src='../images/edit.png'  class='bin'></td>";
        echo "<td><a href='../phpdata/hotelLoeschen.php?id=" . $row[0] . "'><img src='../images/loeschen.png'  class='bin'></td>";
        echo "</tr>";
    }
}
예제 #3
0
파일: getLists.php 프로젝트: class142/proj
function addAutoBild($hotelname)
{
    // echo file_exists("../images/autos/".getHotelBild($hotelname));
    if (file_exists("../images/autos/" . getHotelBild($hotelname))) {
        // echo "../images/hotels/".getHotelBild($hotelname);
        return "<img class='autoBild' src='/design2/images/autos/" . getHotelBild($hotelname) . "'>";
    }
}
예제 #4
0
require "mysqlinit.php";
require "getLists.php";
init();
validateSession("../admin/autos.php");
$larray = array("id", "Marke", "Modell", "Farbe", "Pl&auml;tze", "T&uuml;ren", "Kraftstoff", "Verbrauch", "Schaltung", "PS", "km", "Flughafen", "Vermieter", "Preis");
$valarray = array();
for ($i = 0; $i < 14; $i++) {
    $valarray[$i] = $_GET[$i];
}
$id = $_GET['0'];
if (isset($_POST['submit'])) {
    if ($id == "") {
        $id = $_POST["0"];
    }
    if ($_FILES["autopic"]["tmp_name"] != "") {
        ftpupload($_FILES["autopic"]["tmp_name"], AUTO_DIR, getHotelBild($_POST['0']));
    }
    $farbe = str_replace("#", "", $_POST["3"]);
    $abfrage = "UPDATE Auto SET\n\t\t\t\tid='" . $_POST["0"] . "',\n\t\t\t\tmarke='" . $_POST["1"] . "',\n\t\t\t\tmodell='" . $_POST["2"] . "',\n\t\t\t\tfarbe='" . $farbe . "',\n\t\t\t\tplatzzahl='" . $_POST["4"] . "',\n\t\t\t\ttüren='" . $_POST["5"] . "',\n\t\t\t\tkraftstoff='" . $_POST["6"] . "',\n\t\t\t\tverbrauch='" . $_POST["7"] . "',\n\t\t\t\tschaltung='" . $_POST["8"] . "',\n\t\t\t\tps='" . $_POST["9"] . "',\n\t\t\t\tkm='" . $_POST["10"] . "',\n\t\t\t\tflughafen_id='" . getFlughafenIDByOrt($_POST["11"]) . "',\n\t\t\t\tvermieter_id='" . $_POST["12"] . "',\n\t\t\t\tpreis='" . $_POST["13"] . "'\n\t\t\t\tWHERE id='" . $id . "'";
    // echo $abfrage;
    mysql_query($abfrage);
    header('Location: ../admin/autos.php');
}
?>

<html>
	<head>
		<link rel="stylesheet" type="text/css" href="../css/dialog.css">
		<meta http-equiv="Content-type" content="text/html; charset=utf-8"/>
		<meta name="viewport" content="width=device-width, initial-scale=1" />
		<style>
예제 #5
0
validateSession("../admin/hotels.php");
for ($i = 0; $i < 8; $i++) {
    if ($i == 6) {
        $valarray[$i] = getLandNameByISO($_GET["6"]);
    } else {
        $valarray[$i] = $_GET[$i];
    }
}
$id = $_GET['0'];
if (isset($_POST['submit'])) {
    if ($id == "") {
        $id = $_POST["0"];
    }
    // echo $_FILES["hotelpic"]["tmp_name"];
    if ($_FILES["hotelpic"]["tmp_name"] != "") {
        ftpupload($_FILES["hotelpic"]["tmp_name"], HOTEL_DIR, getHotelBild($_POST['1']));
    }
    $nearAirport = getNearestAirport($_POST["5"], getLandISOByName($_POST["6"]));
    $abfrage = "UPDATE Hotel SET\n\t\t\t\tid='{$id}', \n\t\t\t\tname='" . $_POST["1"] . "',\n\t\t\t\tsterne='" . $_POST["2"] . "',\n\t\t\t\tzimmerzahl='" . $_POST["3"] . "',\n\t\t\t\tstrasse='" . $_POST["4"] . "',\n\t\t\t\tort='" . $_POST["5"] . "',\n\t\t\t\tland='" . getLandISOByName($_POST["6"]) . "',\n\t\t\t\thomepage='" . $_POST["7"] . "',\n\t\t\t\tnaherFlughafen='" . $nearAirport[0] . "'\n\t\t\t\tWHERE id='" . $id . "'";
    // echo var_dump($nearAirport);
    // echo $abfrage;
    mysql_query($abfrage);
    header('Location: ../admin/hotels.php');
}
?>

<html>
	<head>
		<link rel="stylesheet" type="text/css" href="../css/dialog.css">
		<meta http-equiv="Content-type" content="text/html; charset=utf-8"/>
		<meta name="viewport" content="width=device-width, initial-scale=1" />
예제 #6
0
파일: search.php 프로젝트: class142/proj
function genHotel($id, $button = TRUE, $versorgung = null)
{
    $ab2 = "SELECT * FROM Hotel WHERE id='{$id}'";
    $res = mysql_query($ab2);
    $hotel = mysql_fetch_object($res);
    $belegung = getBelegteZimmerZahl($hotel->id) . "/" . $hotel->zimmerzahl;
    $frei = $hotel->zimmerzahl - mysql_num_rows($res);
    $dist = getDistance($hotel->strasse . "" . $hotel->ort, "airport " . $hotel->naherFlughafen);
    $preis = $button ? "ab " . getHotelPreis($hotel->id, null, 0, TRUE) : $_SESSION["preis"]["hotel"];
    // <input class="selectzimmer' . $hotel -> zimmerid . '" Name = "selectzimmer[' . $hotel -> zimmerid . ']"
    // onclick="toggle_visibility_class(\'$selectzimmer' . $hotel -> zimmerid . '\')" value="Zimmer">
    $onclick = "toggle_visibility('zimmer" . $hotel->id . "');";
    $select = $button ? '<input id="suchen" type="button"  onclick="' . $onclick . '" name = "selecthotel[' . $id . ']" value="Zimmer">' : '';
    echo '<div class="hotel' . ($button ? "" : 2) . '">
								<div class="hotelBildDiv">
									<img id="hotelBild" src="images/hotels/' . getHotelBild($hotel->name) . '" /> 
								</div>
								<div class="hotelBeschreibungDiv">
									<div class="hotelBeschreibung">
										<div class="hotelHeader">
											<div class="hotelName">' . $hotel->name . ' (<a href="' . $hotel->homepage . '" target="_blank">info</a>) </div>
											<div class="sterndiv">' . addSterne($hotel->sterne, "images/") . '</div>
										</div>
										<div class="belegung">
											freie Zimmer:
											' . $frei . '
										</div>
										<div class="adresseDiv">
											<div class="adresse">' . $hotel->strasse . '</div>
											<div class="adresse">' . $hotel->ort . '</div>
											<div class="adresse">' . getLandNameByISO($hotel->land) . ' ' . getFlagByFlughafenID($hotel->naherFlughafen) . '</div>
										</div>
										<div class="naherFlughafen">
											Nächster Flughafen:</br>
											' . getFlughafenOrtByID($hotel->naherFlughafen) . ' (' . $hotel->naherFlughafen . '):
											' . $dist . ' km
										</div>
										<div class="hotelPreis">
											' . $preis . ' €
										</div>
										' . $select . '
										
									</div>
								</div>
							</div>';
}