li{
height:?40px;
line-height:?40px;
}




???????
點擊加載更多

(function?($)?{
$.load_news?=?function(initdata,?ajax_offset){
window.ajax_offset?=?ajax_offset;
var?ajaxutl?=?'/ajax/result.php';
var?init_data?=?{
limit?:?0,
offset?:?window.ajax_offset,
tbname?:?'',
classid?:?0,
order?:?'',
dom?:?'',
click_dom?:?''
}
init_data?=?$.extend({},?init_data,?initdata);
var?result_lang?=?{
data_0?:?'暫無數(shù)據(jù)',
tbname_not?:?'沒有此數(shù)據(jù)表'
}
$.post(
ajaxutl,
init_data,
function(data){
var?data?=?data;
if(data.status=='data_0')
{
//?沒有數(shù)據(jù)了~~~~
$(init_data.dom).append(result_lang[data.status]);
//?移除click
$(init_data.click_dom).remove();
//?設置按鈕
//$(init_data.click_dom).attr('disabled',?'disabled');
return?false;
}
$(init_data.dom).append(data.html);
window.ajax_offset?=data.offset;
},
'json'
);
}
})(jQuery);
$(function(){
$("#click").click(function(){
$.load_news({
limit?:?20,????????????????????????????????//?每次查詢多少條
tbname?:?'news',????????????????//?數(shù)據(jù)表名稱
classid?:?3,????????????????????????//?欄目ID
order?:?'desc',????????????????????????//?排序
dom?:?'#html',????????????????????????//?向哪個DOM節(jié)點中插入數(shù)據(jù)?ID請?zhí)顚??class填寫.?例如?填寫?#html
click_dom?:?'#click'????????//?觸發(fā)事件的DOM
},window.ajax_offset);
})
})

'tbname_not')?)?);
}
//?欄目ID
$classid?=?(int)?$p['classid'];
//?order
$order?=?$filter($p['order']);
//?查詢偏移量
$offset?=?(int)?$p['offset'];
if(?$order?==?'desc'??&&?$offset?!=?0?)
{
$where_offset?=?'?and?id??'.$offset;
}
$where?=?'?WHERE?1';
$where?.=?$classid?'?AND?`classid`?=?'.$classid:'';
$where?.=?$where_offset;
$order?=?'ORDER?BY?id?'.$order;
$limit?=?(int)?$p['limit'];
$limit?=?'LIMIT?'.$limit;
$sql?=?"SELECT?{$maxid}id,classid,newspath,filename,groupid,titleurl,title?FROM?`{$dbtbpre}ecms_{$tbname}`?{$where}?{$order}?{$limit}";
$num=$empire->num($sql);
if($num<1){
die(?json_encode(?array('status'=>'data_0',?'sql'=>$sql)?)?);
}
$query?=?$empire->query($sql);
$last?=?0;
$html?=?'';
while($r=$empire->fetch($query)){
$last?=?$r['id'];
$url?=?sys_ReturnBqTitleLink($r);
$html.=?<<id?---?$r[id]$r[title]
HTML_LIST;
}
die(?json_encode(?array('status'=>'ok',?'html'=>$html,?'offset'=>$last,?'sql'=>$sql)?)?);
?>