php pdo:获取表的列名 [英] php pdo: get the columns name of a table

问题描述

如何使用PDO从表中获取所有列名?

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

我想获取的信息是

id         name        age

这是我的尝试，

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

然后我得到

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

)

推荐答案

我通过以下方式解决此问题(仅适用于MySQL)

I solve the problem the following way (MySQL only)

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

这篇关于php pdo:获取表的列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！