maxdb_data_seek

maxdb_result::data_seek

(PECL maxdb >= 1.0)

maxdb_data_seek -- maxdb_result::data_seek — Adjusts the result pointer to an arbitary row in the result

说明

过程化风格

maxdb_data_seek ( resource $result , int $offset ) : bool

面向对象风格

maxdb_result::data_seek ( int $offset ) : bool

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
/* Open a connection */
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

/* check connection */
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)) {

   /* seek to row no. 10 */
   $result->data_seek(10);

   /* fetch row */
   $row = $result->fetch_row();

   printf ("City: %s  State: %s\n", $row[0], $row[1]);

   /* free result set*/
   $result->close();
}

/* close connection */
$maxdb->close();
?>

Example #2 过程化风格

<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

/* check connection */
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)) {

   /* seek to row no. 400 */
   maxdb_data_seek($result, 10);

   /* fetch row */
   $row = maxdb_fetch_row($result);

   printf ("City: %s  State: %s\n", $row[0], $row[1]);

   /* free result set*/
   maxdb_free_result($result);
}

/* close connection */
maxdb_close($link);
?>

以上例程的输出类似于：

City: Irvine  State: CA

参见

相关文章
php cubrid mysql 兼容性函数 move the internal row pointer of the cubrid resultphp ibm db2 函数 sets the result set pointer to the next row or requested rowphp frontbase 函数 move internal result pointerphp ingres 函数 fetch a row of result into an arrayphp ingres 函数 fetch a row of result into an associative arrayphp maxdb 函数 adjusts the result pointer to an arbitary row in the resultphp maxdb 函数 fetch a result row as an associative a numeric array or bothphp maxdb 函数 fetch a result row as an associative arrayphp maxdb 函数 returns the lengths of the columns of the current row in the result setphp maxdb 函数 returns the current row of a result set as an objectphp maxdb 函数 get a result row as an enumerated arrayphp maxdb 函数 set result pointer to a specified field offsetphp maxdb 函数 get current field offset of a result pointerphp maxdb 函数 binds variables to a prepared statement for result storagephp maxdb 函数 seeks to an arbitray row in statement result setphp mssql 函数 returns an associative array of the current row in the resultphp mssql 函数 move the internal result pointer to the next resultphp oci8 函数 fetches the next row into result bufferphp sybase 函数 get a result row as an enumerated arrayphp mysqli result adjusts the result pointer to an arbitrary row in the result
关注编程学问公众号