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

方法/步骤新建一个空白的php,然后将以下代码粘贴到网页中,并保存为getmore.php;
<?php
require(&#39;../class/connect.php&#39;);
require(&#39;../class/db_sql.php&#39;);

方法/步骤

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

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

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

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

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

如下示例代码:

&lt;?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;
?>
分享到 :
相关推荐

发表评论

登录... 后才能评论

评论(3)

加入本站VIP会员订阅计划,海量资源免费下载查看

目前为止共有3位优秀的VIP会员加入!

立即加入VIP会员