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_STMT_DATA_SEEK(3) 1 MYSQLI_STMT_DATA_SEEK(3)mysqli_stmt::data_seek - Seeks to an arbitrary row in statement result set
Object oriented style
SYNOPSIS
void mysqli_stmt::data_seek (int $offset)
DESCRIPTION
Procedural style
void mysqli_stmt_data_seek (mysqli_stmt $stmt, int $offset)
Seeks to an arbitrary result pointer in the statement result set.
mysqli_stmt_store_result(3) must be called prior to mysqli_stmt_data_seek(3).
PARAMETERS
o $
stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
o $offset
- Must be between zero and the total number of rows minus one (0.. mysqli_stmt_num_rows(3) - 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
", 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
", $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
", 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
", $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(3).
PHP Documentation Group MYSQLI_STMT_DATA_SEEK(3)