有沒有人知道為什么我只列印出帶有此代碼的第一列
stmt = $db->prepare('SELECT column_name
FROM information_schema.columns
WHERE table_name = "players"
AND table_schema = "hmanager" ');
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
echo var_dump($row);
foreach ($row as $colnanme) {
echo "$colnanme<br>";
}
uj5u.com熱心網友回復：
您必須$stmt->fetch在 while 回圈中運行以顯示所有列。
<?php
$stmt = $db->prepare("SELECT column_name FROM
information_schema.columns
WHERE table_name = 'players'
AND table_schema = 'hmanager' ");
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo $row['column_name']. "</br>";
}
?>
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/393645.html
上一篇：為什么我收到#1264-第1行“Identity_no”列的值超出范圍？
下一篇：陣列PDO到MYSQL