- PHP 手册
- 函数参考
- 数据库扩展
- 针对各数据库系统对应的扩展
- MySQL
- Mysql_xdevapi
- mysql_xdevapi\RowResult
RowResult::getColumns
(No version information available, might only be in Git)
RowResult::getColumns — Get column metadata
说明
public mysql_xdevapi\RowResult::getColumns(): arrayRetrieve column metadata for columns present in the result set.
警告本函数还未编写文档，仅有参数列表。
参数
此函数没有参数。
返回值
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
)
)
User Contributed Notes
There are no user contributed notes for this page.官方地址：https://www.php.net/manual/en/mysql-xdevapi-rowresult.getcolumns.php