分页|技巧|应用实例
一,三个函数,一个观念:函数都有输入输出。
1,获取资料表的函数getrows():
function getrows( $database, $query ) {
mysql_connect (ftp, root, );
$db = mysql_select_db( $database );
if ( ! $db ) {
echo 礚猭秨币 kjsql 戈畐叫絋﹚眤竒ミ kjsql 戈畐!;
exit;
}
$rows = mysql_query( $query );
if ( ! $rows ) {
echo sql 岿粇礚猭匡戈!;
exit;
}
return $rows;
}
?>
$rows是函数的输出,作为存取资料的依据。
2,连结数据库的函数connectdatabase():
3,显示一页的函数showonepage():
function showonepage( $rows, $no ) {
mysql_data_seek( $rows, $no );
echo
;
echo no. ;
while ( $field = mysql_fetch_field($rows) ) {
echo . $field->name . ;
}
echo
; for ( $i=1; $i if ( $row = mysql_fetch_row($rows) ) {
echo
. ($no + $i) . ;
for ( $k=0 ; $k echo . $row[$k] . ;
}
echo
;
}
}
echo
;
}
?>
输出为一张表格。二,分页的技巧
version1,只显示1到10条记录:
function showonepage( $rows, $no ) {
mysql_data_seek( $rows, $no );
echo
;
echo no. ;
while ( $field = mysql_fetch_field($rows) ) {
echo . $field->name . ;
}
echo
; for ( $i=1; $i if ( $row = mysql_fetch_row($rows) ) {
echo
. ($no + $i) . ;
for ( $k=0 ; $k echo . $row[$k] . ;
}
echo
;
}
}
echo
;
}
?>
pagev1.php3, version 1 - だмォ
include(../db.func);
$rows = getrows( kjsql, select * from stock ); showonepage( $rows, 0 );
?>
相关说明:1,$no参数,由于显示某一页,利用此参数指定该页的第一笔资料;
2,设定目前资料录的位子:mysql_data_seek($rows,$no);
3,判断是否还有资料录:if ($row=mysql_fetch_row($rows)).
version2,可以在ie位置栏输入页次:
function showonepage( $rows, $no ) {
mysql_data_seek( $rows, $no );
echo
;
echo no. ;
while ( $field = mysql_fetch_field($rows) ) {
echo . $field->name . ;
}
echo
; for ( $i=1; $i if ( $row = mysql_fetch_row($rows) ) {
echo
. ($no + $i) . ;
for ( $k=0 ; $k echo . $row[$k] . ;
}
echo
;
}
}
echo
;
}
?>
pagev2.php3, version 2 - だмォ
include(../db.func);
$rows = getrows( kjsql, select * from stock ); $num = mysql_num_rows($rows);
$pages = intval(($num - 1) / 10) + 1;
if ( $page if ( $page > $pages ) $page = $pages;
showonepage( $rows, ($page-1)*10 );
?>
ω:/
version3,页次的浏览:
function showonepage( $rows, $no ) {
mysql_data_seek( $rows, $no );
echo
;
echo no. ;
while ( $field = mysql_fetch_field($rows) ) {
echo . $field->name . ;
}
echo
; for ( $i=1; $i if ( $row = mysql_fetch_row($rows) ) {
echo
. ($no + $i) . ;
for ( $k=0 ; $k echo . $row[$k] . ;
}
echo
;
}
}
echo
;
}
?>
pagev3.php3, version 3 - ω聅凝
include(../db.func);
$rows = getrows( kjsql, select * from stock ); $num = mysql_num_rows($rows);
$pages = intval(($num - 1) / 10) + 1;
if ( $page if ( $page > $pages ) $page = $pages;
showonepage( $rows, ($page-1)*10 );
?>
if ( $page 1 ) { // 狦ぃ琌材
echo 材;
echo ;
}if ( $page $pages ) { // 狦ぃ琌程
echo ;
echo 程;
}
?>
ω:/
version 4,完成版:
function showonepage( $rows, $no ) {
mysql_data_seek( $rows, $no );
echo
;
echo no. ;
while ( $field = mysql_fetch_field($rows) ) {
echo . $field->name . ;
}
echo
; for ( $i=1; $i if ( $row = mysql_fetch_row($rows) ) {
echo
. ($no + $i) . ;
for ( $k=0 ; $k echo . $row[$k] . ;
}
echo
;
}
}
echo
;
}
?>
pagev4.php3, だ聅凝(чθ)
include(../db.func);
$rows = getrows( kjsql, select * from stock ); $num = mysql_num_rows($rows);
$pages = intval(($num - 1) / 10) + 1;
if ( $page if ( $page > $pages ) $page = $pages;
showonepage( $rows, ($page-1)*10 );
?>
if ( $page 1 ) { // 狦ぃ琌材
echo 材;
echo ;
}if ( $page $pages ) { // 狦ぃ琌程
echo ;
echo 程;
}
?>
块ω:
ω:/