RowResult::getColumns
PHP function
Edit on GitHub ✎
Get column metadata
Description
mysql_xdevapi\RowResult::getColumns(): array
Retrieve column metadata for columns present in the result set.
Func
Parameters Parameters
Return Values
An array of FieldMetadata objects representing the columns in the result, or an empty array if the result set is empty.
Examples
mysql_xdevapi\RowResult::getColumns() example
php
<?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);The above example will output something similar to:
output
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
)
)