Detailed analysis PHP get all database methods _php Tutorial

In

To query which databases exist in the system, you can use the Mysql_list_dbs () function, which has the following syntax format:

Resource Mysql_list_dbs ([Resource $link _identifier])

The result set returned by the Mysql_list_dbs () function contains all the databases in the MySQL server, and PHP obtains all the database examples as follows:

2. < ? PHP
4. $ Connection = mysql_connect ("localhost", "root"
   , "root") or Die ("Connection Server failed");
6. $ db_list = Mysql_list_dbs ($connection);
8. While ($row = mysql_fetch_object
   ($db _list)) {
10. Echo $row- > Database. "< br>";
12. echo " < hr>";
14. }
16. Mysql_close ($connection);
18. ?>

In the above PHP get all the database code, the loop output result set used the Mysql_fetch_object () function, mysql_fetch_object () function and mysql_fetch_array () function usage similar, different is Mysql_ The Fetch_array () function returns an array, and the Mysql_fetch_object () function returns an object. The syntax format for the mysql_fetch_object () function is as follows:

Object Mysql_fetch_object (Resource $result)

http://www.bkjia.com/PHPjc/445933.html www.bkjia.com true http://www.bkjia.com/PHPjc/445933.html techarticle in order to query which databases exist in the system, you can use the Mysql_list_dbs () function, which has the following syntax: Resource Mysql_list_dbs ([Resource $link _identifier]) mysql_list _dbs ( ...

