|
|
Customer Podcast - City of St. Cloud
|
|
MYSQLI_DATA_SEEK(3) 1 MYSQLI_DATA_SEEK(3) mysqli_result::data_seek - Adjusts the result pointer to an arbitrary row in the result Object oriented style SYNOPSIS
bool mysqli_result::data_seek (int $offset) DESCRIPTION
Procedural style bool mysqli_data_seek (mysqli_result $result, int $offset) The mysqli_data_seek(3) function seeks to an arbitrary result pointer specified by the $offset in the result set. PARAMETERS
o $ result -Procedural style only: A result set identifier returned by mysqli_query(3), mysqli_store_result(3) or mysqli_use_result(3). o $offset - The field offset. Must be between zero and the total number of rows minus one (0..mysqli_num_rows(3) - 1). RETURN VALUES
Returns TRUE on success or FALSE on failure. NOTES
Note This function can only be used with buffered results attained from the use of the mysqli_store_result(3) or mysqli_query(3) func- tions. 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 ", 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 ", $row[0], $row[1]); /* free result set*/ $result->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 (!$link) { printf("Connect failed: %s ", 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 ", $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 SEE ALSO
mysqli_store_result(3), mysqli_fetch_row(3), mysqli_fetch_array(3), mysqli_fetch_assoc(3), mysqli_fetch_object(3), mysqli_query(3), mysqli_num_rows(3). PHP Documentation Group MYSQLI_DATA_SEEK(3)
