php not working written for consumption of slots

Posted on 16th Feb 2014 07:03 pm by admin

1. Here is the function where i will be allowed to consume the slot booked by me.

2. Here i check the unique reservation id, current server time & date.

3. Then i ask the user to enter the Unique reservation id, and i check it against the value of reservation id stored in my database. If it matches then the server sate is measured with the Start_date of the booking and also

4. the server time is matched with the reservation start time & endtime. If the current server time falls in between these two reservation times, then only the user is allowed to move to the real thing for which he booked the slot.

This is the code for the above mentioned but it is not working:

Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<!-- Created with the CoffeeCup HTML Editor 2008 -->
<!-- <tr>

<td width="150">Start date</td>

<td><input name="start_date1" type="int" id="start_date"></td>


<td width="150">Start Time</td>

<td><input name="starttime1" type="int" id="starttime"></td>

</tr> -->
<!-- Brewed on 11/19/2009 12:46:32 PM -->
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<form name="form1" method="post" action="testing.php">

<table width="400" border="1" align="center" cellpadding="2" cellspacing="2">


<td width="150">Reservation Id</td>

<td><input name="resid1" type="text" id="resid"></td>



<td width="150"> </td>

<td><input type="submit" name="btnLogin" value="Login"></td>




Code: <?php
$dbhost = 'localhost';
$dbuser = 'XXX';
$dbpass = 'XXX';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'phpscheduleit';
mysql_select_db($dbname,$conn) or die ("could not open db".mysql_error());

$userId = $_POST["resid1"];
$sql = "SELECT 'resid', 'start_date', 'starttime', 'endtime'
FROM reservations
WHERE resid = '$userId';

$result = mysql_query($sql)
or die('Query failed. ' . mysql_error());
if (mysql_num_rows($result) == 1) {

//$query1 = "SELECT 'start_date', 'starttime', 'endtime'
//FROM reservations";
//$result1 = mysql_query($query1)
// or die('Query failed. ' . mysql_error());

$today = date("H:i:s");
$today_date = date("m-d-y");
if ($today_date == 'start_date'){
} elseif($today >= 'starttime' && $today < 'endtime') {
echo "www.localhost/e1.html{user should navigate to this page}";
} elseif($today == 'endtime') {
echo "www.localhost/index.php"
} else{
echo " today is not your booking day"
} else {
echo "Please check your reservation id";

No comments posted yet

Your Answer:

Login to answer
302 Like 41 Dislike
Previous forums Next forums
Other forums

Remove directories not empty
i have an array that contains some names (1,4,6,56...). Every integer is a name of a folder.<

Match stored value with the current value in a loop

I have a MySQL db were I store articles in.

I have a form to fill these article

Hello Everyone,

My name is Jones and i am new to this forum and to oracle. I am using ora

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

Java API in PHP?
I have an application that we use internally here at the office.

The software company provide

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS

Play Free Quiz and Win Cash