PHP Gets the implementation code for all the tables in the MySQL database

The code is as follows:

function List_tables ($database) {$rs = Mysql_list_tables ($database); $tables = Array (); while ($row = Mysql_fetch_row ($ RS) {$tables [] = $row [0];} Mysql_free_result ($RS); return $tables;}

However, because the Mysql_list_tables method is obsolete, running the above program will give the method outdated hints, as follows:

Deprecated:function mysql_list_tables () is Deprecated in ... on line xxx

One way to do this is to set the error_reporting in php.ini, without displaying the method obsolete prompt information

error_reporting = E_all & ~e_notice & ~e_deprecated

Another option is to use PHP's official recommended alternative:

function List_tables ($database) {$rs = mysql_query ("SHOW tables from $database"), $tables = Array (); while ($row = Mysql_fet Ch_row ($rs)) {$tables [] = $row [0];} Mysql_free_result ($RS); return $tables;}

Related articles:

PHP gets the code for all the table names in the MySQL database

Php method for retrieving table fields from MySQL database

PHP get MySQL database version number Mysql_get_server_info

