PHP的分页

页面的效果

页面的css

 1 @CHARSET "UTF-8";
 2 *{
 3     margin:0;
 4     padding:0;
 5 }
 6 body{
 7     800px;    
 8     margin:0 auto;
 9     border:1px solid green;
10 }
11 #content ul{
12     background:gray;
13     300px;
14     height:400px;
15     list-style-type:none;
16 }
17 #content ul li{
18     250px;
19     height:20px;
20     line-height:20px;
21     background:orange;
22     margin-top:2px;
23 }
24 
25 #fenye ul{
26     list-style-type:none;
27 }
28 #fenye li{
29     20px;
30     height:20px;
31     text-align:center;
32     border:1px solid red;
33     margin-right:2px;
34     float:left;
35 }
36 #fenye ul li a{
37     text-decoration:none;
38     display:block;
39     20px;
40     height:20px;
41     line-height:20px;
42     background:orange;    
43     color:black;
44 }
45 #fenye ul li a:hover{
46     cursor:pointer;
47 }

页面的主体部分

 1 <?php 
 2 
 3 header('Content-type:text/html;charset="utf-8"');
 4 
 5 define('DB_HOST','****');
 6 define('DB_USER','****');
 7 define('DB_PWD','***');
 8 define('DB_NAME','*****');
 9 
10 //初始化数据库
11 if(!$_conn = @mysql_connect(DB_HOST,DB_USER,DB_PWD)){
12     exit('数据库连接失败');
13 }
14 //选择数据库
15 if(!mysql_select_db(DB_NAME,$_conn)){
16     exit('找不到指定的数据库');
17 }
18 
19 //设置字符集
20 if (!mysql_query("SET NAMES UTF8")){
21     exit('字符集错误！');
22 }
23 
24 /*下面是分页参数*/
25 
26 //设置当前页数:$_pageNum;
27 
28 if(isset($_GET['page'])){
29     $_pageNum = $_GET['page'];
30 }else {
31     $_pageNum=1;
32 }
33 //设置每页显示几条数据:$everyRows
34 $evryRows = 3;
35 
36 //设置总页数:$pageCount;
37 $pageNums=mysql_num_rows(mysql_query("SELECT id FROM grade"));
38 if ($pageNums==0){
39     $pageCount=1;
40 }else {
41     $pageCount = ceil($pageNums/$evryRows);
42 }
43 
44 
45 //设置第几页开始的页码:$startcount
46 $startcount = ($_pageNum-1)*$evryRows;
47 //执行sql语句
48 $_sql="SELECT id,name,address FROM grade Limit $startcount,$evryRows";
49 if(!$_result = mysql_query($_sql)){
50     exit('SQL执行失败！');
51 }
52 
53 
54 ?>
55 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
56 <html xmlns="http://www.w3.org/1999/xhtml">
57 <head>
58 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
59 <title>分页</title>
60 <link rel="stylesheet" type="text/css" href="includes/index.css"/>
61 </head>
62 <body>
63     <div id="content">
64         <ul>
65             <?php while (!!$_rows = mysql_fetch_array($_result,MYSQL_ASSOC)) {?>    
66             <li><?php echo $_rows['id'].'---'.$_rows['name'].'---'.$_rows['address']?></li>
67             <?php }?>        
68         </ul>
69         
70     </div>
71     <div id="fenye">
72     <ul>
73         
74         <?php for ($count=0;$count<$pageCount;$count++){
75             echo '<li><a href="?page='.($count+1).'">'.($count+1).'</a></li>';
76         }
77         ?>            
78         
79     </ul>
80     </div>
81 </body>
82 </html>