maxdb_stmt_data_seek

Seeks to an arbitray row in statement result set (PECL maxdb:1.0-7.6.00.38)
bool maxdb_stmt_data_seek ( resource statement, int offset )

Example 1260. Object oriented style

<?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, zip FROM hotel.city ORDER BY name";

if ($stmt = $maxdb->prepare($query)) {


   /* execute query */

   $stmt->execute();


   /* bind result variables */

   $stmt->bind_result($name, $code);


   /* store result */

   $stmt->store_result();


   /* seek to row no. 5 */

   $stmt->data_seek(5);


   /* fetch values */

   $stmt->fetch();


   printf ("City: %s  Zip: %s\n", $name, $code);


   /* close statement */

   $stmt->close();

}

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

Example 1261. Procedural style

copy to clipboard

<?php
/* Open a connection */
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

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


   /* execute query */

   maxdb_stmt_execute($stmt);


   /* bind result variables */

   maxdb_stmt_bind_result($stmt, $name, $code);


   /* store result */

   maxdb_stmt_store_result($stmt);


   /* seek to row no. 5 */

   maxdb_stmt_data_seek($stmt, 5);


   /* fetch values */

   maxdb_stmt_fetch($stmt);


   printf ("City: %s  Zip: %s\n", $name, $code);


   /* close statement */

   maxdb_stmt_close($stmt);

}

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

maxdb_stmt_data_seek

Seeks to an arbitray row in statement result set (PECL maxdb:1.0-7.6.00.38) bool maxdb_stmt_data_seek ( resource statement, int offset )

Example 1260. Object oriented style

Example 1261. Procedural style

Change Language

Seeks to an arbitray row in statement result set (PECL maxdb:1.0-7.6.00.38)
bool maxdb_stmt_data_seek ( resource statement, int offset )