PHP code to get all table names in mysql database_PHP tutorial

Copy code The code is as follows:

$server = 'localhost';
$user = 'root';
$ pass = '';
$dbname = 'dayanmei_com';
$conn = mysql_connect($server,$user,$pass);
if(!$conn) die("Database system connection failed! ");
mysql_select_db($dbname) or die("Database connection failed!");
$result = mysql_query("SHOW TABLES");
while($row = mysql_fetch_array($result))
{
echo $row[0]."";
}
mysql_free_result($result);

Note the function of all table names in the list mysql in php mysql_list_tables has been deleted. It is recommended not to use this function to list mysql data tables.

http://www.bkjia.com/PHPjc/323245.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/323245.htmlTechArticleCopy the code as follows: $server = 'localhost'; $user = 'root'; $pass = '' ; $dbname = 'dayanmei_com'; $conn = mysql_connect($server,$user,$pass); if(!$conn) die("Database system connection...