php - 带有数据库的 DatePicker - 如果它在数据库中，则更改日期颜色

Question

我的问题如下：我得到了两个日期之间的所有日期，并在 datepicker 中更改了日期的颜色，它可以工作，但是它只检索我的表的第一行，我希望它检索我的表的所有行。有人可以帮助我还是让我走上正轨

<style>
.red span {
    background: none repeat scroll 0 0 red !important;
    color: black !important;
}

.yellow span {
    background: none repeat scroll 0 0 yellow !important;
    color: black !important;
}

.blue span {
    background: none repeat scroll 0 0 blue !important;
    color: black !important;
}

$sql = ('SELECT * FROM booking');
foreach ($pdo->query($sql) as $row) {
    $check = $row['checkin'];
    $checkout = $row['checkout'];
}

function displayDates($date1, $date2, $format = 'd-m-Y')
{
    $dates = array();
    $current = strtotime($date1);
    $date2 = strtotime($date2);
    $stepVal = '+1 day';
    while ($current <= $date2) {
        $dates[] = date($format, $current);
        $current = strtotime($stepVal, $current);
    }
    return $dates;
}
$date = displayDates($check, $checkout);
$fulldate = json_encode($date);

<script>
    $(function() {

        var unavailableDates = <?php echo $fulldate ?>;

        function unavailable(date) {

            ymd = ("0" + date.getDate()).slice(-2) + "-" + ("0" + (date.getMonth() + 1)).slice(-2) + "-" + date.getFullYear();

            if ($.inArray(ymd, unavailableDates) < 0) {
                return [true, "enabled", "Available"];
            } else {
                return [false, "red", "Booked Out"];
            }
        }

        $('#txtFromDate1').datepicker({
            beforeShowDay: unavailable,
            dateFormat: 'dd-mm-yy',
            onSelect: function(dateText) {
                $("#txtFromDate1").val(dateText);
            }
        });
    });
</script>

标签： phpjquerydatepicker