我正在使用Keith Wood的日历日期拾取器,并且我想根据以下php查询在日期拾取器单元格内显示价格,在每个单元格中显示不同的价格。我该怎么做呢?
$('#popupDatepicker').calendarsPicker({
onDate: function(date) {
return {content: date.day() + '<br><sub>' +
<?php
$PropertyNumber=53;
$Date= 'date.toString()';
$res2 = $dbh->prepare("select * from property_price where PropertyNumber=:PropertyNumber and Date=:Date ");
$res2->execute(array(':PropertyNumber'=>$PropertyNumber,':Date'=>$Date));
$row = $res2->fetch(PDO::FETCH_ASSOC);
if ($res2 ) {
echo $row['Price'] ;
}
?>
+ '</sub>',
};
}
});
所以我可以解决这个问题现在我想显示当用户在保留日期上选择范围日期和在鼠标上选择使用日期时的错误,就像这个日期选择器
<?php
$PropertyNumber=53;
$res2 = $dbh->prepare("select * from property_price where PropertyNumber=:PropertyNumber ");
$res2->execute(array(':PropertyNumber'=>$PropertyNumber));
while ( $row = $res2->fetch(PDO::FETCH_ASSOC)) {
$myVarValue[]=$row;
};
echo json_encode($myVarValue);
?>
<script>
var pausecontent = <?php echo json_encode($myVarValue); ?>;
$(function() {
var g=<?php echo json_encode($myVarValue); ?>;
$('#popupDatepicker').calendarsPicker({ rangeSelect:true,minDate:0,changeMonth:false,
onDate: function(date) {
for (var i = pausecontent.length - 1; i >= 0; i--) {
if (date.toString()==pausecontent[i].Date ) {
return {content: date.day() + '<br><sub>' +
pausecontent[i].Price + '$</sub>',
dateClass: 'showDoY' ,
};
}}
return {content: date.day() + '<br><sub>' +
0 + '$</sub>',
dateClass: 'showDoY'};
},
});
});
</script>