Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
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, 4884👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - Did VB6 support multi-threading ? While VB6 supports multiple single-thre...
Which bit wise operator is suitable for turning off a particular bit in a number? The bitwise AND op...
Why is it preferred to not use finalize for clean up? Problem with finalize is that garbage collecti...
What Is the Difference between Formal Parameters and Actual Parameters? - Oracle DBA FAQ - Creating ...
Describe in detail Basic of SAO architecture of Remoting? For these types of questions interviewer e...