RowResult::getColumns

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

RowResult::getColumnsGet column metadata

Descrição

public mysql_xdevapi\RowResult::getColumns ( void ) : array

Retrieve column metadata for columns present in the result set.

Aviso

Esta função não está documentada; somente a lista de argumentos está disponível.

Parâmetros

Esta função não possui parâmetros.

Valor Retornado

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

Exemplos

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

O exemplo acima irá imprimir algo similar à:

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