Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Get a List of Databases from MySQL Servers
How To Get a List of Databases from MySQL Servers? - MySQL FAQs - PHP Connections and Query Execution
✍: FYIcenter.com
Once you got a MySQL server connection object successfully, you need to know what databases are available on the server and which database you should use to manage your tables and data. To get a list of all available databases on your MySQL server, you can use the mysql_list_dbs() function. Note mysql_list_dbs() will not return an array of database names. It returns a result object, which requires mysql_fetch_object() call to loop through each database object.
The tutorial exercise below shows you a good example of how to get a list of databases as a result object. Then "while" loop is used to fetch each database object from the result object. Finally, an object property "$obj->Database" is used to get the database name:
<?php
$con = mysql_connect('localhost:8888', 'dev', 'iyf');
print("List of databases:\n");
$res = mysql_list_dbs($con);
while ($obj = mysql_fetch_object($res)) {
print($obj->Database . "\n");
}
mysql_close($con);
?>
If you run this script, you will get something like this:
List of databases: information_schema mysql test
2007-05-10, 6280👍, 0💬
Popular Posts:
How To Get the Minimum or Maximum Value of an Array? - PHP Script Tips - PHP Built-in Functions for ...
What are urlencode() and urldecode() functions in PHP? string urlencode(str) - Returns the URL encod...
How To Avoid the Undefined Index Error? - PHP Script Tips - Processing Web Forms If you don't want y...
Can you explain what is “AutoPostBack” feature in ASP.NET ? If we want the control to automatically ...
what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...