上次我有提过一个意见,
就是日历那里
<?php
$query = $DB->query("SELECT date FROM {$db_prefix}blog WHERE hide='n' ");
while($date = $DB->fetch_array($query))
{
$logdate[] = date("Ymd",$date['date']);
}
?>
假想如果写了N多篇日志,这里查出来的数组有多大?
我觉得取出单月的天数就行了
先获得当月的年月,再取出单月
<?php
//获取当前日期
$n_year=date("Y",$localdate);
$n_year2=date("Y",$localdate);
$n_month=date("m",$localdate);
$n_day=date("d",$localdate);
$time=date("Ymd",$localdate);
$year_month=date("Ym",$localdate);
if(isset($_GET['date']))
{
$n_year=substr(intval($_GET['date']),0,4);
$n_year2=substr(intval($_GET['date']),0,4);
$n_month=substr(intval($_GET['date']),-2);
$year_month=intval($_GET['date']);
}
$query = $DB->query("SELECT date_format(date,'%Y%m%d') as pdate FROM {$db_prefix}blog WHERE hide='n' AND DATE_FORMAT(`Date`,'%Y%m') = '$year_month' GROUP BY pdate");
//...
?>