Guest User

Untitled

a guest
Dec 22nd, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. <?php
  2.  
  3. $host = 'HOST'; //Hostname or Server ip
  4. $user = 'USER'; //Database user
  5. $pass = 'PASS'; //Database user password
  6.  
  7. $con = mysql_connect($host,$user,$pass);
  8. if($con){
  9.  
  10. $count = 0;
  11. $sql = "SHOW DATABASES";
  12. $result = mysql_query( $sql, $con);
  13.  
  14. if(mysql_query($sql,$con)){
  15. echo $sql."<br> <br>";
  16. while ($row = mysql_fetch_row($result)) {
  17. echo "DATABASE ".++$count.": {$row[0]}<br>";
  18. $table_name = $row[0];
  19. }
  20. echo "<br>Total No. of DATABASES: " . $count;
  21. }
  22. else{
  23. echo "Error in query.";
  24. }
  25. }
  26. else{
  27. echo "Connection Failed.";
  28. }
  29. ?>
Add Comment
Please, Sign In to add comment