PHP/Mysql组合框值，不是Mysql中的whats，而是whats Not(Time Slots）

考虑从所有可能的时隙列表开始，无论是否可用。现在使用上面的内容读取所有占用的插槽，然后从完整列表中删除。

我使用了这样的东西：

<?php
function mysql_fetch_rowsarr($result, $numass=MYSQL_BOTH) {
$i=0;
$keys=array_keys(mysql_fetch_array($result, $numass));
mysql_data_seek($result, 0);
while ($row = mysql_fetch_array($result, $numass)) {
  foreach ($keys as $speckey) {
    $got[$i][$speckey]=$row[$speckey];
  }
$i++;
}
 return $got;
}
function convertDate($date){
$date_year=substr($date,1,4);
$date_month=substr($date,6,7);
$date_day=substr($date,8,10);
$date=date("Y-m-d", mktime(0,0,0,$date_month,$date_day,$date_year));
return $date; 
};
$is_ajax = $_REQUEST['is_ajax'];
if (!isset($_POST['date'])) {
echo "<option value='0' selected>Select Date...</option>";
}else{
include 'config.php';
$conn = mysql_connect($host,$user,$pass);
if (!$conn) {
    die('Could not connect: ' . mysql_error());
};
//Get rodays date
date_default_timezone_set('Europe/London');
$date = $_POST['date'];
$check_date = convertDate($date);
$today = date("Y-m-d");
$the_hour = date("H");      
mysql_select_db($db, $conn);
mysql_set_charset('utf8',$conn);
$booking_check = mysql_query("SELECT * FROM Booking WHERE Booking_Start LIKE '%$check_date%'");
//if no bookings just echo the entire form but if there is do the else
if (mysql_num_rows($booking_check) == 0) {
    //counter set to 23 because of 0
    $counter = 23;
    $i = 0;
    if($check_date == $today && $the_hour == 23){
        echo "<option value='0' selected>No Slots. Sorry.</option>";
    }else{
        while($i<=$counter) {
            if($check_date == $today){
                if ($i > $the_hour){
                    if ($i < 10){
                        echo '<option value="0'.$i.':00">0'.$i.':00 - 0'.$i.':55</option>';
                        $i++;
                    }else{
                        echo '<option value="'.$i.':00">'.$i.':00 - '.$i.':55</option>';
                        $i++;
                    };
                }else{
                    $i++;
                };
            }else{
                if ($i < 10){
                    echo '<option value="0'.$i.':00">0'.$i.':00 - 0'.$i.':55</option>';
                    $i++;
                }else{
                    echo '<option value="'.$i.':00">'.$i.':00 - '.$i.':55</option>';
                    $i++;
                };
            };
        };
    };
} else {
    //counter set to 23 because of 0
    $counter = 23;
    $i = 0;
    $avalible_slots = 23;
    $booked_times = mysql_fetch_rowsarr($booking_check);
    $num_booked = mysql_num_rows($booking_check);
    $H = 0;
    if($check_date == $today && $the_hour == 23){
        echo "<option value='0' selected>No Slots. Sorry.</option>";
    }else{
        while($i<=$counter) {
            //$H is used to compare if the hour slot is booked this adds a 0 to the front of the varible if under 10 for the 24H time format.
            if ($i < 10){
                $H = "0".$i;
            } else {
                $H = $i;
            };
            //Loop through the times that are booked and see if it is the same as the $H which is the current count of the loop so it should set skip to 1 if the time is booked.
            $x = 0;
            while($x < $num_booked){
                if(date("H", strtotime($booked_times[$x]['Booking_Start'])) == $H){
                    $skip = 1;
                    break;
                }else{
                    $skip = 0;
                    $x++;
                };
            };
            if($check_date == $today){
                if($skip != 1 && $i > $the_hour){
                    if ($i < 10){
                        echo '<option value="0'.$i.':00">0'.$i.':00 - 0'.$i.':55</option>';
                        $i++;
                    }else{
                        echo '<option value="'.$i.':00">'.$i.':00 - '.$i.':55</option>';
                        $i++;
                    };
                }else{
                    $i++;
                    $avalible_slots--;
                };
            }else{
                if($skip != 1){
                    if ($i < 10){
                        echo '<option value="0'.$i.':00">0'.$i.':00 - 0'.$i.':55</option>';
                        $i++;
                    }else{
                        echo '<option value="'.$i.':00">'.$i.':00 - '.$i.':55</option>';
                        $i++;
                    };
                }else{
                    $i++;
                    $avalible_slots--;
                };
            };
        };
        echo $avalible_slots;
        echo $num_booked;
    };
};
};
?>