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