require_once(dirname(__FILE__)."/../include/common.inc.php");
if(isset($_GET['ajax'])){ $typeid = isset($_GET['typeid']) ? intval($_GET['typeid']): 0;//傳遞過(guò)來(lái)的分類ID $page = isset($_GET['page']) ? intval($_GET['page']): 0;//頁(yè)碼 $pagesize = isset($_GET['pagesize']) ? intval($_GET['pagesize']): 15;//每頁(yè)多少條,也就是一次加載多少條數(shù)據(jù) $start = $page>0 ? ($page-1)*$pagesize : 0;//數(shù)據(jù)獲取的起始位置。即limit條件的第一個(gè)參數(shù)。 $typesql = $typeid ? " WHERE typeid=$typeid" : '';//這個(gè)是用于首頁(yè)實(shí)現(xiàn)瀑布流加載,因?yàn)槭醉?yè)加載數(shù)據(jù)是無(wú)需分類的,所以要加以判斷,如果無(wú)需 $total_sql = "SELECT COUNT(id) as num FROM `dede_archives` $typesql "; $temp = $dsql->GetOne($total_sql); $total = 0;//數(shù)據(jù)總數(shù) $load_num =0; if(is_array($temp)){ $load_num= round(($temp['num']-15)/$pagesize);//要加載的次數(shù),因?yàn)槟J(rèn)已經(jīng)加載了 $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;//是否有數(shù)據(jù),默認(rèn)沒(méi)有數(shù)據(jù) $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'];//完整的標(biāo)題 $row['shorttitle'] = $row['shorttitle'];//副標(biāo)題 $row['title'] = cn_substr($row['title'], 80);//截取后的標(biāo)題 $data[$index] = $row; $index++; } if(!empty($data)){ $statu = 1;//有數(shù)據(jù) } $result =array('statu'=>$statu,'list'=>$data,'total'=>$total,'load_num'=>$load_num); echo json_encode($result);//返回?cái)?shù)據(jù) exit(); } |
<script src="http://libs.baidu.com/jquery/1.9.0/jquery.js"></script>
<script type="text/javascript"> var loadConfig = { url_api:'/plus/list.php', typeid:{dede:field name="typeid"/}, page:2, pagesize:15, //這個(gè)就是滑動(dòng)一次添加幾條信息的參數(shù)設(shè)置 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){ window.removeEventListener('srcoll',loadMoreApply,false); } |
$('<div style="width:100%; float:left; text-align:center; padding: 10px 0px; color:#fff; background:#00aa98; font-size: 16px;">加載完成</div>').insertAfter('.yz_xinwen');
if(isset($_GET['ajax'])){ $typeid = isset($_GET['typeid']) ? intval($_GET['typeid']): 0;//傳遞過(guò)來(lái)的分類ID $page = isset($_GET['page']) ? intval($_GET['page']): 0;//頁(yè)碼 $pagesize = isset($_GET['pagesize']) ? intval($_GET['pagesize']): 15;//每頁(yè)多少條,也就是一次加載多少條數(shù)據(jù) $start = $page>0 ? ($page-1)*$pagesize : 0;//數(shù)據(jù)獲取的起始位置。即limit條件的第一個(gè)參數(shù)。 //獲取頻道欄目下的子欄目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" : '';//這個(gè)是用于首頁(yè)實(shí)現(xiàn)瀑布流加載,因?yàn)槭醉?yè)加載數(shù)據(jù)是無(wú)需分類的,所以要加以判斷,如果無(wú)需 $total_sql = "SELECT COUNT(id) as num FROM `dede_archives` $typesql "; $temp = $dsql->GetOne($total_sql); $total = 0;//數(shù)據(jù)總數(shù) $load_num =0; if(is_array($temp)){ $load_num= round(($temp['num']-15)/$pagesize);//要加載的次數(shù),因?yàn)槟J(rèn)已經(jīng)加載了 $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;//是否有數(shù)據(jù),默認(rèn)沒(méi)有數(shù)據(jù) $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'];//完整的標(biāo)題 $row['shorttitle'] = $row['shorttitle'];//副標(biāo)題 $row['title'] = cn_substr($row['title'], 80);//截取后的標(biāo)題 $data[$index] = $row; $index++; } if(!empty($data)){ $statu = 1;//有數(shù)據(jù) } $result =array('statu'=>$statu,'list'=>$data,'total'=>$total,'load_num'=>$load_num); echo json_encode($result);//返回?cái)?shù)據(jù) exit(); } |
版權(quán)聲明: 本站資源均來(lái)自互聯(lián)網(wǎng)或會(huì)員發(fā)布,如果侵犯了您的權(quán)益請(qǐng)與我們聯(lián)系,我們將在24小時(shí)內(nèi)刪除!謝謝!
轉(zhuǎn)載請(qǐng)注明: dedecms利用ajax實(shí)現(xiàn)瀑布流下拉無(wú)限加載的教程jquery