Phpmysql obtains the names of all tables in the specified database. Php Tutorial mysql tutorial obtain all table names of a specified database tutorial if you want to display a table name of a specified database in mysql, the method is very simple. mysql provides a showtables command, it returns the php Tutorial mysql tutorial to get the names of all tables in the specified database tutorial.
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 the detailed instance I 've made and it is fully available after testing.
*/
$ Cn = mysql_connect ('localhost', 'root', 'root ');
Mysql_select_db ('test', $ cn );
Print_r (get_tables ());
/* Output result
Array
(
[0] => abc
[1] => cn_user
[2] => test1
)
*/
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;
}
// This site original tutorials reprinted indicated from http://www.bKjia. c0m retention connection address, otherwise it will be investigated!
?>
Mysql Tutorial: getting the names of all tables in a specified database tutorial. if you want to display the names of tables in a specified database in mysql, the method is very simple. mysql provides a show tables command, which returns...