phpMySQLi手册
mysqli_stmt::data_seek is a method in PHP's MySQLi extension that is used to move the result pointer to a specified row. It allows you to fetch rows from a result set in a non-sequential manner.

Here's a breakdown of how to use mysqli_stmt::data_seek:

1. Prepare a SQL statement using mysqli::prepare and bind any necessary parameters using mysqli_stmt::bind_param.
2. Execute the prepared statement using mysqli_stmt::execute.
3. Bind the result set to variables using mysqli_stmt::bind_result.
4. Use mysqli_stmt::fetch to fetch each row of the result set.
5. After fetching all rows, you can reposition the result pointer to a specific row using mysqli_stmt::data_seek.
- Pass the row number (zero-based index) as a parameter to mysqli_stmt::data_seek.
6. Use mysqli_stmt::fetch again to retrieve the row at the new position.

Here's an example code snippet implementing mysqli_stmt::data_seek:

php
$stmt = $mysqli->prepare("SELECT col1, col2 FROM myTable WHERE condition = ?");
$stmt->bind_param("s", $condition);
$stmt->execute();
$stmt->bind_result($col1, $col2);

// Fetch the rows and process as needed
while ($stmt->fetch()) {
echo $col1 . " - " . $col2 . "\n";
}

// Reposition the result pointer to the second row
$stmt->data_seek(1);

// Fetch the row at the new position
$stmt->fetch();
echo $col1 . " - " . $col2 . "\n";

$stmt->close();


In this example, we fetch rows from the result set in a loop and then use mysqli_stmt::data_seek to move the result pointer to the second row. Finally, we fetch the row at the new position and display its values.