帝国cms 无刷新 滚动Ajax加载更多和点击Ajax加载更多

方法/步骤

新建一个空白的php，然后将以下代码粘贴到网页中，并保存为getmore.php;mrGECMSPLUS
<?phpmrGECMSPLUS
require('../class/connect.php');mrGECMSPLUS
require('../class/db_sql.php');mrGECMSPLUS
require('../data/dbcache/class.php');mrGECMSPLUS
if($_POST[action] == 'getmorenews'){mrGECMSPLUS
$table=htmlspecialchars($_POST[table]);mrGECMSPLUS
if(empty($_POST[orderby])){$orderby='newstime';}else{ $orderby=htmlspecialchars($_POST[orderby]);}mrGECMSPLUS
if(empty($_POST[myorder])){$myorder='desc';}else{ $myorder='asc';}mrGECMSPLUS
if(empty($_POST[limit])){$limit=3;}else{ $limit=(int)$_POST[limit];}mrGECMSPLUS
if(empty($_POST[classid])){$where=null;}else{ $where='where classid in('.$_POST[classid].')';}mrGECMSPLUS
if(empty($_POST[length])){$length=50;}else{ $length=(int)$_POST[length];}mrGECMSPLUS
if(empty($_POST[small_length])){$small_length=120;}else{ $small_length=(int)$_POST[small_length];}mrGECMSPLUS
mrGECMSPLUS
$link=db_connect();mrGECMSPLUS
$empire=new mysqlquery();mrGECMSPLUS
$num =(int)$_POST['next'] *$limit;mrGECMSPLUS
mrGECMSPLUS
if($table){mrGECMSPLUS
$sql=$empire->query("SELECT * FROM `".$dbtbpre."ecms_".$table."` $where order by $orderby $myorder limit $num,$limit");mrGECMSPLUS
mrGECMSPLUS
while($r=$empire->fetch($sql)){mrGECMSPLUS
mrGECMSPLUS
if($r[titlepic]==''){mrGECMSPLUS
$r[titlepic]=$public_r[news.url]."e/data/images/notimg.gif";mrGECMSPLUS
}mrGECMSPLUS
$oldtitle=stripSlashes($r[title]);mrGECMSPLUS
$title=sub($oldtitle,'',$length);mrGECMSPLUS
$smalltext=stripSlashes($r[smalltext]);mrGECMSPLUS
$smalltext=sub($smalltext,'',$small_length);mrGECMSPLUS
$classname=$class_r[$r[classid]][classname];mrGECMSPLUS
$newsurl=$public_r[newsurl];mrGECMSPLUS
$classurl=$newsurl.$class_r[$r[classid]][classpath];mrGECMSPLUS
mrGECMSPLUS
?>mrGECMSPLUS
mrGECMSPLUS
<div class="case-img"> <a href="<?=$r[titleurl]?>" target="_blank"> <img src="<?=$r[titlepic]?>"  alt="<?=$r[title]?>" class="case-photo">mrGECMSPLUS
  <div class="case-text">mrGECMSPLUS
    <h1><?=$r[title]?></h1>mrGECMSPLUS
    <h6><?=$r[ftitle]?></h6>mrGECMSPLUS
  </div>mrGECMSPLUS
  </a> </div>mrGECMSPLUS
 mrGECMSPLUS
mrGECMSPLUS
mrGECMSPLUS
<?phpmrGECMSPLUS
}mrGECMSPLUS
}mrGECMSPLUS
}mrGECMSPLUS
db_close();mrGECMSPLUS
$empire=null;mrGECMSPLUS
?>mrGECMSPLUS
mrGECMSPLUS
将getmore.php文件上传到e/action文件夹下；

在帝国cms列表模板里，放上以下的代码用于循环显示列表文章； id="showajaxnews"

    <div class="case-img-box" id="showajaxnews">mrGECMSPLUS
     [!--empirenews.listtemp--]mrGECMSPLUS
     <!--list.var1-->mrGECMSPLUS
      [!--empirenews.listtemp--]mrGECMSPLUS
    </div>mrGECMSPLUS
