RowResult::getColumns

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

    RowResult::getColumns — Get column metadata

    Descripción

    publicmysql_xdevapi\RowResult::getColumns(): array

    Retrieve column metadata for columns present in the result set.

    Advertencia

    Esta función no está documentada actualmente, solamente se encuentra disponible la lista de parámetros.

    Parámetros

    Esta función no tiene parámetros.

    Valores devueltos

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

    Ejemplos

    Ejemplo #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);

    El resultado del ejemplo sería algo similar a:

    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 ) )
    To Top