[請益] PHP連MYSQL取得所有資料表名稱
程式碼
$link = mysqli_connect($DB_HOST,$DB_USERNAME,$DB_PASSWORD,$DB_NAME ) or
die("Error " . mysqli_error($link));
$sql = "select Table_name from INFORMATION_SCHEMA.TABLES order by Table_name";
$result = $link->query($sql);
while($row = mysqli_fetch_array($result)) {
echo $row[Table_name] . "<br>";
}
我只想要找到特定資料庫內的所有表我該如何修改呢?
他都會把所有表的名稱跑出來..
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 220.129.48.196
※ 文章網址: https://www.ptt.cc/bbs/PHP/M.1432449775.A.4BD.html
→
05/24 15:49, , 1F
05/24 15:49, 1F
→
05/24 15:52, , 2F
05/24 15:52, 2F
→
05/24 16:37, , 3F
05/24 16:37, 3F
→
05/24 18:49, , 4F
05/24 18:49, 4F
→
05/24 19:42, , 5F
05/24 19:42, 5F
→
05/24 19:42, , 6F
05/24 19:42, 6F