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.

警告

本函數(shù)還未編寫文檔，僅有參數(shù)列表。

參數(shù)

此函數(shù)沒有參數(shù)。

返回值

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