A preliminary understanding of PHP's function to obtain database table information_PHP tutorial

When we use

PHP to obtain database table information function mysql_list_dbs()

resource mysql_list_dbs([resource link_id] )
Get the names of all databases on the server.

Example:

1. mysql_connect("localhost", "name","pwd");
2. $dbs = mysql_list_dbs();
3. while (list($db) = mysql_fetch_row(dbs)) {
4. echo "$db <br>";
5. }

Note that the output results are related to the user permissions used.

One of the PHP functions to obtain database table information mysql_db_name()

string mysql_db_name(resource result_set, interger index)
Get the database name at index in the result_set returned by mysql_list_dbs().

PHP Get database table information function mysql_list_tables()

resource mysql_list_tables(string database [,resource link_id])
Get all table names in the database.

PHP Get database table information function mysql_tablename()

string mysql_tablename(resource result_set, interger index)
Get the table name at index in the result_set returned by mysql_list_tables().