©
本文档使用
php中文网手册 发布
(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