当前位置:首页  电脑知识  软件

php如何查询mysql表名字

php如何查询mysql表名字

日期:2023-08-14 21:50:45来源:浏览:

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

php如何查询mysql表名字

推荐(免费):php mysql

php查询mysql表名字的方法:

<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)?>

显示结果如下图:

b7f65b3b716185efe8fcf14511de656.png

相关推荐