(No version information available, might only be in Git)
RowResult::getColumns — Get column metadata
Retrieve column metadata for columns present in the result set.
锟斤拷锟斤拷锟斤拷锟斤拷未锟斤拷写锟侥碉拷锟斤拷锟斤拷锟叫诧拷锟斤拷锟叫憋拷
锟剿猴拷锟斤拷没锟叫诧拷锟斤拷锟斤拷
An array of FieldMetadata objects representing the columns in the result,
or FALSE if the result set is empty.
Example #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
)
)