©
This document uses PHP Chinese website manual Release
(PECL maxdb >= 1.0)
maxdb_stmt_data_seek -- maxdb_stmt::data_seek — Seeks to an arbitray row in statement result set
过程化风格
$statement
, int $offset
)面向对象风格
$offset
)
The maxdb_stmt_data_seek() function seeks to an arbitrary result pointer
specified by the offset
in the statement result set represented by
statement
. The offset
parameter must be between
zero and the total number of rows minus one (0.. maxdb_stmt_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, zip FROM hotel.city ORDER BY name" ;
if ( $stmt = $maxdb -> prepare ( $query )) {
$stmt -> execute ();
$stmt -> bind_result ( $name , $code );
$stmt -> store_result ();
$stmt -> data_seek ( 5 );
$stmt -> fetch ();
printf ( "City: %s Zip: %s\n" , $name , $code );
$stmt -> close ();
}
$maxdb -> close ();
?>
Example #2 过程化风格
<?php
$link = maxdb_connect ( "localhost" , "MONA" , "RED" , "DEMODB" );
if ( maxdb_connect_errno ()) {
printf ( "Connect failed: %s\n" , maxdb_connect_error ());
exit();
}
$query = "SELECT name, zip FROM hotel.city ORDER BY name" ;
if ( $stmt = maxdb_prepare ( $link , $query )) {
maxdb_stmt_execute ( $stmt );
maxdb_stmt_bind_result ( $stmt , $name , $code );
maxdb_stmt_store_result ( $stmt );
maxdb_stmt_data_seek ( $stmt , 5 );
maxdb_stmt_fetch ( $stmt );
printf ( "City: %s Zip: %s\n" , $name , $code );
maxdb_stmt_close ( $stmt );
}
maxdb_close ( $link );
?>
以上例程的输出类似于:
City: Dallas Zip: 75243