001
<?php
002
003
004
005
006
include_once
(
"db.inc.php"
);
007
008
class
FENYE
extends
DBSQL{
009
010
public
$count_1
;
011
012
private
$pageper
=3;
013
014
public
$pc
;
015
016
private
$sql
=
"select * from students"
;
017
018
public
$offset
;
019
020
public
function
__constract(){
021
022
parent::__constract();
023
024
}
025
026
public
function
caculate(
$sql
=
""
){
027
028
$sql
=
$this
->sql;
029
030
$result
=mysql_query(
$sql
)
or
die
(mysql_error());
031
032
$count
=mysql_num_rows(
$result
);
033
034
$this
->count_1=
$count
;
035
036
$pc
=
intval
(
$count
/
$this
->pageper)+1;
037
038
$this
->pc=
$pc
;
039
040
}
041
042
public
function
url(
$targetUrl
){
043
044
$pagesize
=
$this
->pageper ;
045
046
$page
=isset(
$_GET
[
'page'
])?
intval
(
$_GET
[
'page'
]):1;
047
048
$sql
=
"select * from students limit "
.(
$page
-1)*
$pagesize
.
",$pagesize"
;
049
050
051
052
$results
=mysql_query(
$sql
)
or
die
(mysql_error());
053
054
while
(
$row
= mysql_fetch_array(
$results
)){
055
056
for
(
$i
=0;
$i
<
count
(
$row
);
$i
++)
057
058
echo
$row
[
$i
].
" "
;
059
060
echo
"<br>"
;
061
062
}
063
064
$offset
=(
$page
-1)*
$pagesize
;
065
066
$prepage
=
$page
-1;
067
068
$nextpage
=
$page
+1;
069
070
$pagenav
=
"共"
.
$this
->count_1.
" 条记录每页显示$pagesize 条记录,共"
.
$this
->pc.
" 页,当前第$page 页"
;
071
072
if
(
$page
==1){
073
074
$strpage
=
"【第一页】【上一页】<a href='$targetUrl?page=$nextpage'>【下一页】</a><a href='$targetUrl?page=$pc'>【最后一页】</a>"
;
075
076
}
077
078
if
(
$page
>1&&
$page
<=
$this
->pc){
079
080
$strpage
=
"<a href='$targetUrl?page=1'>【第一页】</a><a href='$targetUrl?page=$prepage'>【上一页】</a><a href='$targetUrl?page=$nextpage'>【下一页】</a><a href='$targetUrl?page=$pc'>【最后一页】</a>"
;
081
082
}
083
084
if
(
$page
==
$this
->pc){
085
086
$strpage
=
"<a href='$targetUrl?page=1'>【第一页】</a><a href='$targetUrl?page=$prepage'>【上一页】</a>【下一页】【最后一页】"
;
087
088
}
089
090
$strpage
=
"$pagenav<br>$strpage"
;
091
092
echo
$strpage
;
093
094
}
095
096
}
097
098
099
100
101
102
103
104
105
106
107
108
109
?>