Home > Backend Development > PHP Tutorial > pdo如何获取全部字段啊

pdo如何获取全部字段啊

WBOY
Release: 2016-06-23 14:02:28
Original
1390 people have browsed it

我只找到mysql方法的,用pdo的话,下面的代码该如何写啊?谢谢

$result = mysql_query("SELECT * FROM table");$fields = mysql_num_fields($result);for ($i=0; $i < $fields; $i++) {   $names[] = mysql_field_name($result, $i);}print_r($names);
Copy after login


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

还是有另外的办法??


回复讨论(解决方案)

try {  $dbh = new PDO('mysql:host=localhost;dbname=test', 'root', '');  $stmt = $dbh->query("select * from tbl_name");  for($i=0; $i<$stmt->columnCount(); $i++) {    echo $stmt->getColumnMeta($i)['name'], PHP_EOL;//php5.4适使用,之前的版本需拆成两句  }} catch (PDOException $e) {  die("Error!: " . $e->getMessage());}
Copy after login

$sqlstr="select * from table"

$sqlstr="select * from table"

$sqlstr="select * from table";  $rerult=mysql_quer($sqlstr);  while($field=mysql_fetch_field($result){      echo "$field->name";}

谢谢版主,终于搞定了,php实在不熟!!!

本帖最后由 xuzuning 于 2013-03-11 13:52:28 编辑
            PHP code?123456789try {  $dbh = new PDO('mysql:host=localhost;dbname=test', 'root', '');  $stmt = $dbh->query("select * from tbl_na……

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