PHP lists all tables in MySQL database two methods _php tutorial

PHP Tutorial lists all the tables in the MySQL database tutorial two ways

The PHP code is as follows:

function List_tables ($database)
{
$rs = MySQL Tutorial _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

1 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_fetch_row ($rs)) {
$tables [] = $row [0];
}
Mysql_free_result ($RS);
return $tables;

http://www.bkjia.com/PHPjc/630754.html www.bkjia.com true http://www.bkjia.com/PHPjc/630754.html techarticle PHP Tutorial Lists all the tables in the MySQL database tutorial two ways PHP code is as follows: function List_tables ($database) {$rs = MySQL tutorial _list_tables ($database); $tables = Array (); While ...

