帝國CMS按照日期調(diào)用當日更新信息教程

?0){
????????$where?=?"?and?typeid=$tid";
}
$query?("select?title?from?phome_ecms_article?where?newstime?>$starttime?and?newstime?<$endtime?$where");
$sql=$empire->query($query);
$sql=$empire->execute();
$list?=?array();
while($row?=?$db->getarray())
{
????????$row['pubdate']?=?date('H點i分',$row['pubdate']);
????????$list[]?=?$row;
}
function?rili($date,?$file?=?'',?$nomax?=?false)
{
????????$curtime?=?time();
????????//獲得時間戳
????????if(empty($date)){
????????????????$timestamp?=?$curtime;
????????}else{
????????????????$timestamp?=?strtotime($date);
????????}
???????
????????$selectedyear?=?date('Y',$timestamp);
????????$selectedmonth?=?date('n',$timestamp);
????????$selectedday?=?date('d',$timestamp);
????????//給定月份第一天星期幾
????????$firstday?=?date('w',mktime(0,0,0,$selectedmonth,1,$selectedyear));
????????////給定月份所應(yīng)有的天數(shù)
????????$lastday?=?date('t',$timestamp);//給定月份所應(yīng)有的天數(shù)
???????
????????$preyear?=?date('Y',mktime(0,0,0,$selectedmonth,0,$selectedyear));
????????$nextyear?=?date('Y',mktime(0,0,0,$selectedmonth,$lastday+1,$selectedyear));
????????$premonth?=?date('n',mktime(0,0,0,$selectedmonth,0,$selectedyear));
????????$nextmonth?=?date('n',mktime(0,0,0,$selectedmonth,$lastday+1,$selectedyear));
????????$premonthdays?=?date('t',mktime(0,0,0,$selectedmonth,0,$selectedyear));
????????$nextmonthdays?=?date('t',mktime(0,0,0,$selectedmonth,$lastday+1,$selectedyear));
????????$preday?=?min($selectedday,$premonthdays);
????????$nextday?=?min($selectedday,$nextmonthdays);
???????
???????
????????//顯示日歷頭
????????$days?=?array("日","一","二","三","四","五","六");
????????$months?=?array("一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月");
????????$monthName?=?$months[$selectedmonth-1];
???????
????????$str?=?"";
????????$str?.=?"<<??$selectedyear??$monthName?";
????????if($nomax?&&?mktime(0,0,0,$nextmonth,1,$nextyear)?>?$curtime){
????????????????$str?.=?">>";
????????}else{
????????????????$str?.=?">>";
????????}
????????$str?.=?"";
????????for($i=0;$i<7;$i++){
????????$str?.=?"$days[$i]";
????????}
????????$str?.=?"";
????????//空出當月第一天的位置
????????$i?=?0;
????????while($i?";
????????????????$i++;
????????}
????????$day?=?0;
????????while($day?";
????????????????}
????????????????$day++;
????????????????$i++;
????????????????//當天用紅色表示
????????????????if($day?==?$selectedday){
????????????????????????$str?.=?"$day";
????????????????}else?{
????????????????????????if($nomax?&&?mktime(0,0,0,$selectedmonth,$day,$selectedyear)?>?$curtime){
????????????????????????????????$str?.=?"$day";
????????????????????????}else{
????????????????????????????????$str?.=?"$day";
????????????????????????}
????????????????}
???????????????
????????}
????????$str?.=?"";
????????return?$str;
}
?>

