Advertisement
Guest User

Untitled

a guest
Jun 21st, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. <?php
  2. $servername = "";
  3. $username = "";
  4. $password = "";
  5. $dbname = "";
  6.  
  7. // Parsing connnection string
  8. foreach ($_SERVER as $key => $value) {
  9. if (strpos($key, "MYSQLCONNSTR_") !== 0) {
  10. continue;
  11. }
  12. $servername = preg_replace("/^.*Data Source=(.+?);.*$/", "\\1", $value);
  13. $dbname = preg_replace("/^.*Database=(.+?);.*$/", "\\1", $value);
  14. $username = preg_replace("/^.*User Id=(.+?);.*$/", "\\1", $value);
  15. $password = preg_replace("/^.*Password=(.+?)$/", "\\1", $value);
  16. }
  17.  
  18. // Create connection
  19. $conn = new mysqli($servername, $username, $password, $dbname);
  20. // Check connection
  21. if ($conn->connect_error) {
  22. die("Connection failed: " . $conn->connect_error);
  23. } else {
  24. echo "connection successful<br/>";
  25. }
  26. $conn->close();
  27. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement