コード例 #1
0
                    </li>
       
                </ul>
            </div>
            <!-- /.navbar-collapse -->
        </div>
        <!-- /.container -->
    </nav>
 <?php 
session_start();
include "../Class/Reservation.php";
include "../../connection.php";
$confirmation = $_SESSION['Confirmation'];
if (isset($_SESSION['Confirmation']) || isset($_SESSION['Customerid'])) {
    $sql = "select tblreservation.Confirmation,tblusers.FirstName,tblreservation.Customer_ID,tblusers.LastName, tblusers.Contact,tblusers.Email,\n        tblrooms.Room_ID,tblrooms.Rate,tblreservation.CategoryName,tblreservation.No_Adult,tblreservation.No_Child,\n        tblreservation.Arrival,tblreservation.Departure,tblreservation.Payable,tblreservation.NumberofDay\n        FROM tblreservation INNER JOIN tblusers\n        ON tblreservation.Customer_ID=tblusers.Customer_ID\n        INNER JOIN tblrooms ON tblrooms.Room_ID=tblreservation.Room_ID\n        WHERE tblreservation.Confirmation= '" . $_SESSION['Confirmation'] . "' OR  tblusers.Customer_ID= '" . $_SESSION['Confirmation'] . "'";
    if (!Reservation::GetCustomerID($_SESSION['Customerid'])) {
        echo "No found Reservation,Please Reserve before View your Reservation Detail ";
    } else {
        $result = mysqli_query($conn, $sql) or die(mysqli_error($conn));
        while ($row = mysqli_fetch_assoc($result)) {
            echo "<form action='' method='POST'>";
            echo "<div class='container' style='margin-top:65px;'><div class='row><div class='col-lg-12'>'";
            echo "<h1 class='page-header'>History Reservation Detail</h1></div>";
            echo "Confirmation code:" . $row['Confirmation'];
            echo "</br>";
            echo "FirstName :" . $row['FirstName'];
            echo "</br>";
            echo "LastName :" . $row['LastName'];
            echo "</br>";
            echo "Contact :" . $row['Contact'];
            echo "</br>";
コード例 #2
0
<?php

include "../connection.php";
include "../Class/Reservation.php";
session_start();
if (isset($_SESSION['Customerid'])) {
    $Customerid = $_SESSION['Customerid'];
    $sql = "select tblreservation.Confirmation,tblcustomers.FirstName, tblcustomers.LastName, tblcustomers.Contact,tblcustomers.Email,\n        tblrooms.Room_ID,tblreservation.CategoryName,\n        tblreservation.Arrival,tblreservation.Departure,tblreservation.Payable,tblreservation.NumberofDay\n        FROM tblreservation INNER JOIN tblcustomers\n        ON tblreservation.Customer_ID=tblcustomers.Customer_ID\n        INNER JOIN tblrooms ON tblrooms.Room_ID=tblreservation.Room_ID\n        WHERE tblcustomers.Customer_ID= '" . $Customerid . "'";
    if (!Reservation::GetCustomerID($Customerid)) {
        echo "No found  Reservation,Please Reserve before View your Reservation Detail ";
    }
    $result = mysqli_query($conn, $sql) or die(mysqli_error($conn));
    while ($row = mysqli_fetch_array($result)) {
        echo "<h1>History Reservation Detail</h1>";
        echo "Confirmation code:" . $row['Confirmation'];
        echo "</br>";
        echo "FirstName :" . $row['FirstName'];
        echo "</br>";
        echo "LastName :" . $row['LastName'];
        echo "</br>";
        echo "Contact :" . $row['Contact'];
        echo "</br>";
        echo "Email :" . $row['Email'];
        echo "</br>";
        echo "Room # :" . $row['Room_ID'];
        echo "</br>";
        echo "Arrival :" . $row['Arrival'];
        echo "</br>";
        echo "Departure :" . $row['Departure'];
        echo "</br>";
        echo "NumberofDays :" . $row['NumberofDay'];