Hear Howard DeYoung- Director of Information Technology for City of St. Cloud describe the experience of innovating cyberspots in his city with the HPBladeSystem solutions
A Tribute to India
For our Indian members, please let us know in the poll what city you live (or work)?
Mumbai (Bombay)
Delhi
Kolkata (Calcutta)
Chennai (Madras)
Bangalore
Hyderabad
Pune
Ahmedabad
Kanpur
Surat
Other (Please Tell Us in Post and Write in Poll, Thanks!)
Don't Live in... (32 Replies)
Tim Bass
Thu, 15 Nov 2007 23:55:07 +0000
*I predict we may experience less*debates*on the use of the term “event cloud”*related to*CEP in the future, now that both IBM and Google* have made announcements about “cloud computing” and “computing cloud”, IBM Turning Data Centers Into ‘Computing... (0 Replies)
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)