mysqli_stmt::data_seek

mysqli_stmt_data_seek

(PHP 5)

mysqli_stmt_data_seek — Seeks to an arbitray row in statement result set

Description

Object oriented style (method):

void mysqli_stmt::data_seek ( int $offset )

Procedural style:

void mysqli_stmt_data_seek ( mysqli_stmt $stmt , int $offset )

Seeks to an arbitrary result pointer in the statement result set.

Parameters

stmt: Procedural style only: A statement identifier returned by mysqli_stmt_init().
offset: Must be between zero and the total number of rows minus one (0.. mysqli_stmt_num_rows() - 1).

Return Values

No value is returned.

Examples

Example #1 Object oriented style


<?php

/* Open a connection */

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");



/* check connection */

if (mysqli_connect_errno()) {

    printf("Connect failed: %s\n", mysqli_connect_error());

    exit();

}



$query = "SELECT Name, CountryCode FROM City ORDER BY Name";

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



    /* execute query */

    $stmt->execute();



    /* bind result variables */

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



    /* store result */

    $stmt->store_result();



    /* seek to row no. 400 */

    $stmt->data_seek(399);



    /* fetch values */

    $stmt->fetch();



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



    /* close statement */

    $stmt->close();

}



/* close connection */

$mysqli->close();

?>

Example #2 Procedural style


<?php

/* Open a connection */

$link = mysqli_connect("localhost", "my_user", "my_password", "world");



/* check connection */

if (mysqli_connect_errno()) {

    printf("Connect failed: %s\n", mysqli_connect_error());

    exit();

}



$query = "SELECT Name, CountryCode FROM City ORDER BY Name";

if ($stmt = mysqli_prepare($link, $query)) {



    /* execute query */

    mysqli_stmt_execute($stmt);



    /* bind result variables */

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



    /* store result */

    mysqli_stmt_store_result($stmt);



    /* seek to row no. 400 */

    mysqli_stmt_data_seek($stmt, 399);



    /* fetch values */

    mysqli_stmt_fetch($stmt);



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



    /* close statement */

    mysqli_stmt_close($stmt);

}



/* close connection */

mysqli_close($link);

?>

The above example will output:

City: Benin City  Countrycode: NGA