php获取指定库所有表名

最新推荐文章于 2021-03-10 12:32:31 发布

代元培

最新推荐文章于 2021-03-10 12:32:31 发布

阅读量118

点赞数

分类专栏： PHP 文章标签：获取表名

本文链接：https://blog.csdn.net/sosemseo/article/details/110544438

版权

PHP 专栏收录该内容

112 篇文章 2 订阅

订阅专栏

<?php

$hostname = "";
$username = "";
$password = "";
$port = 6666;

$dbname = "db_00";

// 创建连接
$conn = mysqli_connect($hostName, $userName, $password, $dbName, $port);
// 检测连接
if (!$conn) {
    die("连接错误: " . mysqli_connect_error());
}

mysqli_query($conn, "use $dbName");
$sql = "show tables";
$res = mysqli_query($conn, $sql);
$ret = array();
while($row = mysqli_fetch_assoc($res)){
    $ret[] = $row;
}
foreach ($ret as $k=>$v){
    $str = "Tables_in_$dbName";
    $tbName = $v[$str];
    echo $tbName.PHP_EOL;
}

?>