我在日历上显示正确日期的事件时遇到问题。
这是我迄今为止的代码:
$timestamp = mktime(0,0,0,$cMonth,1,$cYear);
$maxday = date("t",$timestamp);
$thismonth = getdate ($timestamp);
$startday = $thismonth['wday'];
$queryEvent = "SELECT * FROM myweekevents WHERE date = '$timestamp' ";
$resultEvent = mysql_query($queryEvent);
$rowEvent = mysql_fetch_assoc($resultEvent);
我无法显示事件的正确日期信息。我数据库中日期的格式是Y-M-D。这就是它与时间戳不匹配的原因吗?
mktime(0,0,0,$cMonth,1,$cYear);
通过数字返回原始时间戳值。
请将您的日期格式设置为:
$rawTime = mktime(0,0,0,$cMonth,1,$cYear);
$timestamp = date( "Y-m-d", $rawTime );