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

CMS教程 2025-05-12 0

帝国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>
<div id=indexl>
<?php
echo $rili;//这里输入的是日历，放到你想要的位置
?>
</div>
<div id=indexr>
<div class=top>
Name </div>
<div class=bot>
<?=$r=$empire->fetch1($query);
?>
</div></div>
<div class=clear></div>
</div>
</div>
</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]?>

声明：本站所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。

相关文章