©
This document uses PHP Chinese website manual Release
(PECL maxdb >= 1.0)
maxdb_data_seek -- maxdb_result::data_seek — Adjusts the result pointer to an arbitary row in the result
过程化风格
$result
, int $offset
)面向对象风格
$offset
)
The maxdb_data_seek() function seeks to an arbitrary result pointer
specified by the offset
in the result set represented by
result
. The offset
parameter must be between
zero and the total number of rows minus one (0.. maxdb_num_rows() - 1).
成功时返回 TRUE
, 或者在失败时返回 FALSE
。
Example #1 面向对象风格
<?php
$maxdb = new maxdb ( "localhost" , "MONA" , "RED" , "DEMODB" );
if ( maxdb_connect_errno ()) {
printf ( "Connect failed: %s\n" , maxdb_connect_error ());
exit();
}
$query = "SELECT name, state FROM hotel.city ORDER BY name" ;
if ( $result = $maxdb -> query ( $query )) {
$result -> data_seek ( 10 );
$row = $result -> fetch_row ();
printf ( "City: %s State: %s\n" , $row [ 0 ], $row [ 1 ]);
$result -> close ();
}
$maxdb -> close ();
?>
Example #2 过程化风格
<?php
$link = maxdb_connect ( "localhost" , "MONA" , "RED" , "DEMODB" );
if (! $link ) {
printf ( "Connect failed: %s\n" , maxdb_connect_error ());
exit();
}
$query = "SELECT name, state FROM hotel.city ORDER BY name" ;
if ( $result = maxdb_query ( $link , $query )) {
maxdb_data_seek ( $result , 10 );
$row = maxdb_fetch_row ( $result );
printf ( "City: %s State: %s\n" , $row [ 0 ], $row [ 1 ]);
maxdb_free_result ( $result );
}
maxdb_close ( $link );
?>
以上例程的输出类似于:
City: Irvine State: CA