<?
include '../include/connect.php';
if (!isset($_SESSION['admin'])) {
header('location: ../index.php');
exit();
}
else
{
$sess_username =$_SESSION['admin'];
}
?>
<!DOCTYPE HTML>
<head>
<title>JOEN Nails and Spa</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<link href="../css/style.css" rel="stylesheet" type="text/css" media="all"/>
<script src="../js/jquery.min.js"></script>
</head>
<body>
<div class="header">
<div class="header_top">
<div class="wrap">
<div class="logo">
<a href="index.php"><img src="../images/logo.png" alt="" /></a>
</div>
<div class="call">
<link rel="shortcut icon" href="../../favicon.ico">
<link rel="stylesheet" type="text/css" href="../css/normalize.css" />
<link rel="stylesheet" type="text/css" href="../css/demo.css" />
<link rel="stylesheet" type="text/css" href="../css/component.css" />
<link rel="stylesheet" type="text/css" href="../css/content.css" />
<script src="js/modernizr.custom.js"></script>
<style type="text/css">
.appointments-table {
border-collapse: collapse;
}
.appointments-table td {
border: 1px solid #444;
padding: 5px;
}
.container {
width: 900px;
}
legend {
color: #888;
margin-left: 10px;
padding: 5px 10px 10px 10px;
border: 1px solid #888;
border-radius: 5px;
}
fieldset {
list-style: none;
margin: 0;
padding: 30px 30px 30px 30px;
border: 1px solid #888;
border-radius: 5px;
}
fieldset label {
display: block;
margin-top: 5px;
}
</style>
<div class="welcome">
Welcome <?=$sess_username?>
<input name="btnlogout" type="button" value="Log Out" onClick="location='logout.php'" class="button"/>
</div>
</div>
<div class="clear"></div>
</div>
</div>
<div class="header_bottom">
<div class="wrap">
<div class="menu">
<ul>
<li><a href="index.php">Home</a></li>
<li class="active"><a href="appointments.php">Reservations</a></li>
<li><a href="announcement.php">Announcements</a></li>
<li><a href="pending-registrations.php">Pending Registrations</a></li>
<div class="clear"></div>
</ul>
</div>
<div class="social-icons">
<ul>
<li><a href="#"><img src="../images/facebook.png" alt="" /></a></li>
<li><a href="#"><img src="../images/twitter.png" alt="" /></a></li>
<li><a href="#"><img src="../images/google-plus.png" alt="" /></a></li>
<li><a href="#"><img src="../images/vimeo.png" alt="" /></a></li>
</ul>
</div>
<div class="clear"></div>
</div>
</div> <br>
<div class="main">
<div class="content">
<div class="wrap">
<div class="container">
<fieldset>
<legend>Reservation Requests</legend>
<div class="banner">
<?php
$month = $_GET['month'];
$day = $_GET['day'];
$sql = "SELECT * FROM reservation WHERE month='$month' AND day='$day'";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
echo "<table class='appointments-table' width='100%'>";
echo "<tr><th>Firstname</th><th>Lastname</th><th>Date</th><th>Time</th><th>Contact</th><th>Delete</th><th>Confirm</th></tr>";
while ($row = mysql_fetch_array($result)) {
list($id, $firstname, $lastname, $month, $day, $year, $hour, $minute, $ampm, $contact) = $row;
if (($minute == 10) OR ($minute == 20) OR ($minute == 30) OR ($minute == 40) OR ($minute == 50)) {
$minute = ": " . $minute;
} elseif ($minute == 0) {
$minute = "o'clock";
}
echo "<tr><td align='center'>$firstname</td><td align='center'>$lastname</td><td align='center'>$month/$day/$year</td><td align='center'>$hour $minute $ampm</td><td align='center'>$contact</td><td align='center'><a href='delete-appointment.php?id=$id'>Delete</a></td><td align='center'><a href='sendsms.php?Contact=$contact'>Confirm</a></td></tr>";
}
echo "</table>";
} else {
echo "No Reservations";
}
?>
</div>
</fieldset>
</div>
</div>
</div>
</div><br>
<div class="footer-strip"> </div>
<div class="footer">
<div class="wrap">
<div class="footer_grides">
<div class="footer_grid1">
<h3>Information</h3>
<ul>
<li><a href="#">Privacy Policy</a></li>
<li><a href="#">Announcements</a></li>
<li><a href="#">Site Map</a></li>
</ul>
</div>
<div class="footer_grid2">
<h3>Get In Touch</h3>
<div class="address">
<ul>
<li>ADDRESS</li>
<li>3RD Flr, Central Mall Binan, Laguna</li>
<li>joennailsph@gmail.com</li>
<li><span>Telephone :</span> (049) 5760356</li>
<li><span>Mobile Number:</span>09993639765 / 09064560010 / 09157789696</li>
</ul>
</div>
</div>
<div class="footer_grid3">
<h3>Our Company</h3>
<div class="f_menu">
<ul>
<li><a href="#">About your Company</a></li>
<li><a href="#">Terms & conditions</a></li>
<li><a href="#">Our Team</a></li>
</ul>
</div>
</div>
<div class="footer_grid4">
<h3>Follow US</h3>
<div class="img_list">
<ul>
<li><img src="../images/facebook.png" alt=""><a href="#">Join Us on Facebook</a></li>
<li><img src="../images/twitter.png" alt=""><a href="#">Follow Us on Twitter</a></li>
<li><img src="../images/google-plus.png" alt=""><a href="#">Share Us on Twitter</a></li>
</ul>
</div>
</div>
<div class="clear"></div>
</div>
</div>
</div>
<div class="copy_right">
<p> © All rights Reseverd | JOEN NAILS</p>
</div>
</body>
</html>