Advertisement
Guest User

Untitled

a guest
Feb 26th, 2019
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. <?php
  2.  
  3. $mysql_host='localhost';
  4. $mysql_user='root';
  5. $mysql_password='';
  6. $mysql_db='als';
  7. $con = @mysql_connect($mysql_host,$mysql_user,$mysql_password) or die(mysql_error());
  8. @mysql_select_db($mysql_db) or die(mysql_error());
  9.  
  10. ?>
  11.  
  12. $mysql_host='localhost';
  13. $mysql_user='root';
  14. $mysql_password='';
  15. $mysql_db='als';
  16. $con= mysqli_connect($mysql_host,$mysql_user,$mysql_password, $mysql_db) or die("Error " . mysqli_error($con));
  17.  
  18. <?php
  19. $mysqli = new mysqli('localhost', 'root', '');
  20. if ($mysqli->connect_errno) {
  21. trigger_error('query failed: '.$mysqli->connect_error, E_USER_ERROR);
  22. }
  23.  
  24. $result = $mysqli->query('SHOW databases')
  25. or trigger_error('connect failed: '.join(',', $mysqli->error_list), E_USER_ERROR);
  26.  
  27. foreach( $result as $row ) {
  28. echo join(', ', $row), "<br />rn";
  29. }
  30.  
  31. <?php
  32. $pdo = new PDO('mysql:host=localhost;charset=utf8', 'root', '', array(
  33. PDO::MYSQL_ATTR_DIRECT_QUERY => false,
  34. PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION
  35. ));
  36.  
  37. foreach( $pdo->query('SHOW DATABASES', PDO::FETCH_NUM) as $row ) {
  38. echo $row[0], "<br />rn";
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement