dedecms如何调用出访客最近浏览过的文章

织梦教程 强烈建议 2024-02-26 11:28 110 0

  以下是本人针对上面问题的一个拙劣的笨方法:不对的地方请高手赐教

  后台出执行如下语句

  CREATE TABLE `数据库`.`dede_zj` (

  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

  `mid` INTEGER UNSIGNED NOT NULL,

  `ip` VARCHAR(45) NOT NULL,

  `aid` INTEGER UNSIGNED NOT NULL,

  `logintime` VARCHAR(45) NOT NULL,

  PRIMARY KEY (`id`)

  )

  新建php文件count_zj.php 存放到puls目录下内容如下

  

  require_once(dirname(__FILE__)."/https://www.风格酷模板网.com/a/include/common.inc.php");

  require_once(dirname(__FILE__)."/https://www.风格酷模板网.com/a/member/config.php");

  global $cfg_ml;

  $mid=$cfg_ml->M_ID;

  $joinip = GetIP();

  //当前时间戳

  $nowTime = time();

  if($mid)

  {

  $row = $dsql->GetOne(" Select * From `dede_zj` where aid='$aid' and mid='$mid'");

  if(!$row){

  $dsql->ExecuteNoneQuery("INSERT INTO dede_zj( `id`, `mid`, `ip`,`aid` ,`logintime`)

  VALUES ( '',$mid, '$joinip',$aid,$nowTime) ");

  }

  $db->SetQuery(" Select title,dede_archives.id From dede_archives join dede_zj on dede_archives.id=dede_zj.aid where dede_zj.mid='$mid' order by logintime desc limit 1,5");

  $db->Execute();

  while($row = $db->GetArray())

  {

  echo "document.write("");";

  echo "document.write('".$row['title']."');";

  echo "document.write("");

  ";

  }

  }

  if(!$mid){

  $m = $dsql->GetOne(" Select * From `dede_zjw` where aid='$aid' and ip='$joinip'");

  if(!$m){

  $dsql->ExecuteNoneQuery("INSERT INTO dede_zjw( `id`, `mid`, `ip`,`aid` ,`logintime`)

  VALUES ( '',$mid, '$joinip',$aid,$nowTime) ");

  }

  $db->SetQuery(" Select title,dede_archives.id From dede_archives join dede_zj on dede_archives.id=dede_zj.aid where dede_zjw.ip='$joinip' order by logintime desc limit 1,5");

  $db->Execute();

  while($row = $db->GetArray())

  {

  echo "document.write("");";

  echo "document.write('".$row['title']."');";

  echo "document.write("");

  ";

  }

  }

  exit();

  ?>

  在文章模板处添加如下语句

  

  

  

本站资源均来自互联网或会员发布,如果不小心侵犯了您的权益请与我们联系。我们将立即删除!谢谢!