Guest User

Untitled

a guest
Jan 26th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. $connectstr_dbhost = '';
  2. $connectstr_dbname = '';
  3. $connectstr_dbusername = '';
  4. $connectstr_dbpassword = '';
  5.  
  6. foreach ($_SERVER as $key => $value) {
  7. if (strpos($key, "MYSQLCONNSTR_localdb") !== 0) {
  8. continue;
  9. }
  10.  
  11. $connectstr_dbhost = preg_replace("/^.*Data Source=(.+?);.*$/", "\\1", $value);
  12. $connectstr_dbname = preg_replace("/^.*Database=(.+?);.*$/", "\\1", $value);
  13. $connectstr_dbusername = preg_replace("/^.*User Id=(.+?);.*$/", "\\1", $value);
  14. $connectstr_dbpassword = preg_replace("/^.*Password=(.+?)$/", "\\1", $value);
  15. }
  16.  
  17. $link = mysqli_connect($connectstr_dbhost, $connectstr_dbusername, $connectstr_dbpassword,$connectstr_dbname);
  18.  
  19. if (!$link) {
  20. echo "Error: Unable to connect to MySQL." . PHP_EOL;
  21. echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
  22. echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
  23. exit;
  24. }
  25.  
  26. echo "Success: A proper connection to MySQL was made! The my_db database is great." . PHP_EOL;
  27. echo "Host information: " . mysqli_get_host_info($link) . PHP_EOL;
  28.  
  29. mysqli_close($link);
Add Comment
Please, Sign In to add comment