Please wait while we load your page...

PasswordSentry

Latest Version [8.00202205221] Last Updated [May-22-2022]

Tools

PHP Manual [RowResult

Protect Your Website Today


PHP Manual || mysql_xdevapi\RowResult

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

RowResult::getColumnsGet column metadata

Description

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

Retrieve column metadata for columns present in the result set.

Warning

This function is currently not documented; only its argument list is available.

Parameters

This function has no 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

Example #1 mysql_xdevapi\RowResult::getColumns() example

<?php
$session 
mysql_xdevapi\getSession("mysqlx://user:[email protected]");

$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:

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


PHP Manual || mysql_xdevapi\RowResult