Guest User

Untitled

a guest
Nov 17th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. try {
  2. $dbh= new PDO('mysql:host=serverName;dbname=Mydatabase','user','password');
  3. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  4. }
  5. catch (Exception $e) {
  6. die('Erreur : ' . $e->getMessage());
  7. }
  8.  
  9. var_dump($dbh); // gives : object(PDO)#1 (0) { }
  10.  
  11. $res=$dbh->query('SELECT * FROM table');
  12.  
  13. $res=$dbh->query('SELECT * FROM table');
  14.  
  15. $res=$dbh->query('SELECT * FROM Mydatabase.table');
  16.  
  17. $dbh= new PDO('mysql:host=serverName;dbname=Mydatabase','user','password');
  18.  
  19. $servername = "servername";
  20. $username = "username";
  21. $password = "password";
  22. $dbname = "dbname";
  23.  
  24. try {
  25. $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  26. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  27.  
  28. echo "Connection ok!";
  29. } catch (PDOException $e) {
  30. echo "Err: " . $e->getMessage();
  31. }
  32.  
  33. $conn = null;
Add Comment
Please, Sign In to add comment