Guest User

Untitled

a guest
Feb 6th, 2019
102
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.  
  3. $host='localhost';
  4. $db='canda';
  5. $user='root';
  6. $pass='123456789';
  7.  
  8. try{
  9. new PDO("mysql:host=".$host
  10. ."; dbname=".$db,
  11. $user, $pass);
  12. }catch (PDOException $e) {
  13. echo $e;
  14. }
  15.  
  16. $host = DB_HOST; // just ignore constants //
  17. $user = DB_USER;
  18. $pass = DB_PASS;
  19. $dbname = DB_NAME;
  20.  
  21. $dsn = 'mysql:host=' . $host . ';dbname=' . $dbname;
  22. // Set options
  23. $options = array(
  24. PDO::ATTR_PERSISTENT => true,
  25. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
  26. );
  27. // Create a new PDO instanace
  28. try{
  29. $this->dbh = new PDO($dsn, $user, $pass, $options);
  30. }
  31. // Catch any errors
  32. catch(PDOException $e){
  33. $this->error = $e->getMessage();
  34. }
Add Comment
Please, Sign In to add comment