文章简洁的分享一款php中博客日历实现代码,有需要的朋友参考一下,里面有一句是查询数据库的这个很简单,只要你修改一下字段名与你数据库相同就行了。
代码如下 | 复制代码 |
function calendarnew($starttime = 0) { global $db, $tablepre, $timestamp, $site_timeoffset, $site_dateformat, $curtime;
$starttime = $starttime ? $starttime : $timestamp; $curtime = gmdate($site_dateformat, $starttime + $timeoffset * 3600);
$pendtime = $starttime - (gmdate('j', $starttime + $timeoffset * 3600) - 1) * 86400 - ($starttime + $timeoffset * 3600) % 86400; $pstarttime = $pendtime - gmdate('t', $pendtime + $timeoffset * 3600 - 1) * 86400;
$nstarttime = $pendtime + gmdate('t', $pendtime + $timeoffset * 3600 + 1) * 86400; $nendtime = $nstarttime + gmdate('t', $nstarttime + $timeoffset * 3600 + 1) * 86400;
list($skip, $dim) = explode('-', gmdate('w-t', $pendtime + $timeoffset * 3600 + 1)); $rows = ceil(($skip + $dim) / 7);
$blogs = array(); $query = $db->query("SELECT dateline FROM {$tablepre}vitaitems WHERE dateline BETWEEN '$pendtime' AND '$nstarttime'"); while($blog = $db->fetch_array($query)) { $day = gmdate('j', $blog['dateline'] + $timeoffset * 3600); !isset($blogs[$day]) ? $blogs[$day] = array('num' => 1, 'dateline' => $blog['dateline'] - $blog['dateline'] % 86400) : $blogs[$day]['num']++; } $cal = ''; for($row = 0; $row $cal .= ' |
|
'.$curtd.' | ';'.$cur.' | ';