11111

mysqli_stmt_result_metadata

Пред.

След.

mysqli_stmt_result_metadata

(PHP 5)mysqli_stmt_result_metadata -- Returns result set metadata from a prepared statement

Description

Procedural style:mysqli_result mysqli_stmt_result_metadata (mysqli_stmt stmt)

Object oriented style (method):class mysqli_stmt {

mysqli_result result_metadata (void)

}

- If a statement passed to mysqli_prepare() is one that produces a result set, mysqli_stmt_result_metadata() returns the result object that can be used to process the meta information such as total number of fields and individual field information.

Замечание: This result set pointer can be passed as an argument to any of the field-based functions that process result set metadata, such as:

mysqli_num_fields()

  • mysqli_fetch_field()
  • mysqli_fetch_field_direct()
  • mysqli_fetch_fields()
  • mysqli_field_count()
  • mysqli_field_seek()
  • mysqli_field_tell()
  • mysqli_free_result()

    • - The result set structure should be freed when you are done with it, which you can do by passing it to mysqli_free_result()

    Замечание: The result set returned by mysqli_stmt_result_metadata() contains only metadata. It does not contain any row results. The rows are obtained by using the statement handle with mysqli_stmt_fetch().

    Возвращаемые значения

    - mysqli_stmt_result_metadata() returns a result object or FALSE if an error occured.

    Смотрите также

    - mysqli_prepare() и mysqli_free_result().

    Примеры

    Пример 1. Object oriented style

    <?

    $mysqli = new mysqli("localhost", "my_user", "my_password", "test");

    $mysqli->query("DROP TABLE IF EXISTS friends");

    $mysqli->query("CREATE TABLE friends (id int, name varchar(20))");

    $mysqli->query("INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");

    $stmt = $mysqli->prepare("SELECT id, name FROM friends");

    $stmt->execute();

    /*get resultset for metadata*/

    $result = $stmt->result_metadata();

    /*retrieve field information from metadata result set*/

    $field = $result->fetch_field();

    printf("Fieldname: %s\n", $field->name);

    /*close resultset*/

    $result->close();

    /*close connection*/

    $mysqli->close();

    ?>

    Пример 2. Procedural style

    <?

    $link = mysqli_connect("localhost", "my_user", "my_password", "test");

    mysqli_query($link, "DROP TABLE IF EXISTS friends");

    mysqli_query($link, "CREATE TABLE friends (id int, name varchar(20))");

    mysqli_query($link, "INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");

    $stmt = mysqli_prepare($link, "SELECT id, name FROM friends");

    mysqli_stmt_execute($stmt);

    /*get resultset for metadata*/

    $result = mysqli_stmt_result_metadata($stmt);

    /*retrieve field information from metadata result set*/

    $field = mysqli_fetch_field($result);

    printf("Fieldname: %s\n", $field->name);

    /*close resultset*/

    mysqli_free_result($result);

    /*close connection*/

    mysqli_close($link);

    ?>

    Пред.

    Начало

    След.

    mysqli_stmt_reset

    Уровень выше

    mysqli_stmt_send_long_data 22222

    Free Web Hosting