Dede(织梦)列表页ajax调用
//判断是否ajax获取 if(isset($_GET['type']) && $_GET['type'] == "ajax"){ header("Content-type:text/json;charset=gbk;"); //传递过来的分类ID $typeid = isset($_GET['tid']) ? intval($_GET['tid']): 0; //页码 $page = isset($_GET['page']) ? intval($_GET['page']): 0; //每页多少条,也就是一次加载多少条数据 $pagesize = isset($_GET['pagesize']) ? intval($_GET['pagesize']): 12; //数据获取的起始位置。即limit条件的第一个参数。 $start = $page>0 ? ($page-1)*$pagesize : 0; //这个是用于首页实现瀑布流加载,因为首页加载数据是无需分类的,所以要加以判断,如果无需 //是否有子栏目 $dsql->SetQuery("select id from dede_arctype where topid = $typeid"); $dsql->Execute('list'); $typeid = $typeid; while($row = $dsql->GetArray("list")){ $typeid .=",".$row['id']; } $typesql = $typeid ? " WHERE typeid in($typeid)" : ''; $total_sql = "SELECT COUNT(id) as num FROM `dede_archives` $typesql "; $temp = $dsql->GetOne($total_sql); $total = 0;//数据总数 $load_num =0; $load_num= ceil($temp['num']/$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; $res = array(); $data = array(); while($row = $dsql->GetArray("list")){ $data[$index]['info'] = $row['info'] = $row['infos'] = cn_substr($row['description'],160); $data[$index]['id'] = $row['id']; if($row['litpic'] == '-' || $row['litpic'] == ''){ $data[$index]['litpic'] = $GLOBALS['cfg_cmspath'].'/images/defaultpic.gif'; } if(!preg_match("#^http:\/\/#i", $row['litpic']) &&$GLOBALS['cfg_multi_site'] == 'Y'){ $data[$index]['litpic'] = $GLOBALS['cfg_mainsite'].$row['litpic']; } $data[$index]['picname'] = $row['litpic'];//缩略图 $data[$index]['stime'] = getUtf(GetDateMK($row['pubdate'])); $data[$index]['typelink'] = getUtf("".$row['typename']."");//分类链 $data[$index]['fulltitle'] = getUtf($row['title']);//完整的标题 $data[$index]['shorttitle'] = getUtf($row['shorttitle']);//副标题 $data[$index]['title'] = getUtf(cn_substr($row['title'], 60));//截取后的标题 $index++; } $res['data'] = $data; $res['pages'] = $load_num; echo json_encode($res); die(); }