有部分文字要在指定日期显示,目前用下面的代码实现的,打开页面时服务器日期和指定日期对比,在我指定的日期内就显示内容。
现在希望php+mysql实现把内容和出现内容的日期都录到数据库里,并且到日期打开页面时就出现,请问怎么做呢?<?php
function dayMsg($dayArr, $msg='')
{
$day_now = strtotime(date('Y-m-d'));
$queryList = array();
if (is_array($dayArr))
{
for($i=0,$n=count($dayArr); $i < $n; $i++)
{
$day_start = $dayArr[$i]['day_start'];
$day_end = $dayArr[$i]['day_end'];
$queryList[] = "$day_now >= $day_start && $day_now <= $day_end";
}
$query = 'if ( ' . implode(' || ', $queryList) . ' )';
$query .= '{';
$query .= 'echo "document.write($msg)";';
$query .= '}';
eval($query);
}
}
$y = date('Y'); $day[0]['day_start'] = strtotime("$y-3-14");
$day[0]['day_end'] = strtotime("$y-3-15"); $day[1]['day_start'] = strtotime("$y-3-20");
$day[1]['day_end'] = strtotime("$y-3-22"); $day[2]['day_start'] = strtotime("$y-3-27");
$day[2]['day_end'] = strtotime("$y-3-29"); $day[3]['day_start'] = strtotime("$y-4-3");
$day[3]['day_end'] = strtotime("$y-4-5"); dayMsg($day, '"内容内容"');
?>
现在希望php+mysql实现把内容和出现内容的日期都录到数据库里,并且到日期打开页面时就出现,请问怎么做呢?<?php
function dayMsg($dayArr, $msg='')
{
$day_now = strtotime(date('Y-m-d'));
$queryList = array();
if (is_array($dayArr))
{
for($i=0,$n=count($dayArr); $i < $n; $i++)
{
$day_start = $dayArr[$i]['day_start'];
$day_end = $dayArr[$i]['day_end'];
$queryList[] = "$day_now >= $day_start && $day_now <= $day_end";
}
$query = 'if ( ' . implode(' || ', $queryList) . ' )';
$query .= '{';
$query .= 'echo "document.write($msg)";';
$query .= '}';
eval($query);
}
}
$y = date('Y'); $day[0]['day_start'] = strtotime("$y-3-14");
$day[0]['day_end'] = strtotime("$y-3-15"); $day[1]['day_start'] = strtotime("$y-3-20");
$day[1]['day_end'] = strtotime("$y-3-22"); $day[2]['day_start'] = strtotime("$y-3-27");
$day[2]['day_end'] = strtotime("$y-3-29"); $day[3]['day_start'] = strtotime("$y-4-3");
$day[3]['day_end'] = strtotime("$y-4-5"); dayMsg($day, '"内容内容"');
?>
2009-4-6 yyy
2009-4-7 zzz
数据库 table 就是 id content time1 time2插入数据库就是
insert into table set content = '$content', time1 = $time1, time2 = $time2$content 显示在时间戵为$time1 和 $time2之间在页面里攻取当前时间
$time = time();输出就是 select content from table where time1 < $time and time2 > $time///
///
如果精确到时间段的话,数据库用三个字段就可以实现了 要个 time 应该就可以实现了
你可以将数据转成xml或者规则性的文本,然后程序读取,然后再入库.
要不然别人只能动动口.
需求->设计->代码实现
这中间缺少环节.ps:这楼盖的不低.