mysqli_stmt::data_seek, mysqli_stmt_data_seek


Description

Object oriented stylevoid mysqli_stmt::data_seek(int offset);

Procedural stylevoid mysqli_stmt_data_seek(mysqli_stmt stmt,
int offset);

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

mysqli_stmt_store_result must be called prior to mysqli_stmt_data_seek.

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 20.148. 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 20.149. 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 examples will output:

City: Benin City Countrycode: NGA

See Also

mysqli_prepare

Retornar