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:
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";
}
}
?>
No comments posted yet
Your Answer:
Login to answer
302 
41 
Other forums
Error with Font and imagettfbbox
I keep getting an error that says "Warning: imagettfbbox() [function.imagettfbbox]: Could not f
Floating Point Precision Loss
I'm writing a program to draw a three-dimensional cube (with a corner cut off) without using any 3D
Is there a function ... auto send IP
Is there some function that can be sent to a ddns service that returns the ip address of a ddns forw
adding up might be solved tell us cheers.
i think i finally solved this anybody.
last time i was getting the wrong results.
Code
Windows 7
Windows 7 default user account control worries experts. Corporate IT departments should be pleased w
curl javascript problem
Hi Experts.
I'm new curl and wanna to get some info from this http://www.amadeus.net/
when
PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi
having a small php error tha deals with the 'foreach'
Last night i was working on a script for a cart and it seemed to working good, until this morning. F
Warning: Cannot modify header information - headers already sent by (output sta
Warning: Cannot modify header information - headers already sent by (output started at /home/praylif
I am stumped
OK. Here is what I am trying to do. I have the conditions set, and if the conditions are met, I want
