pdo怎么获取全部字段啊

WBOY
Release: 2016-06-13 12:52:12
Original
910 people have browsed it

pdo如何获取全部字段啊??

本帖最后由 rainxies 于 2013-03-11 13:08:21 编辑 我只找到mysql方法的,用pdo的话,下面的代码该如何写啊?谢谢
<br />
$result = mysql_query("SELECT * FROM table");<br />
$fields = mysql_num_fields($result);<br />
for ($i=0; $i < $fields; $i++) {<br />
   $names[] = mysql_field_name($result, $i);<br />
}<br />
print_r($names);<br />
Copy after login


mysql_num_fields我有找到PDOStatement下面有个columnCount()函数
mysql_field_name我硬是没找到对应的………

还是有另外的办法??


------解决方案--------------------
本帖最后由 xuzuning 于 2013-03-11 13:52:28 编辑

try {<br />
  $dbh = new PDO('mysql:host=localhost;dbname=test', 'root', '');<br />
  $stmt = $dbh->query("select * from tbl_name");<br />
  for($i=0; $i<$stmt->columnCount(); $i++) {<br />
    echo $stmt->getColumnMeta($i)['name'], PHP_EOL;//php5.4适使用,之前的版本需拆成两句<br />
  }<br />
} catch (PDOException $e) {<br />
  die("Error!: " . $e->getMessage());<br />
}
Copy after login
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template