简单实用的原生PHP分页类

 1 include_once("config.php"); 
 2 require_once(‘page.class.php‘); //分页类 
 3 $showrow = 10; //一页显示的行数 
 4 $curpage = empty($_GET[‘page‘]) ? 1 : $_GET[‘page‘]; //当前的页,还应该处理非数字的情况 
 5 $url = "?page={page}"; //分页地址，如果有检索条件 ="?page={page}&q=".$_GET[‘q‘] 
 6 //省略了链接mysql的代码，测试时自行添加 
 7 $sql = "SELECT id,content,addtime FROM wishing_wall"; 
 8 $total = mysql_num_rows(mysql_query($sql)); //记录总条数 
 9 if (!empty($_GET[‘page‘]) && $total != 0 && $curpage > ceil($total / $showrow)) 
10     $curpage = ceil($total_rows / $showrow); //当前页数大于最后页数，取最后一页 
11 //获取数据 
12 $sql .= " LIMIT " . ($curpage - 1) * $showrow . ",$showrow;"; 
13 $query = mysql_query($sql);

1 <ul class="dates"> 
2     <?php while ($row = mysql_fetch_array($query)) { ?> 
3         <li> 
4             <span><?php echo $row[‘addtime‘] ?></span> 
5             <a target="_blank" href="http://"><?php echo $row[‘content‘] ?></a> 
6         </li> 
7     <?php } ?> 
8 </ul>

1 <div class="showPage"> 
2     <?php 
3     if ($total > $showrow) {//总记录数大于每页显示数，显示分页 
4         $page = new page($total, $showrow, $curpage, $url, 2); 
5         echo $page->myde_write(); 
6     } 
7     ?> 
8 </div>