帝国CMS按照日期调用当日更新信息教程

时间： 2020-09-16 10:47 阅读：次作者：素材无忧网

帝国CMS按照日期调用当日更新信息教程

<?php
require("../class/connect.php");
include("../class/config.php");
include("../class/q_functions.php");
include("../class/db_sql.php");
include("../class/class.php");
$link=db_connect();
$empire=new mysqlquery();
//参数设置
$rili = rili($date,'',true);
$curtime = time();
//获得时间戳
if(empty($date)){
        $timestamp = $curtime;
}else{
        $timestamp = strtotime($date);
}
        $selectedyear = date('Y',$timestamp);
        $selectedmonth = date('n',$timestamp);
        $selectedday = date('d',$timestamp);
       
        $starttime = mktime(0,0,0,$selectedmonth,$selectedday,$selectedyear);
        $endtime = $starttime+86400;
$where = '';
$tid = intval($tid);
if($tid > 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));
        ////给定月份所应有的天数
        $lastday = date('t',$timestamp);//给定月份所应有的天数
       
        $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 = "<table bgcolor=\"#F0F9EE\">";
        $str .= "<caption valign=\"center\"><a href=\"$file?date=$preyear-$premonth-$preday\"><<</a> <b> $selectedyear  $monthName</b> ";
        if($nomax && mktime(0,0,0,$nextmonth,1,$nextyear) > $curtime){
                $str .= ">></caption>";
        }else{
                $str .= "<a href=\"$file?date=$nextyear-$nextmonth-$nextday\">>></a></caption>";
        }
        $str .= "<tr>";
        for($i=0;$i<7;$i++){
        $str .= "<td width=10%>$days[$i]</td>";
        }
        $str .= "</tr>";
        //空出当月第一天的位置
        $i = 0;
        while($i < $firstday){
                $str .= "<td></td>";
                $i++;
        }
        $day = 0;
        while($day < $lastday){
                if(($i % 7) == 0){
                        $str .= "</tr><tr>";
                }
                $day++;
                $i++;
                //当天用红色表示
                if($day == $selectedday){
                        $str .= "<td class=calendarToday align=center><font color=#ffffff>$day</font></td>";
                }else {
                        if($nomax && mktime(0,0,0,$selectedmonth,$day,$selectedyear) > $curtime){
                                $str .= "<td>$day</td>";
                        }else{
                                $str .= "<td><a href=\"$file?date=$selectedyear-$selectedmonth-$day\">$day</a></td>";
                        }
                }
               
        }
        $str .= "</tr></table>";
        return $str;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Title</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<STYLE type=text/css>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
}
</STYLE>
</HEAD>
<BODY>
<p id=indexl>
<?php
echo $rili;//这里输入的是日历，放到你想要的位置
?>
</p>
<p id=indexr>
<p class=top>
Name </p>
<p class=bot>
<?=$r=$empire->fetch1($query);
?>
</p></p>
<p class=clear></p>
</p>
</p>
</body>
</html>

将第一部分

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

第二个

<?=$r=$empire->fetch1($query);
?>

换成

<?=$r[title]?>

转载请注明：帝国CMS按照日期调用当日更新信息教程

上一篇：帝国CMS搜索表单制作教程

下一篇：帝国cms新手教程 7.2升级至7.5

标签：