mrGECMSPLUS
 <a class="more case-m lazy am94"  id="loadmore" href="javascript:void(0);">查看更多 ></a>

在帝国cms列表模板最底部，放上以下的JS代码，实现点击加载数据；

<script language="javascript" type="text/javascript">mrGECMSPLUS
 $(function(){    mrGECMSPLUS
 mrGECMSPLUS
     var i = 1; //设置当前页数mrGECMSPLUS
      mrGECMSPLUS
    $('#loadmore').click(function(){mrGECMSPLUS
 mrGECMSPLUS
        $.ajax({mrGECMSPLUS
        url : '/e/action/getmore.php',mrGECMSPLUS
                type:'POST',mrGECMSPLUS
                data:{"next":i,'table':'case','action':'getmorenews','limit':8,'small_length':120},mrGECMSPLUS
            dataType : 'html',mrGECMSPLUS
        beforeSend:function(){mrGECMSPLUS
                $("#loadmore").show().html('<img  src="/e/extend/Ajaxpl/template/loading1.gif" width=80/>正在努力加载中...');mrGECMSPLUS
           $('#loadmore').attr('disabled','disabled');mrGECMSPLUS
        },mrGECMSPLUS
            success : function(data){mrGECMSPLUS
           if(data){mrGECMSPLUS
               $("#showajaxnews").append(data);mrGECMSPLUS
                          $("#loadmore").removeAttr('disabled');mrGECMSPLUS
              $("#loadmore").html('点击加载更多');mrGECMSPLUS
                 i++;mrGECMSPLUS
            }else{mrGECMSPLUS
                $("#loadmore").show().html("已全部加载完毕！");mrGECMSPLUS
                        $('#loadmore').attr('disabled','disabled');mrGECMSPLUS
                return false;mrGECMSPLUS
            }      mrGECMSPLUS
           }mrGECMSPLUS
        });mrGECMSPLUS
    });mrGECMSPLUS
});mrGECMSPLUS
</script> mrGECMSPLUS
 

<?php
require('../class/connect.php');
require('../class/db_sql.php');
require('../data/dbcache/class.php');
if($_POST[action] == 'getmorenews'){
$table=htmlspecialchars($_POST[table]);
if(empty($_POST[orderby])){$orderby='newstime';}else{ $orderby=htmlspecialchars($_POST[orderby]);}
if(empty($_POST[myorder])){$myorder='desc';}else{ $myorder='asc';}
if(empty($_POST[limit])){$limit=3;}else{ $limit=(int)$_POST[limit];}
if(empty($_POST[classid])){$where=null;}else{ $where='where classid in('.$_POST[classid].')';}
if(empty($_POST[length])){$length=50;}else{ $length=(int)$_POST[length];}
if(empty($_POST[small_length])){$small_length=120;}else{ $small_length=(int)$_POST[small_length];}

$link=db_connect();
$empire=new mysqlquery();
$num =(int)$_POST['next'] *$limit;

if($table){
$sql=$empire->query("SELECT * FROM `".$dbtbpre."ecms_".$table."` $where order by $orderby $myorder limit $num,$limit");

while($r=$empire->fetch($sql)){

if($r[titlepic]==''){
$r[titlepic]=$public_r[news.url]."e/data/images/notimg.gif";
}
$oldtitle=stripSlashes($r[title]);
$title=sub($oldtitle,'',$length);
$smalltext=stripSlashes($r[smalltext]);
$smalltext=sub($smalltext,'',$small_length);
$classname=$class_r[$r[classid]][classname];
$newsurl=$public_r[newsurl];
$classurl=$newsurl.$class_r[$r[classid]][classpath];

?>

<div class="case-img"> <a href="&lt;?=$r[titleurl]?>" target="_blank"> <img src="&lt;?=$r[titlepic]?>"  alt="&lt;?=$r[title]?>" class="case-photo">
  <div class="case-text">
    <h1>&lt;?=$r[title]?></h1>
    <h6>&lt;?=$r[ftitle]?></h6>
  </div>
  </a> </div>
  


&lt;?php
}
}
}
db_close();
$empire=null;
?>