Advertisement
Guest User

Untitled

a guest
Nov 28th, 2018
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. <?php
  2.  
  3. class Database {
  4.  
  5. //MySQL username
  6. private $username = 'a204737_main';
  7.  
  8. //MySQL password
  9. private $password = 'Kc52GMFf';
  10.  
  11. //MySQL hostname
  12. private $hostname = 'md33.wedos.net:3306';
  13.  
  14. //MySQL db
  15. private $database = 'd204737_main';
  16.  
  17. //PDO connection
  18. private $pdo;
  19.  
  20. //log - logging exceptions
  21. private $log;
  22.  
  23. //parameters - parameters for MySQL query
  24. private $parameters;
  25.  
  26. //connection to DB
  27. private $isDBConnected = FALSE;
  28.  
  29. //PDO options
  30. private $pdoOptions = array (
  31. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, //set a error reporting and set a throw exception
  32. PDO::ATTR_EMULATE_PREPARES => false //disable emulation of prepared statements
  33. );
  34.  
  35. public function __construct($hostname, $database, $username, $password, $pdoOptions) {
  36.  
  37. $this->dbConn($hostname, $database, $username, $password, $pdoOptions);
  38. $this->parameters = array();
  39.  
  40. }
  41.  
  42. private function dbConn($hostname, $database, $username, $password, $pdoOptions) {
  43.  
  44. $dsn = 'mysql:dbname='.$database.';host='.$hostname;
  45.  
  46. //connect to db and check exceptions
  47. try {
  48. $this->pdo = new PDO($dsn, $username, $password, $pdoOptions);
  49. $this->isDBConnected = TRUE;
  50. }
  51.  
  52. //if any error occurred
  53. catch (Exception $e) {
  54. die ("Connection wasn't established by error: " . $e->getMessage());
  55. }
  56.  
  57. }
  58.  
  59. public function closeConn() {
  60. $this->pdo = null;
  61. }
  62.  
  63. public function getConn() {
  64. return $this->pdo;
  65.  
  66. }
  67.  
  68.  
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement