PHP : Function Reference : PDO Functions : PDOStatement->getColumnMeta() PHP Examples Tutorials References

Example 1790. Retrieving column metadata

The following example shows the results of retrieving the metadata for a single column generated by a function (COUNT) in a PDO_SQLITE driver.

copy to clipboard

<?php

$select = $DB->query('SELECT COUNT(*) FROM fruit');
$meta = $select->getColumnMeta(0);
var_dump($meta);
?>

The above example will output:

copy to clipboard

array(6) {

  ["native_type"]=>

  string(7) "integer"

  ["flags"]=>

  array(0) {

  }

  ["name"]=>

  string(8) "COUNT(*)"

  ["len"]=>

  int(-1)

  ["precision"]=>

  int(0)

  ["pdo_type"]=>

  int(2)

}

PDOStatement->getColumnMeta()

Returns metadata for a column in a result set ()

Example 1790. Retrieving column metadata

Change Language