PHP Mysql 用PHP查看mysql数据库所有表名

来源:互联网 发布:藤井莉娜淘宝 编辑:程序博客网 时间:2024/05/17 08:57
<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />
<?php 

$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]. "<br/>"; 
$tabelCount++;

}else
{
echo "query result is null";


mysql_free_result($result); 
mysql_close($con)

?>

显示结果如下图:




0 0
原创粉丝点击