Jump to content


Photo

Date and time problem


  • Please log in to reply
No replies to this topic

#1 feichter

feichter
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 16 October 2005 - 05:45 AM

Perhaps someone can help me please. This is driving me crazy!
I have copied and adapted a script that displays a table with dates and times.
The script generates the dates 5 working days ahead and times from 7.00 till 16.00.
Every cell shows an "A".
When clicking a date, the script connects to the db and adds the date and time to the db.
I now need to show the dates and times that are in the db with a "B" for "booked".
The db has the following columns: id, deldate, deltime.

See script below:

<?php
$font_size = 1;
$how_many_business_days_ahead = 1;
$how_many_business_days_to_count = 10;
$numdel = 10; // number of deliveries per day
$deltimestart = 7; //start delivery time
$int = 1; // hourly interval between deliveries

$numdel = $numdel - 1;
$time = $deltimestart - $int;

/////////////////////////////

$server= "your_server";
$user= "user";
$password= "password";
$database= "database";
$table= "delivery";

MYSQL_CONNECT($server, $user, $password) or die ( "<H3>Server unreachable</H3>");
MYSQL_SELECT_DB($database) or die ( "<H3>Database non existent</H3>");

if ($date != "" && $time != "") { // This enters the data into the db
$req_date = $_REQUEST['date'];
$req_time = $_REQUEST['time'];

$insertion = "INSERT INTO $table VALUES ('','$req_date','$req_time')";
$result_insertion = mysql_query($insertion) or die ("Updating failed");
}

for ($c=0;$c<$how_many_business_days_to_count;$c++)
{
$jump=$c+$how_many_business_days_ahead;
$theday = strftime("%A", strtotime("+$jump"));
if($theday != "Saturday" and $theday != "Sunday")
{
$days = $how_many_business_days_ahead+$c;
$the_days[$j] = strftime("%Y-%m-%d", strtotime("+$jump days"));
$j++;
}
}
$k = $how_many_business_days_ahead;

echo "<table border=\"1\">";
echo "<tr><td></td>";

for ($a=0;$a<10;$a++){
$deltimefinish = $deltimestart;
$deltimestart = $deltimestart + $int;
echo "<td width=\"50\" align=\"center\"><font size=\"$font_size;\">$deltimefinish - $deltimestart</font></td>";
}

echo "</tr>";

foreach($the_days as $eachday){
echo "<tr><td><font size=\"$font_size\">";
echo strftime("%a, %d %b", strtotime("$eachday"));
echo "</font></td>";
$k++;

for ($i=0;$i<=$numdel;$i++){

if ($time>"15"){
$time = "7";
echo "<td align=\"center\"><font size=\"$font_size\"><a href=\"deliverydates.php?date=$eachday&time=$time\">A</a></font></td>";
} else {
$time = $time + 1;
echo "<td align=\"center\"><font size=\"$font_size\"><a href=\"deliverydates.php?date=$eachday&time=$time\">A</a></font></td>";
}
}
}
echo "</tr>";
echo "</table>";

/* Close SQL-connection */
MYSQL_CLOSE();
?>




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users