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:
logintestform.html
Code: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<!-- Created with the CoffeeCup HTML Editor 2008 -->
<!-- http://www.coffeecup.com/ <tr>
<td width="150">Start date</td>
<td><input name="start_date1" type="int" id="start_date"></td>
</tr>
<tr>
<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 -->
<head>
<title></title>
<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">
<tr>
<td width="150">Reservation Id</td>
<td><input name="resid1" type="text" id="resid"></td>
</tr>
<tr>
<td width="150"> </td>
<td><input type="submit" name="btnLogin" value="Login"></td>
</tr>
</table>
</form>
</head>
testing.php
Code: <?php
date_default_timezone_set('Asia/Kolkata');
$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";
}
}
?>
Post, not working, please help
The error is:Method Not AllowedThe requested method POST is not allowed for the URL /students/06/php/index.--------------------------------------------------------------------------------Apache/1.3.33
Applet JTextField Size Problem
Hello,I recently started making an applet to calculate certain values for airplanes. However, Gui has proved to be a problem. The JFormattedTextFields I am using have worked perfectly fine until I
Sending an SMS Message with ASP.NET
Often times it may be a requirement for your web application to send an SMS message. Such examples would be reminders, password resetting, and spam.Q: Can I have some code to send an SMS message?A:
Parse Error Help
Hello, I got the parse error "Parse error: syntax error, unexpected ',' in register.php on line 21Heres the code:Code: <body
Using system() and bringing back the results
I am aware that you can use system() within PHP to execute system commands, but I was wondering if there was a reasonable way to bring back the results every second.For example, I want a web based
Multiple if statements
Ok so seems basic but for some reason I'm not doing it right. What I want is to be able to have 2 separate if statements in the same php document. What I've done is this:Code: if ($p1=='on' AND
PHP & MS Access - Line Break
Hey Guys!I'm pulling records from an MS Access database and listing them using PHP and I'm running into an error that I can't seem to figure out.Please see the code below:Code: if
Forms Authentication and Refresh at Login page
Hello,
Install page
How do I make it so when a user submits information on the Install page, it'll right it into the correct file. I can do the forms and $_POST, but I need it so that it actually works.Current stuff in
Beginners syntax and loop questions - help please!
Hi everyone,I have some problems with php code. I'm currently in the middle of learning php, but these problems have got me stuck fast. But also have a question regarding looping that i'll ask in the