Guest User

Untitled

a guest
Sep 1st, 2018
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. How can I get a list of MySQL databases in PHP using PDO?
  2. show databases
  3.  
  4. select schema_name from information_schema.schemata
  5.  
  6. // Connect
  7. ph()->DB('mysql://host.tld/db_name/', 'user', 'pass');
  8.  
  9. // Get DBs
  10. echo '<pre>';
  11. print_r(ph()->DB('SHOW DATABASES;'));
  12. echo '</pre>';
  13.  
  14. $user = 'root';
  15. $pass = 'root';
  16. $server = 'localhost';
  17.  
  18. $dbh = new PDO( "mysql:host=$server", $user, $pass );
  19. $dbs = $dbh->query( 'SHOW DATABASES' );
  20.  
  21. while( ( $db = $dbs->fetchColumn( 0 ) ) !== false )
  22. {
  23. echo $db.'<br>';
  24. }
  25.  
  26. $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
  27. $db_list = mysql_list_dbs($link);
  28. while ($row = mysql_fetch_object($db_list))
  29. {
  30. echo $row->Database . "n";
  31. }
Add Comment
Please, Sign In to add comment