SAMPLE CODE - hotel room reservation system in php and mysql

Index.php

On the year 2003, Elizabeth Gasataya and Family have started a business. It was Gowri Sankar hotel, located at # 3 Rojas Street, Kabankalan City Negros Occidental Philippines 6111. It was well renovated with 14 air conditioned rooms, Hot and Cold Shower, Cable Television and WIFI area.

</fieldset>

</div>

</div>

</div>

<?php include'sidebar.php';?>

marginheight="0" marginwidth="0"

src="https://www.google.co.in/maps/search/hotel+gowri+shankar+tuticorin+

google+map+link/@13.0475255,80.2090117,11z/data=!3m1!

4b1"></iframe>

<br /><small>View <a href="https://maps.google.com/maps/ms?

msa=0&msid=216284867372251359438.0004f12903dc23b39f7d5&am p;ie=UTF8&t=h&ll=9.991135,122.813008&spn=0.00317,0.0 03219&z=17&source=embed"

style="color:#0000FF;text-align:left">My Saved Places</a> in a larger map</small>

<p>

<p>No 54, D Gin Factory Road,<br/>

Thoothukudi - 628002<br/>

Tel. no. (91)-461-2328877

</p></p>

</fieldset>

</div>

</div>

</div>

<legend><h2 class="text-left">List of Amenities</h2></legend>

<?php

$amen = new Amenities();

$cur = $amen->listOfamenities();

foreach($cur as $amenity){

$image = WEB_ROOT . 'admin/mod_amenities/'.$amenity->amen_image;

echo '<div style=" float:left; margin:7px;">';

echo '<a href="'.$image.'" rel="prettyPhoto[mwaura]"><img src="'.

$image.'" width="100px" height="120px"

style="-webkit-border-radius:5px; -moz-border-radius:5px;" title="'.

$amenity->amen_name.'" alt="'.$amenity->amen_name.'" >

<br>'.$amenity->amen_name.'</a>';

echo'</div>';

}

</fieldset>

</div>

</div>

</div>

<?php include'sidebar.php';?>

<legend><h2 class="text-left">Company Mission</h2></legend>

<p>Provide our guests a unique experience, through which they connect with the best in our company,

and to offer top quality service to our entire guest and provided comfort abundance.</p>

</fieldset>

<legend><h2 class="text-left">Company Vision</h2></legend>

<p>Gowri Sankar Hotel is to provide best quality of services applying top quality

Hotel and conference facilities, in order to fulfill the best way in the relevant needs of every guest.</p>

</fieldset>

<legend><h2 class="text-left">About</h2></legend>

On the year 2003, Elizabeth Gasataya and Family have started a business. It was Gowri Sankar hotel, located at # 3 Rojas Street, Kabankalan City

Negros Occidental Philippines 6111. It was well renovated with 14 air conditioned rooms, Hot and Cold Shower, Cable Television and WIFI area.

</fieldset>

<legend><h2 class="text-left">Featured Rooms</h2></legend>

<?php

$mydb->setQuery("SELECT *,typeName FROM room ro, roomtype rt WHERE ro.typeID = rt.typeID");

$cur = $mydb->loadResultList();

foreach($cur as $room){

$image = 'admin/mod_room/'.$room->roomImage;

echo '<div style=" float:left; margin:7px;">';

echo '<a href="'.$image.'" rel="prettyPhoto[mwaura]"><img src="'.

$image.'" width="100px" height="120px"

style="-webkit-border-radius:5px; -moz-border-radius:5px;"

title="'.$room->roomName.'" alt="'.$room-title="'.$room->roomName.'" >

<br>'.$room->roomName.'<br>'.$room->typeName.'</a>';

echo'</div>';

}

</fieldset>

</div>

</div>

</div>

<?php

require_once("includes/initialize.php");

$content='home.php';

$view = (isset($_GET['page']) && $_GET['page'] != '') ? $_GET['page'] : '';

