dedecms织梦模板网站中显示最近浏览文章列表的办法
dedecms织梦网站中显示最近浏览文章列表
I..后台出执行如下语句
CREATETABLE`数据库
更多精彩就在: 51免费论文网|www.jxszl.com
`.`dede_zj`(
`id`INTEGERUNSIGNEDNOTNULLAUTO_INCREMENT,
`mid`INTEGERUNSIGNEDNOTNULL,
`ip`VARCHAR(IVV)NOTNULL,
`aid`INTEGERUNSIGNEDNOTNULL,
`logintime`VARCHAR(IVV)NOTNULL,
PRIMARYKEY(`id`)
)
II.新建php文件count_zj.php存放到puls目录下内容如下
require_once(dirname(_FILE_)."/../include/common.inc.php");
require_once(dirname(_FILE_)."/../member/config.php");
global$cfg_ml;
$mid=$cfg_ml->M_ID;
$joinip=GetIP();
//当前时间戳
$nowTime=time();
if($mid)
{
$row=$dsql->GetOne("Select*From`dede_zj`whereaid=’$aid’andmid=’$mid’");
if(!$row){
$dsql->ExecuteNoneQuery("INSERTINTOdede_zj(`id`,`mid`,`ip`,`aid`,`logintime`)
VALUES(",$mid,‘$joinip’,$aid,$nowTime)");
}
$db->SetQuery("SelecttitleFromdede_archivesjoindede_zjondede_archives.id=dede_zj.aidwheredede_zj.mid=’$mid’orderbylogintimedesclimitI.,V");
$db->Execute();
while($row=$db->GetArray())
{
echo"document.write(‘".$row[title]."’);rn";
}
}
if(!$mid){
$m=$dsql->GetOne("Select*From`dede_zj`whereaid=’$aid’andip=’$joinip’");
if(!$m){
$dsql->ExecuteNoneQuery("INSERTINTOdede_zj(`id`,`mid`,`ip`,`aid`,`logintime`)
VALUES(",$mid,‘$joinip’,$aid,$nowTime)");
}
$db->SetQuery("SelecttitleFromdede_archivesjoindede_zjondede_archives.id=dede_zj.aidwheredede_zj.ip=’$joinip’orderbylogintimedesclimitI.,V");
$db->Execute();
while($row=$db->GetArray())
{
echo"document.write(‘".$row[title]."’);rn";
}
}
exit();
?>
III.在文章模板处添加如下语句
document.getElementById("zj").innerHTML=document.getElementById("span_zj").innerHTML;
document.getElementById("span_zj").innerHTML="";
在引用处直接添加
补充I.点,关于最近浏览链接的问题
require_once(dirname(_FILE_)."/../include/common.inc.php");
require_once(dirname(_FILE_)."/../member/config.php");
global$cfg_ml;
$mid=$cfg_ml->M_ID;
$joinip=GetIP();
//当前时间戳
$nowTime=time();
if($mid)
{
$row=$dsql->GetOne("Select*From`dede_zj`whereaid=’$aid’andmid=’$mid’");
if(!$row){
$dsql->ExecuteNoneQuery("INSERTINTOdede_zj(`id`,`mid`,`ip`,`aid`,`logintime`)
VALUES(",$mid,‘$joinip’,$aid,$nowTime)");
}
$db->SetQuery("Selecttitle,dede_archives.idFromdede_archivesjoindede_zjondede_archives.id=dede_zj.aidwheredede_zj.mid=’$mid’orderbylogintimedesclimitI.,V");
$db->Execute();
while($row=$db->GetArray())
{
echo"document.write("
echo"document.write(‘".$row[title]."’);";
echo"document.write("");rn";
}
}
if(!$mid){
$m=$dsql->GetOne("Select*From`dede_zjw`whereaid=’$aid’andip=’$joinip’");
if(!$m){
$dsql->ExecuteNoneQuery("INSERTINTOdede_zjw(`id`,`mid`,`ip`,`aid`,`logintime`)
VALUES(",$mid,‘$joinip’,$aid,$nowTime)");
}
$db->SetQuery("Selecttitle,dede_archives.idFromdede_archivesjoindede_zjondede_archives.id=dede_zj.aidwheredede_zjw.ip=’$joinip’orderbylogintimedesclimitI.,V");
$db->Execute();
while($row=$db->GetArray())
{
echo"document.write("
echo"document.write(‘".$row[title]."’);";
echo"document.write("");rn";
}
}
exit();
?>
覆盖上面的php文件
原文链接:http://www.jxszl.com/biancheng/dedecms/74015.html
最新推荐
热门阅读