MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
mysqli_result::data_seek
mysqli_data_seek
Adjusts the result pointer to an arbitrary row in the result
Object oriented style
public bool mysqli_result::data_seek(int offset);
Procedural style
bool mysqli_data_seek(mysqli_result result,
int offset);
The
mysqli_data_seek
function seeks to an arbitrary result pointer specified by the
offset
in the result set.
result
Procedural style only: A result set identifier returned
by
mysqli_query
,
mysqli_store_result
or
mysqli_use_result
.
offset
The field offset. Must be between zero and the total
number of rows minus one
(0..mysqli_num_rows
- 1).
Returns true
on success or
false
on failure.
This function can only be used with buffered results attained
from the use of the
mysqli_store_result
or
mysqli_query
functions.
Example 3.107 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 ($result = $mysqli->query($query)) { /* seek to row no. 400 */ $result->data_seek(399); /* fetch row */ $row = $result->fetch_row(); printf ("City: %s Countrycode: %s\n", $row[0], $row[1]); /* free result set*/ $result->close(); } /* close connection */ $mysqli->close(); ?>
Example 3.108 Procedural style
<?php /* Open a connection */ $link = mysqli_connect("localhost", "my_user", "my_password", "world"); /* check connection */ if (!$link) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $query = "SELECT Name, CountryCode FROM City ORDER BY Name"; if ($result = mysqli_query($link, $query)) { /* seek to row no. 400 */ mysqli_data_seek($result, 399); /* fetch row */ $row = mysqli_fetch_row($result); printf ("City: %s Countrycode: %s\n", $row[0], $row[1]); /* free result set*/ mysqli_free_result($result); } /* close connection */ mysqli_close($link); ?>
The above examples will output:
City: Benin City Countrycode: NGA
mysqli_store_result
|
mysqli_fetch_row
|
mysqli_fetch_array
|
mysqli_fetch_assoc
|
mysqli_fetch_object
|
mysqli_query
|
mysqli_num_rows
|