<?
php
require_once
(
'
../Connections/lr.php
'
);
?>
<?
php
//
设定每一页显示的记录数
$pagesize
=
10
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//
取得记录总数$rs,计算总页数用
mysql_select_db
(
$database_lr
,
$lr
);
$rs
=
mysql_query
(
"
select count(*) from admin
"
);
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
$myrow
=
mysql_fetch_array
(
$rs
);
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
$numrows
=
$myrow
[
0
];
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//
计算总页数
$pages
=
intval
(
$numrows
/
$pagesize
);
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
if
(
$numrows
%
$pagesize
)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
$pages
++
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//
设置页数
if
(
isset
(
$_GET
[
'
page
'
])){
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
$page
=
intval
(
$_GET
[
'
page
'
]);
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
}
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
else
{
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//
设置为第一页
$page
=
1
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
}
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//
计算记录偏移量
$offset
=
$pagesize
*
(
$page
-
1
);
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//
读取指定记录数
$rs
=
mysql_query
(
"
select * from admin order by id limit $offset,$pagesize
"
);
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
if
(
$myrow
=
mysql_fetch_array
(
$rs
))
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
{
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
$i
=
0
;
//
如果$url使用默认,即空值,则赋值为本页URL:
if
(
!
$url
){
$url
=
$_SERVER
[
"
REQUEST_URI
"
];}
//
URL分析:
$parse_url
=
parse_url
(
$url
);
$url_query
=
$parse_url
[
"
query
"
];
//
单独取出URL的查询字串
if
(
$url_query
){
//
因为URL中可能包含了页码信息,我们要把它去掉,以便加入新的页码信息。
//这里用到了正则表达式,请参考“PHP中的正规表达式”(http://www.pconline.com.cn/pcedu/empolder/wz/php/10111/15058.html)
$url_query
=
ereg_replace
(
"
(^|&)page=$page
"
,
""
,
$url_query
);
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//
将处理后的URL的查询字串替换原来的URL的查询字串:
$url
=
str_replace
(
$parse_url
[
"
query
"
]
,
$url_query
,
$url
);
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//
在URL后加page查询信息,但待赋值:
if
(
$url_query
)
$url
.=
"
&page
"
;
else
$url
.=
"
page
"
;
}
else
{
$url
.=
"
?page
"
;
}
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
?>
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
<
table border
=
"
0
"
width
=
"
80%
"
>
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
<
tr
>
<
Td bgcolor
=
"
#E0E0E0
"
>
ID
</
Td
>
<
td width
=
"
40%
"
bgcolor
=
"
#E0E0E0
"
>
帐号
</
td
>
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
<
td width
=
"
30%
"
bgcolor
=
"
#E0E0E0
"
>
密码
</
td
>
<
td bgcolor
=
"
#E0E0E0
"
>
操作
</
td
>
</
tr
>
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
<?
php
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
do
{
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
$i
++
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
?>
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
<
tr
>
<
td bgcolor
=
"
#eeeeee
"
><?
PHP
echo
$myrow
[
"
id
"
]
?></
td
>
<
td width
=
"
40%
"
bgcolor
=
"
#eeeeee
"
><?
PHP
echo
$myrow
[
"
user
"
]
?></
td
>
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
<
td width
=
"
30%
"
bgcolor
=
"
#eeeeee
"
><?
PHP
echo
$myrow
[
"
password
"
]
?></
td
>
<
Td bgcolor
=
"
#E0E0E0
"
><
a href
=
"
admin_modify_user.php?id=<?php echo $myrow[
"
id
"
]?>
"
>
修改密码
</
a
></
Td
>
</
tr
>
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
<?
php
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
}
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
while
(
$myrow
=
mysql_fetch_array
(
$rs
));
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
echo
"
</table>
"
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
}
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
echo
"
<div align='center'>共有
"
.
$pages
.
"
页(
"
.
$page
.
"
/
"
.
$pages
.
"
)
"
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//
for ($i=1;$i< $page;$i++)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//echo "<a href='?page=".$i."'>[".$i ."]</a> ";
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//echo "[".$page."]";
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//for ($i=$page+1;$i<=$pages;$i++)
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
//echo "<a href='?page=".$i."'>[".$i ."]</a> ";
$first
=
1
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
$prev
=
$page
-
1
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
$next
=
$page
+
1
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
$last
=
$pages
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
if ($page > 1)
{
echo "<a href='",$url,"=".$first."'>首页</a> ";
echo "<a href='",$url,"=".$prev."'>上一页</a> ";
}
if ($page < $pages)
{
echo "<a href='",$url,"=".$next."'>下一页</a> ";
echo "<a href='",$url,"=".$last."'>尾页</a> ";
}
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
echo
"
<select name=change οnchange='window.location="$url="+this.value'>
"
;
for
(
$i
=
1
;
$i
<=
$pages
;
$i
++
){
if
(
$i
==
$page
)
echo
"
<option value='$i' selected>$i/$pages</option>
"
;
else
echo
"
<option value='$i'>$i/$pages</option>
"
;
}
echo
"
</select>
"
;
echo
"
</div>
"
;
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)
?>