Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. require_once 'Config.php';
  2.  
  3. abstract class DB {
  4.  
  5. private static $instance;
  6.  
  7. public static function getInstance() {
  8. if (!isset(self::$instance)) {
  9. try {
  10.  
  11. self::$instance = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USER, DB_PASS);
  12. self::$instance->exec("set names utf8");
  13. self::$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  14. self::$instance->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
  15. } catch (Exception $e) {
  16. echo $e->getMessage();
  17. }
  18. }
  19. return self::$instance;
  20. }
  21.  
  22. public static function prepare($sql) {
  23. return self::getInstance()->prepare($sql);
  24. }
  25.  
  26. public static function closeConnection(){
  27. try {
  28. self::$instance = null;
  29. }
  30. catch (PDOException $e){
  31.  
  32. die($e->getMessage());
  33. }
  34.  
  35. }
  36.  
  37. }
  38.  
  39. <?php
  40. require_once 'DB.php';
  41.  
  42. Class CrudProfissao extends DB {
  43. public function findAll(){}
  44. ...
  45.  
  46. public function __destruct() {
  47. DB::closeConnection();
  48. }
  49.  
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement