帝国CMS二次开发无刷新Ajax加载更多列表信息插件- 帝国技术 -卓越飞翔博客

本帝国cms插件利用AJAX实现并无刷新读取更多的列表信息，用查看更多按钮来替代翻页功能，无限读取。

服务端源码：（保存路径为/e/action/get_news_index.php）

<?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=15;}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=500;}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];
?>


" target="_blank">" width=160 height=100 />

$(function(){ var i = 1; //设置当前页数 $('#loadmore').on('click',function(){ $.ajax({ url : '/e/action/get_news_index.php', type:'POST', data:{"next":i,'table':'news','action':'getmorenews','limit':15,'small_length':120}, dataType : 'html', beforeSend:function(){ $("#loadmore").show().html('正在努力读取中...'); $('#loadmore').attr('disabled','disabled'); }, success : function(data){ if(data){ $("#showajaxnews").append(data); $("#loadmore").removeAttr('disabled'); $("#loadmore").html('点击读取更多'); i++; }else{ $("#loadmore").show().html("已全部读取完！"); $('#loadmore').attr('disabled','disabled'); return false; } } }); }); });

卓越飞翔博客

帝国CMS二次开发无刷新Ajax加载更多列表信息插件

" target="_blank"><?=$r[title]?>

相关推荐