dedecms利用ajax实现瀑布流下拉无限加载的教程jquery

if(isset($_GET['ajax'])){    $typeid = isset($_GET['typeid']) ? intval($_GET['typeid']): 0;//传递过来的分类ID    $page = isset($_GET['page']) ? intval($_GET['page']): 0;//页码    $pagesize = isset($_GET['pagesize']) ? intval($_GET['pagesize']): 15;//每页多少条，也就是一次加载多少条数据    $start = $page>0 ? ($page-1)*$pagesize : 0;//数据获取的起始位置。即limit条件的第一个参数。    $typesql = $typeid ? " WHERE typeid=$typeid" : '';//这个是用于首页实现瀑布流加载，因为首页加载数据是无需分类的，所以要加以判断，如果无需    $total_sql = "SELECT COUNT(id) as num FROM `dede_archives` $typesql ";    $temp = $dsql->GetOne($total_sql);    $total = 0;//数据总数    $load_num =0;    if(is_array($temp)){        $load_num= round(($temp['num']-15)/$pagesize);//要加载的次数,因为默认已经加载了        $total = $temp['num'];    }    $sql = "SELECT a.*,t.typedir,t.typename,t.isdefault,t.defaultname,t.namerule,    t.namerule2,t.ispart, t.moresite,t.siteurl,t.sitepath    FROM `dede_archives` as a JOIN `dede_arctype` AS t ON a.typeid=t.id $typesql ORDER BY id DESC LIMIT $start,$pagesize";    $dsql->SetQuery($sql);    $dsql->Execute('list');    $statu = 0;//是否有数据，默认没有数据    $data = array();    $index = 0;    while($row = $dsql->GetArray("list")){        $row['info'] = $row['info'] = $row['infos'] = cn_substr($row['description'],160);        $row['id'] =  $row['id'];        $row['filename'] = $row['arcurl'] = GetFileUrl($row['id'],        $row['typeid'],$row['senddate'],$row['title'],$row['ismake'],        $row['arcrank'],$row['namerule'],$row['typedir'],$row['money'],        $row['filename'],$row['moresite'],$row['siteurl'],$row['sitepath']);        $row['typeurl'] = GetTypeUrl($row['typeid'],$row['typedir'],        $row['isdefault'],$row['defaultname'],$row['ispart'],        $row['namerule2'],$row['moresite'],$row['siteurl'],$row['sitepath']);        if($row['litpic'] == '-' || $row['litpic'] == ''){            $row['litpic'] = $GLOBALS['cfg_cmspath'].'/images/defaultpic.gif';        }        if(!preg_match("#^http:////#i", $row['litpic']) &&$GLOBALS['cfg_multi_site'] == 'Y'){            $row['litpic'] = $GLOBALS['cfg_mainsite'].$row['litpic'];        }        $row['picname'] = $row['litpic'];//缩略图        //$row['stime'] = GetDateMK($row['pubdate']);        $row['stime'] = date('Y-m-d H:i', $row['pubdate']);        $row['click'] = $row['click'];        $row['typelink'] = "".$row['typename']."";//分类链        $row['fulltitle'] = $row['title'];//完整的标题        $row['shorttitle'] = $row['shorttitle'];//副标题        $row['title'] = cn_substr($row['title'], 80);//截取后的标题        $data[$index] = $row;        $index++;    }    if(!empty($data)){        $statu = 1;//有数据    }    $result =array('statu'=>$statu,'list'=>$data,'total'=>$total,'load_num'=>$load_num);    echo json_encode($result);//返回数据    exit();}

&nbsp;<script type="text/javascript">var loadConfig = {    url_api:'/plus/list.php',    typeid:{dede:field name="typeid"/},    page:2,    pagesize:15,  //这个就是滑动一次添加几条信息的参数设置    loading : 0,    }function  loadMoreApply(){if(loadConfig.loading == 0){   var typeid = loadConfig.typeid;   var page = loadConfig.page;   var pagesize = loadConfig.pagesize;   var url = loadConfig.url_api,data={ajax:'pullload',typeid:typeid,page:page,pagesize:pagesize};   var sTop = document.body.scrollTop || document.documentElement.scrollTop, dHeight = $(document).height(), cHeight = document.documentElement.clientHeight;   console.log(dHeight);     if (sTop + cHeight >= dHeight - cHeight) {    loadConfig.loading = 1;   function ajax(url, data) {       $.ajax({url: url,data: data,async: false,type: 'GET',dataType: 'json',success: function(data) {     addContent(data);     }});   }   ajax(url,data);  }}}function addContent (rs){if(rs.statu== 1){  var data = rs.list;  var total = rs.total;  var arr=[];  var length = data.length;  for(var i=0;i<length;i++){   arr.push('<a href="'+data[i].arcurl+'" title="'+data[i].title+'">');   arr.push('<dl class="yz_card">');   arr.push('<dt class="yz_card_dt">');   arr.push('<img src="'+data[i].picname+'" alt="'+data[i].title+'">');   arr.push('</dt>');   arr.push('<dd class="yz_card_dd">');   arr.push('<p class="yz_card_p">'+data[i].title+'</p>');   arr.push('<div class="yz_card_icon">');   arr.push('<span class="yz_comment">');   arr.push(data[i].click);         arr.push('<em class="yz_icon_comment"><img src="/templets/default/images/pingluan.png" height="14"></em>');   arr.push('</span>');   arr.push('</div>');   arr.push('<div class="yz_datetime">'+data[i].stime+'</div>');   arr.push('</dd>');   arr.push('</dl>');   arr.push('</a>');  }  $('.yz_xinwen').append(arr.join(''));  loadConfig.load_num = rs.load_num;  if(total<loadConfig.page*loadConfig.pagesize || loadConfig.page > loadConfig.load_num){   window.removeEventListener('srcoll',loadMoreApply,false);  }  loadConfig.page++;  loadConfig.loading = 0;}}function pullLoad(){window.addEventListener('scroll', loadMoreApply, false);}pullLoad()checkMobile();</script>

if(total<loadConfig.page*loadConfig.pagesize || loadConfig.page > loadConfig.load_num){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; window.removeEventListener('srcoll',loadMoreApply,false);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }

if(isset($_GET['ajax'])){    $typeid = isset($_GET['typeid']) ? intval($_GET['typeid']): 0;//传递过来的分类ID    $page = isset($_GET['page']) ? intval($_GET['page']): 0;//页码    $pagesize = isset($_GET['pagesize']) ? intval($_GET['pagesize']): 15;//每页多少条，也就是一次加载多少条数据    $start = $page>0 ? ($page-1)*$pagesize : 0;//数据获取的起始位置。即limit条件的第一个参数。    //获取频道栏目下的子栏目ID    $yz_typeid = $dsql->GetOne("SELECT COUNT(id) as num FROM `dede_arctype` WHERE reid=$typeid ");    if($yz_typeid['num']!=0){        $sql = "SELECT * FROM `dede_arctype` WHERE reid=$typeid";        $dsql->SetQuery($sql);        $dsql->Execute('yz_id');        $typepdid = "";        $yz = 1;         while($row = $dsql->GetArray("yz_id")){             if($yz_typeid['num'] == $yz){                $typepdid .= "(typeid=".$row['id'].")";            }else{                 $typepdid .= "(typeid=".$row['id'].") or ";                $yz += 1;            }         }        // echo $yz_typeid['num']."+++".$typepdid;         //exit();    }else {        $typepdid = "typeid=$typeid";    }    $typesql = $typeid ? " WHERE $typepdid" : '';//这个是用于首页实现瀑布流加载，因为首页加载数据是无需分类的，所以要加以判断，如果无需    $total_sql = "SELECT COUNT(id) as num FROM `dede_archives` $typesql ";    $temp = $dsql->GetOne($total_sql);    $total = 0;//数据总数    $load_num =0;    if(is_array($temp)){        $load_num= round(($temp['num']-15)/$pagesize);//要加载的次数,因为默认已经加载了        $total = $temp['num'];    }    $sql = "SELECT a.*,t.typedir,t.typename,t.isdefault,t.defaultname,t.namerule,    t.namerule2,t.ispart, t.moresite,t.siteurl,t.sitepath    FROM `dede_archives` as a JOIN `dede_arctype` AS t ON a.typeid=t.id $typesql ORDER BY id DESC LIMIT $start,$pagesize";    $dsql->SetQuery($sql);    $dsql->Execute('list');    $statu = 0;//是否有数据，默认没有数据    $data = array();    $index = 0;    while($row = $dsql->GetArray("list")){        $row['description'] = cn_substr($row['description'],90);        $row['id'] =  $row['id'];        $row['filename'] = $row['arcurl'] = GetFileUrl($row['id'],        $row['typeid'],$row['senddate'],$row['title'],$row['ismake'],        $row['arcrank'],$row['namerule'],$row['typedir'],$row['money'],        $row['filename'],$row['moresite'],$row['siteurl'],$row['sitepath']);        $row['typeurl'] = GetTypeUrl($row['typeid'],$row['typedir'],        $row['isdefault'],$row['defaultname'],$row['ispart'],        $row['namerule2'],$row['moresite'],$row['siteurl'],$row['sitepath']);        $row['waparcurl'] = preg_replace("(.*/m/)","/",$row['arcurl']);        if($row['litpic'] == '-' || $row['litpic'] == ''){            $row['litpic'] = $GLOBALS['cfg_cmspath'].'/images/defaultpic.gif';        }        if(!preg_match("#^http:////#i", $row['litpic']) &&$GLOBALS['cfg_multi_site'] == 'Y'){            $row['litpic'] = $GLOBALS['cfg_mainsite'].$row['litpic'];        }        $row['picname'] = $row['litpic'];//缩略图        //$row['stime'] = GetDateMK($row['pubdate']);        $row['stime'] = date('Y-m-d H:i', $row['pubdate']);        $row['click'] = $row['click'];        $row['typelink'] = "".$row['typename']."";//分类链        $row['fulltitle'] = $row['title'];//完整的标题        $row['shorttitle'] = $row['shorttitle'];//副标题        $row['title'] = cn_substr($row['title'], 80);//截取后的标题        $data[$index] = $row;        $index++;    }    if(!empty($data)){        $statu = 1;//有数据    }    $result =array('statu'=>$statu,'list'=>$data,'total'=>$total,'load_num'=>$load_num);    echo json_encode($result);//返回数据    exit();}