switch ($view) {

$title="Contacts";

<?php

require_once("includes/initialize.php");

// Four steps to closing a session // (i.e. logging out)

// 1. Find the session session_start();

// 2. Unset all the session variables unset($_SESSION['guest_id']);

unset($_SESSION['to']);

// 4. Destroy the session //session_destroy();

if (!isset($_SESSION['from']) || !isset($_SESSION['to'])){

message("Please Choose check in Date and Check out Out date to continue reservation!", "error");

redirect("index.php?page=5");

}

message("Choose from Adults!", "error");

redirect(".WEB_ROOT. 'booking/");

$_SESSION['child'] = $_POST['child'];

// $_SESSION['roomid']=$_POST['roomid'];

//exit;

//}

echo '<div class="alert alert-info" ><strong>From:'.$arrival. ' To: ' .

$departure.'</strong> </div>';

?></p>

<legend><h2 class="text-left">Room and Rates</h2></legend>

<?php

$mydb->setQuery("SELECT *,typeName FROM room ro, roomtype rt WHERE ro.typeID = rt.typeID");

$cur = $mydb->loadResultList();

foreach ($cur as $result) {

$mydb->setQuery("SELECT STATUS FROM reservation WHERE ((

'$arrival' >= arrival

AND '$arrival' <= departure )

OR (

'$departure' >= arrival

AND '$departure' <= departure )

OR (

arrival >= '$arrival'

AND arrival <= '$departure' )

)

AND roomNo =".$result->roomNo);

$stats = $mydb->executeQuery();

$rows = mysql_fetch_assoc($stats);

$image = 'admin/mod_room/'.$result->roomImage;

echo '<div style="float:left; width:370px; margin-left:10px;">';

echo '<div style="float:left; width:70px; margin-bottom:10px;">';

echo '<img src="'.$image .'" width="180px" height="150px" style="-webkit-border-radius:5px; -moz-style="-webkit-border-radius:5px;"title="<?php echo

$roomName; ?>"/>';

echo '</div>';

echo '<div style="float:right; height:125px; width:180px; margin:0px;

color:#000033;">';

echo '<form name="book" method="POST" action="'.'index.php?

page=5">';

//'. $result->typeName.'<br/>'. $result->price.'<br/>'. $result->Adults.'<br/>

echo '<input type="hidden" name="roomid" value="'.$result->roomNo.'"/>';

echo '<p><strong>Room Type: '.$result->typeName.'<br/>

<strong>Max Adults: >Adults.',<br/> Max Children:

'.$result->Children.'<br/>

<strong>Rate per Night: </strong> '. $result->price.' </p>';

$status=$rows['STATUS'];

if($status=='pending'){

echo '<div style="margin-top:10px; color: rgba(0,0,0,1); font-size:16px;"><strong>Reserve!</strong></div><br>';

}elseif($status=='Confirmed'){

echo '<div style="margin-top:10px; color: rgba(0,0,0,1); font-size:16px;"><strong>Book!</strong></div><br>';

}else{

echo '

<input type="submit" class="btn btn-primary btn-sm" name="btnbook"

onclick="return validateBook();" value="Book Now!"/>

</div>

</div>';

}

echo '</form>';

echo '</div>';

}

</fieldset>

</div>

</div>

</div>

<?php

if(isset($_POST['login'])){

$email = $_POST['log_email'];

$pass = $_POST['log_pword'];

if ($email == '' OR $pass == '') {

message("Invalid Username and Password!", "error");

redirect("index.php");

} else {

$guest = new Guest();

$res = $guest->guest_login($email, $pass);

if($res == true){

redirect("index.php");

}else{

message("Username or Password Not Registered! Contact Your administrator.","error");

redirect("index.php");

} }

}

<div class="col-xs-6 col-sm-3 sidebar-offcanvas" id="sidebar"

role="navigation">

<div class="panel-heading">Rooms Reservation</div>

