Dutch PHP Conference 2025 - Call For Papers

    mysqli_stmt::data_seek

    mysqli_stmt_data_seek

    (PHP 5, PHP 7, PHP 8)

    mysqli_stmt::data_seek -- mysqli_stmt_data_seek — Adjusts the result pointer to an arbitrary row in the buffered result

    Опис

    Об'єктно-орієнтований стиль

    public mysqli_stmt::data_seek(int $offset): void

    Процедурний стиль

    mysqli_stmt_data_seek(mysqli_stmt $statement, int $offset): void

    This function moves the result set pointer of the buffered result set to an arbitrary row specified by the offset parameter.

    This function works only on the buffered internal result set. mysqli_stmt_store_result() must be called prior to mysqli_stmt_data_seek().

    Параметри

    statement

    Тільки процедурний стиль: об'єкт mysqli_stmt, якого повертає функція mysqli_stmt_init().

    offset

    Must be between zero and the total number of rows minus one (0.. mysqli_stmt_num_rows() - 1).

    Значення, що повертаються

    Не повертає значень.

    Приклади

    Приклад #1 Об'єктно-орієнтований стиль

    <?php

    mysqli_report    (MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
    $mysqli = new mysqli("localhost", "my_user", "my_password", "world");

    $query = "SELECT Name, CountryCode FROM City ORDER BY Name";
    $stmt = $mysqli->prepare($query);
    $stmt->execute();

    $stmt->bind_result($name, $code);

    $stmt->store_result();

    /* seek to row no. 400 */
    $stmt->data_seek(399);

    $stmt->fetch();

    printf("City: %s Countrycode: %s\n", $name, $code);

    Приклад #2 Процедурний стиль

    <?php

    mysqli_report    (MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
    $link = mysqli_connect("localhost", "my_user", "my_password", "world");

    $query = "SELECT Name, CountryCode FROM City ORDER BY Name";
    $stmt = mysqli_prepare($link, $query);

    mysqli_stmt_execute($stmt);

    mysqli_stmt_bind_result($stmt, $name, $code);

    mysqli_stmt_store_result($stmt);

    /* seek to row no. 400 */
    mysqli_stmt_data_seek($stmt, 399);

    mysqli_stmt_fetch($stmt);

    printf("City: %s Countrycode: %s\n", $name, $code);

    Подані вище приклади виведуть:

    City: Benin City  Countrycode: NGA

    Прогляньте також

    Improve This Page

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes 1 note

    up
    1
    phpnet at stuffonmylaptop dot com
    12 years ago
    Although the documentation says you must provide a number between 0 and count - 1, you can actually supply a negative number, which appears to be cast to positive (such as in abs()).

    For example:

    <?php
    $db     = new mysqli('localhost', 'test', 'password', 'schema');
    $db->multi_query("
    SELECT * FROM
    (
    SELECT 1 as 'position'
    UNION SELECT 2 as 'position'
    UNION SELECT 3 as 'position'
    UNION SELECT 4 as 'position'
    UNION SELECT 5 as 'position'
    ) as rows"    );

    $result = $db->store_result();

    for (    $i = 0; $i < $result->num_rows; $i++)
    {
    $offset = $i;
    $result->data_seek($offset);
    var_dump("Seek offset is: {$offset}", $result->fetch_object());
    }

    for (    $i = 0; $i < $result->num_rows; $i++)
    {
    $offset = -$i;
    $result->data_seek($offset);
    var_dump("Seek offset is: {$offset}", $result->fetch_object());
    }
    ＋add a note
    To Top