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
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
Latest Articles by Author
-
2024-10-22 09:46:29
-
2024-10-13 13:53:41
-
2024-10-12 12:15:51
-
2024-10-11 22:47:31
-
2024-10-11 19:36:51
-
2024-10-11 15:50:41
-
2024-10-11 15:07:41
-
2024-10-11 14:21:21
-
2024-10-11 12:59:11
-
2024-10-11 12:17:31