Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- How can I get a list of MySQL databases in PHP using PDO?
- show databases
- select schema_name from information_schema.schemata
- // Connect
- ph()->DB('mysql://host.tld/db_name/', 'user', 'pass');
- // Get DBs
- echo '<pre>';
- print_r(ph()->DB('SHOW DATABASES;'));
- echo '</pre>';
- $user = 'root';
- $pass = 'root';
- $server = 'localhost';
- $dbh = new PDO( "mysql:host=$server", $user, $pass );
- $dbs = $dbh->query( 'SHOW DATABASES' );
- while( ( $db = $dbs->fetchColumn( 0 ) ) !== false )
- {
- echo $db.'<br>';
- }
- $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
- $db_list = mysql_list_dbs($link);
- while ($row = mysql_fetch_object($db_list))
- {
- echo $row->Database . "n";
- }
Add Comment
Please, Sign In to add comment