<label class="control-label" for="from">Check In</label>

<input class="form-control from" size="11" value="<?php echo

(isset($_SESSION['from'])) ? $_SESSION['from'] : ''; ?>" date="" data-date-format="yyyy-mm-dd" data-link-field="any" data-link-format="yyyy-mm-dd" type="text" value="" name="from" id="from">

</div>

<label class="control-label" for="to">Check Out</label>

<input class="form-control to" size="11" type="text" value="<?php echo (isset($_SESSION['to'])) ? $_SESSION['to'] : ''; ?>" name="to" id="to"

date="" date-format="yyyy-mm-dd" link-field="any" data-link-format="yyyy-mm-dd">

<button type="submit" class="btn btn-primary"

align="right"name="avail">Check Availability</button>

</div>

</form>

</div>

<?php if(!isset($_SESSION['guest_id'])){

echo ' <div class="panel-heading">User Login</div>

<input type="email" placeholder="Email" class="form-control"

name="log_email">

<input type="password" placeholder="Password" class="form-control"

name="log_pword">

<button type="submit" class="btn btn-primary" align="right"

<span class="glyphicon glyphicon-user"> </span> Guest Name:<br/>

<p><b>'.$_SESSION['name'].' '.$_SESSION['last'].'</b><br/>

<span class="glyphicon glyphicon-cog"> </span> Email:<br/> <b>'.

$_SESSION['email'].'</b><br/>

<span class="glyphicon glyphicon-cog"> </span> Tel No.:<br/><b> '.

$_SESSION['phone'].'</b><br/><br/>

<a href="logout.php" class="btn btn-default">Logout <span class="glyphicon glyphicon-log-out"></span></a>

</div>

</div>';

}

</div>

<input class="form-control" id="trans" type="label" name="face"

value="">

</form>

<hr>

</div>

</div>

<?php include'sidebar.php';?>

<legend><h2 class="text-left">Location</h2></legend>

<br /><small>View <a href="https://maps.google.com/maps/ms?

msa=0&msid=216284867372251359438.0004f12903dc23b39f7d5&am p;ie=UTF8&t=h&ll=9.991135,122.813008&spn=0.00317,0.0 03219&z=17&source=embed"

style="color:#0000FF;text-align:left">My Saved Places</a> in a larger map</small>

<p><i>our strategic position gives an easy access to the northern tourist corridor circuit, Hells gate Naivasha, Maasai mara, Lake Nakuru and the lake Bogoria hot spirngs. In addition we have easy access to the northern Kenya tourist circuit through the by pass to the Thika road,

mount Kenya national park,Meru national parks

</i></p>

</fieldset>

</div>

media="screen">

</head>

<body>

<legend>Bootstrap-DateTimePicker</legend>

<div class="input-group date form_datetime col-md-5" data-date="1979-09-16T05:25:07Z" data-date-format="dd MM yyyy - HH:ii p"

data-link-field="dtp_input1">

</div>

</div>

<div class="input-group date form_date col-md-5" data-date="" data-date-format="dd MM yyyy" field="dtp_input2"

data-link-format="yyyy-mm-dd">

</div>

</div>

</div>

</div>

</fieldset>

</form>

</div>

charset="UTF-8"></script>

charset="UTF-8"></script>

charset="UTF-8"></script>

//in this line of code, to display the datetimepicker, we used ‘form_datetime’

as an argument to be

//passed in javascript. This is for Date and Time.

$('.form_datetime').datetimepicker({

language: 'en',

//this is for Date only

$('.form_date').datetimepicker({

//this is for Time Only

System testing is the stage of implementation, which is aimed at ensuring that the system works accurately and efficiently before live operation commences. Testing is vital to the success of the system. Testing is the process of executing a program with the explicit intention of finding errors that is making the program fail. The tester may analysts, programmer or a specialist trained for software testing, is actually trying to make the

In document hotel room reservation system in php and mysql (Page 22-58)