[RESOLVED] Date Question

[obrienkev]

Morning all,

I have a registeration system set up. The user registers the time a class starts and the time a class ends.
These times are stored in mysql db with time type.

How do I prevent double booking in this situation?
e.g. If the class starts at 9:00 and ends at 10:30, how do I ensure that no class takes place between those times?

Thanks.

Kevin.

[Weedpacket]

Depends entirely on your implementation. But if both bookings start before either ends, then they're overlapping.

[obrienkev]

Hi all,

Here's what I've been working on. It seems to work but the $time_start < $class_end part doesn't work - If time_start is equal to $class_end then the echo should not occur but currently it does.
How do I solve this?
Thanks.

$query = "SELECT location_ID, class_date, time_start, time_end ".
                 "FROM class ".
                 "WHERE location_ID = '$location' ".
              "AND class_date = '$meeting_date'";             

$result = mysql_query($query) or die(mysql_error());
$num_results = mysql_num_rows($result);
if ($num_results >0)
{
while($row = mysql_fetch_array($result))
{
     $class_start = $row['time_start'];
     $class_end = $row['time_end'];
     echo 'CLASS TIME: '.$class_start.':::'.$class_end.'<br /><br />';

 if(($time_start >= $class_start) && ($time_start < $class_end))
 {
 echo 'a.Time Taken<br />';
 }
 if(($time_end > $class_start) && ($time_end <= $class_end))
 {
    echo 'Time Taken';
 }
}
     echo '<br />Booked Out';
     exit;
} // end if($num_results)

[obrienkev]

Sorry to bump this but can anyone help me out?

The time values are in mysql db as time type. Here's my code...

/***********************
declare variables
***********************/
$course = $_POST['course'];
$location = $_POST['location'];
$booked_by = $_POST['booked_by'];
$note = $_POST['note'];
$date1 = $_POST['date1xx'];
// time start
$hr_start = $_POST['hour'];
$min_start = $_POST['minute'];
// time end
$hr_end = $_POST['hr_end'];
$min_end = $_POST['min_end'];


// connect to db
include('../db_connect.php');

// process date
list($day, $month, $year) = split('[/.-]', $date1);
echo "Day: $day; Month: $month; Year: $year<br />\n";
$meeting_date = $year.'-'.$month.'-'.$day;
echo $meeting_date;

echo '<br /><br />';

// process time
$time_start = $hr_start.':'.$min_start;
echo $time_start.'<br />';
$time_end = $hr_end.':'.$min_end;
echo $time_end.'<br />';

/************************
Check against Classes
************************/
$query = "SELECT location_ID, class_date, time_start, time_end ".
                 "FROM class ".
                 "WHERE location_ID = '$location' ".
                 "AND class_date = '$meeting_date'";
echo '<br /><br />'.$query.'<br /><br />';             

$result = mysql_query($query) or die(mysql_error());
$num_results = mysql_num_rows($result);
echo 'Num_Results: '.$num_results.'<br /><br />';
if ($num_results >0)
{
     // check class times
     while($row = mysql_fetch_array($result))
     {
             $class_start = $row['time_start'];
            $class_end = $row['time_end'];
            echo 'CLASS TIME: '.$class_start.':::'.$class_end.'<br /><br />';

     if(($time_start >= $class_start) && ($time_start < $class_end))
        {
              echo 'a.Time Taken<br />';
        }
        if(($time_end > $class_start) && ($time_end <= $class_end))
        {
                 echo 'Time Taken';
        }
 }
 echo '<br />Booked Out';
 exit;
} // end if($num_results)

[/code]

[rincewind456]

Are you sure that the data that you are compring has the values that you think?
Running the area of the script that you say causes problems against known values doesn't produce any unexpected results.

[obrienkev]

Seems to be working now ...I added the :00 to compare with db entry.
Will keep you posted. Cheers guys.

// process time
$time_start = $hr_start.':'.$min_start.':00';
echo $time_start.'<br />';
$time_end = $hr_end.':'.$min_end.':00';
echo $time_end.'<br />';