RowResult::getColumns

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

RowResult::getColumnsGet column metadata

Opis

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

Retrieve column metadata for columns present in the result set.

Ostrzeżenie

Ta funkcja jest obecnie nieudokumentowana, dostępna jest jedynie lista jej argumentów.

Parametry

Ta funkcja nie posiada parametrów.

Zwracane wartości

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

Przykłady

Przykład #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);

Powyższy przykład wyświetli coś podobnego do:

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