11111

maxdb_stmt_result_metadata

Пред.

След.

maxdb_stmt_result_metadata

(PECL)maxdb_stmt_result_metadata -- Returns result set metadata from a prepared statement

Description

Procedural style:resource maxdb_stmt_result_metadata (resource stmt)

Object oriented style (method):class stmt {

resource result_metadata (void)

}

- If a statement passed to maxdb_prepare() is one that produces a result set, maxdb_stmt_result_metadata() returns the result resource 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:

maxdb_num_fields()

  • maxdb_fetch_field()
  • maxdb_fetch_field_direct()
  • maxdb_fetch_fields()
  • maxdb_field_count()
  • maxdb_field_seek()
  • maxdb_field_tell()
  • maxdb_free_result()

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

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

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

    - maxdb_stmt_result_metadata() returns a result resource or FALSE if an error occured.

    See also:

    - maxdb_prepare(), maxdb_free_result()

    Example

    Пример 1. Object oriented style

    <?

    $maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");

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

    $maxdb->query("INSERT INTO temp.friends VALUES (1,'Hartmut')");

    $maxdb->query("INSERT INTO temp.friends VALUES (2, 'Ulf')");

    $stmt = $maxdb->prepare("SELECT id, name FROM temp.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*/

    $maxdb->close();

    ?>

    Пример 2. Procedural style

    <?

    $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

    maxdb_query($link, "CREATE TABLE temp.friends (id int, name varchar(20))");

    maxdb_query($link, "INSERT INTO temp.friends VALUES (1,'Hartmut')");

    maxdb_query($link, "INSERT INTO temp.friends VALUES (2, 'Ulf')");

    $stmt = maxdb_prepare($link, "SELECT id, name FROM temp.friends");

    maxdb_stmt_execute($stmt);

    /*get resultset for metadata*/

    $result = maxdb_stmt_result_metadata($stmt);

    /*retrieve field information from metadata result set*/

    $field = maxdb_fetch_field($result);

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

    /*close resultset*/

    maxdb_free_result($result);

    /*close connection*/

    maxdb_close($link);

    ?>

    - The above examples would produce the following output: 
    Fieldname: ID

    Пред.

    Начало

    След.

    maxdb_stmt_reset

    Уровень выше

    maxdb_stmt_send_long_data 22222

    Free Web Hosting