页面的效果
页面的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>