PHPMySQL obtains the names of all tables in the specified database.

To display the table name of a specified database in mysql, the method is very simple. mysql provides a showtables command, which returns a data. Let's take a look at my details.

To display a table name of a specified database in mysql, the method is very simple. mysql provides a show tables command, which returns a piece of data. Let's take a look at my details.

To display a table name of a specified database in mysql, the method is simple. mysql provides a show tables command, which returns a data. Let's take a look at my detailed instance, fully available after testing
*/

$ Cn = mysql_connect ('localhost', 'root', 'root ');
Mysql_select_db ('test', $ cn );
Print_r (get_tables ());

Function get_tables () // obtain the names of all tables
{
$ Tables = array ();
$ R = fetch_all ("show tables ");
Foreach ($ r as $ v)
{
Foreach ($ v as $ v _)
{
$ Tables [] = $ v _;
}
}
Return $ tables;
}

Function fetch_all ($ SQL)
{
$ Rs = mysql_query ($ SQL );
$ Result = array ();
While ($ rows = mysql_fetch_array ($ rs, mysql_assoc ))
{
$ Result [] = $ rows;
}

Return $ result;

}

// Reprinted with the source retained connection address!
?>