php mysql 中文表名_php如何查询mysql表名字

php查询mysql表名字的方法：首先连接服务器，代码为【die("Connection failed: " . mysql..】；然后选择数据库，代码为【while($row = mysql_fetch_array($result))】。

php查询mysql表名字的方法：

$servername = "sdm163155241.com";

$username = "sdm1655241";

$password = "1746aaa;

// 连接服务器

$con = mysql_connect($servername, $username, $password);

if (!$con)

{

die("Connection failed: " . mysql_error());

}

// 选择数据库

$dbName = "sdm1631efee_db";

$db_selected = mysql_select_db($dbName, $con);

if (!$db_selected)

{

die ("Can\'t DB sdm163155241_db : " . mysql_error());

}

$tabelCount = 1;

$result = mysql_query("SHOW TABLES");

if($result)

{

while($row = mysql_fetch_array($result))

{

echo $tabelCount.": ".$row[0]. "
";

$tabelCount++;

}

}else

{

echo "query result is null";

}

mysql_free_result($result);

mysql_close($con)

?>

显示结果如下图：