php pdo: get the columns name of a table

Question

How can I get all the column names from a table using PDO?

id         name        age 1          Alan        35       2          Alex        52 3          Amy         15 

The info that I want to get are,

id         name        age 

EDIT:

Here is my attempt,

$db = $connection->get_connection(); $select = $db->query('SELECT * FROM contacts');  $total_column = $select->columnCount(); var_dump($total_column);  for ($counter = 0; $counter < $total_column; $counter ++) {     $meta = $select->getColumnMeta($counter);     $column[] = $meta['name']; } print_r($column); 

Then I get,

Array (     [0] => id     [1] => name     [2] => age     ...  ) 

Answer 1

I solve the problem the following way (MySQL only)

$q = $dbh->prepare("DESCRIBE tablename"); $q->execute(); $table_fields = $q->fetchAll(PDO::FETCH_COLUMN);