Advertisement
Guest User

Untitled

a guest
Nov 17th, 2016
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.11 KB | None | 0 0
  1. How do i turn this..
  2. Server: flsdbserver.database.windows.net,1433 \r\nSQL Database: furmandb\r\nUser Name: gdiadmin\r\n\r\nPHP Data Objects(PDO) Sample Code:\r\n\r\ntry {\r\n   $conn = new PDO ( \"sqlsrv:server = tcp:flsdbserver.database.windows.net,1433; Database = furmandb\", \"gdiadmin\", \"{your_password_here}\");\r\n    $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );\r\n}\r\ncatch ( PDOException $e ) {\r\n   print( \"Error connecting to SQL Server.\" );\r\n   die(print_r($e));\r\n}\r\n\rSQL Server Extension Sample Code:\r\n\r\n$connectionInfo = array(\"UID\" => \"gdiadmin@flsdbserver\", \"pwd\" => \"{your_password_here}\", \"Database\" => \"furmandb\", \"LoginTimeout\" => 30, \"Encrypt\" => 1, \"TrustServerCertificate\" => 0);\r\n$serverName = \"tcp:flsdbserver.database.windows.net,1433\";\r\n$conn = sqlsrv_connect($serverName, $connectionInfo);
  3.  
  4. into this..
  5. // Connection Variables
  6. $servername = "flsdbserver.database.windows.net";
  7. $username = "gdiadmin";
  8. $password = "Carroll@17";
  9. $dbname = "furmandb";
  10.  
  11. // // To this
  12. $conn = mysqli_connect($servername, $username, $password, $dbname);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement