Edit Report a Bug

    RowResult::getColumns

    (No version information available, might only be in Git)

    RowResult::getColumns — Get column metadata

    说明

    public mysql_xdevapi\RowResult::getColumns(): array

    Retrieve column metadata for columns present in the result set.

    警告

    本函数还未编写文档，仅有参数列表。

    参数

    此函数没有参数。

    返回值

    An array of FieldMetadata objects representing the columns in the result, or an empty array if the result set is empty.

    示例

    示例 #1 mysql_xdevapi\RowResult::getColumns() example

    <?php
    $session     = mysql_xdevapi\getSession("mysqlx://user:password@localhost");

    $session->sql("DROP DATABASE addressbook")->execute();
    $session->sql("CREATE DATABASE foo")->execute();
    $session->sql("CREATE TABLE foo.test_table(x int)")->execute();
    $session->sql("INSERT INTO addressbook.names values ('John', 42), ('Sam', 33)")->execute();

    $sql = $session->sql("SELECT * from addressbook.names")->execute();

    $cols = $sql->getColumns();

    print_r($cols);

    以上示例的输出类似于：

    Array
(
    [0] => mysql_xdevapi\FieldMetadata Object
        (
            [type] => 7
            [type_name] => BYTES
            [name] => name
            [original_name] => name
            [table] => names
            [original_table] => names
            [schema] => addressbook
            [catalog] => def
            [collation] => 255
            [fractional_digits] => 0
            [length] => 65535
            [flags] => 0
            [content_type] => 0
        )
    [1] => mysql_xdevapi\FieldMetadata Object
        (
            [type] => 1
            [type_name] => SINT
            [name] => age
            [original_name] => age
            [table] => names
            [original_table] => names
            [schema] => addressbook
            [catalog] => def
            [collation] => 0
            [fractional_digits] => 0
            [length] => 11
            [flags] => 0
            [content_type] => 0
        )
)
    add a note add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top