php pdo: get the columns name of a table
fetch, pdo, php
Solution
I solve the problem the following way (MySQL only)
$table_fields = $dbh->query("DESCRIBE tablename")->fetchAll(PDO::FETCH_COLUMN);
Problem
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 ... ) ```