php分页显示文章列表

<div class="content">
			<ul>
            <?php
$querySel = "select * from news where ClassID ='".$lid."' and DShow=1 order by Addtime desc";


$result = mysql_query($querySel) or die(mysql_error()); 
$total_records = mysql_num_rows($result);   //取得总记录数

$page_size = 12;  //每页显示的条数
$nums = $total_records;  //总条目数
$sub_pages = 5;   //每次显示的页数
$pageCurrent = $_GET["page"];     //得到当前是第几页    

if(!$pageCurrent) $pageCurrent = 1;

//$begin_record = 0;   //显示记录的首行序号
$begin_record = ($pageCurrent - 1) * $page_size;

if($total_records> 0) 
{ 

	//利用LIMIT关键字获取本页所要显示的记录,注意limit两边要"空格"; 
	$querySel = $querySel. " limit ".$begin_record. ", ".$page_size; 
	
	$result = mysql_query($querySel)   or   die(mysql_error()); 
	$current_records = mysql_num_rows($result); //取得本页的记录总数 
	
	//将查询结果放在$result_show 数组
	$result_show = array(); 

}

 $i = 0; 
	while($row=mysql_fetch_array($result)) 
	{ 
	$result_show[$i] = $row; 
?>

<li><a href="NewsInfo.php?id=<?php echo $result_show[$i]['ID'] ?>" target="_blank" class="tmain"><?php echo ($result_show[$i]['Tit']) ?></a><span class="riqi"><?php echo date('Y-m-d', strtotime($result_show[$i]['Addtime'])); ?></span></li>
<?php
}
?>
            </ul>    
            
        <div class="pageclass"><?php $subPages=new SubPages($page_size,$nums,$pageCurrent,$sub_pages,"list.php?id=".$lid."&page=",2);?></div>    
        </div>

  

posted @ 2013-12-11 11:00  山貓  阅读(628)  评论(0编辑  收藏  举报