BODY?{
????????PADDING-RIGHT:?0px;?PADDING-LEFT:?0px;?FONT-SIZE:?14px;?PADDING-BOTTOM:?0px;?MARGIN:?5px?10px;?PADDING-TOP:?0px
}
#header?{
????????PADDING-LEFT:?5px
}
IMG?{
????????BORDER-TOP-WIDTH:?0px;?BORDER-LEFT-WIDTH:?0px;?BORDER-BOTTOM-WIDTH:?0px;?BORDER-RIGHT-WIDTH:?0px
}
.STYLE1?{font-size:?small}
.left?{
????????FLOAT:?left
}
.t?{
?????PADDING-top:?5px
}
.right?{
????????FLOAT:?right
}
.calendarHeader?{
????????FONT-WEIGHT:?bolder;?COLOR:?#c00;?BACKGROUND-COLOR:?#ffc
}
.calendarToday?{
????????COLOR:?#fff;?BACKGROUND-COLOR:?#f00
}
.calendarToday?A:link?{
????????COLOR:?#fff
}
.calendarToday?A:visited?{
????????COLOR:?#fff
}
.calendarToday?A:hover?{
????????COLOR:?#fff
}
.calendar?{
????????COLOR:?#333;?BACKGROUND-COLOR:?#ffc
}
A.hot:link?{
????????COLOR:?#f00
}
A.hot:visited?{
????????COLOR:?#f00
}
A:link?{
????????COLOR:?#009
}
A:visited?{
????????COLOR:?#009
}
A:hover?{
????????COLOR:?#c00
}
.clear?{
????????CLEAR:?both;?FONT-SIZE:?0px;?VISIBILITY:?hidden;?LINE-HEIGHT:?0px;?HEIGHT:?0px
}
#menu?{
????????PADDING-LEFT:?10px;?BACKGROUND:?#efefef;?LINE-HEIGHT:?26px;?BORDER-BOTTOM:?#009?1px?solid
}
#menu?A?{
????????TEXT-DECORATION:?none
}
#server?A?{
????????TEXT-DECORATION:?none
}
#indexl?{
????????PADDING-RIGHT:?10px;?PADDING-LEFT:?10px;?FLOAT:?left;?PADDING-BOTTOM:?10px;?PADDING-TOP:?10px
}
.yester?{
????????MARGIN-TOP:?6px;?LINE-HEIGHT:?22px;?TEXT-ALIGN:?center
}
#indexr?{
????????PADDING-RIGHT:?0px;?PADDING-LEFT:?0px;?FLOAT:?left;?PADDING-BOTTOM:?0px;?BORDER-LEFT:?#009?1px?solid;?LINE-HEIGHT:?22px;?PADDING-TOP:?0px
}
#indexr?SPAN?{
????????FONT-SIZE:?12px;?COLOR:?#333
}
#indexr?A:link?{
????????TEXT-DECORATION:?none
}
#indexr?A:visited?{
????????TEXT-DECORATION:?none
}
#indexr?A:hover?{
????????TEXT-DECORATION:?underline
}
#indexr?.top?{
????????PADDING-LEFT:?20px;?FONT-WEIGHT:?bold;?BACKGROUND:?#F0F9EE;?COLOR:?#333;?LINE-HEIGHT:?26px;?BORDER-BOTTOM:?#ccc?1px?solid
}
#indexr?.bot?{
????????PADDING-RIGHT:?10px;?PADDING-LEFT:?10px;?PADDING-BOTTOM:?10px;?PADDING-TOP:?10px;?HEIGHT:?100%;?LINE-HEIGHT:?3px
}
#server?{
????????BORDER-TOP:?#009?1px?solid;?FONT-SIZE:?12px;?BACKGROUND:?#efefef;?LINE-HEIGHT:?26px;?TEXT-ALIGN:?center
}
#copy?{
????????FONT-SIZE:?12px;?LINE-HEIGHT:?26px;?TEXT-ALIGN:?center
}









Name?


fetch1($query);
?>

將第一部分

$query?("select?title?from?phome_ecms_article?where?newstime?>$starttime?and?newstime?<$endtime?$where");
$sql=$empire->query($query);
$sql=$empire->execute();
$list?=?array();
while($row?=?$db->getarray())
{
????????$row['pubdate']?=?date('H點i分',$row['pubdate']);
????????$list[]?=?$row;
}

換成：

$r=$empire->fetch1("select?title?from?phome_ecms_article?where?newstime?like?'%".date("Y-m-d")."%'?limit?1");

第二個

fetch1($query);
?>

換成