将事件日历的时间戳与当前日期匹配


Match Timestamp With Current Date For An Event Calendar

我在日历上显示正确日期的事件时遇到问题。

这是我迄今为止的代码:

$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 );