Home >Backend Development >PHP Tutorial >PHP code to get all table names in mysql database_PHP tutorial
PHP code to get all table names in mysql database_PHP tutorial
- WBOYOriginal
- 2016-07-21 15:30:211036browse
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.
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：In-depth understanding of PHP principles: error suppression and embedded HTML analysis_PHP TutorialNext article：In-depth understanding of PHP principles: error suppression and embedded HTML analysis_PHP Tutorial