Guest User

Untitled

a guest
Dec 6th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.01 KB | None | 0 0
  1. class DataBase {
  2.  
  3. public static $db = null;
  4. public $msqli;
  5.  
  6. public static function getDb() {
  7. if (self::$db == null) {
  8. self::$db = new DataBase();
  9. }
  10. return self::$db;
  11. }
  12.  
  13. private function __construct() {
  14. $this->msqli = mysqli_connect('localhost', 'root', '', 'depsoft');
  15.  
  16. }
  17.  
  18. public function __destruct() {
  19. if ($this->msqli) {
  20. $this->msqli->close();
  21. }
  22. }
  23. }
  24.  
  25. require_once "connect.php";
  26. class DateFormToInsert extends DataBase {
  27.  
  28. public static function dateFromToInsert() {
  29.  
  30. $query_user = mysqli_query($this->msqli, "SELECT * FROM `region_table`");
  31. $data = mysqli_fetch_array($query_user, MYSQLI_ASSOC);
  32. echo "<pre>";
  33. print_r($data);
  34. }
  35. }
  36.  
  37. $aa = DateFormToInsert::getDb();
  38. DateFormToInsert::dateFromToInsert();
  39.  
  40. class DB
  41. {
  42. private static $_instance = null;
  43.  
  44. // для безопасности настройки лучше хранить в файле с конфигом
  45. private static DB_HOST = '';
  46. private static DB_NAME = '';
  47. private static DB_USER = '';
  48. private static DB_PASS = '';
  49.  
  50. private function __construct () {
  51.  
  52. $this->_instance = new PDO(
  53. 'mysql:host=' . self::DB_HOST . ';dbname=' . self::DB_NAME,
  54. self::DB_USER,
  55. self::DB_PASS,
  56. [PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"]
  57. );
  58.  
  59. }
  60.  
  61. private function __clone () {}
  62. private function __wakeup () {}
  63.  
  64. public static function getInstance()
  65. {
  66. if (self::$_instance != null) {
  67. return self::$_instance;
  68. }
  69.  
  70. return new self;
  71. }
  72. }
  73.  
  74.  
  75. require_once "connect.php";
  76. class DateFormToInsert {
  77.  
  78. public static function dateFromToInsert() {
  79.  
  80. $db = DB::getInstance();
  81.  
  82. $query_user = $db->prepare("SELECT * FROM `region_table`")->execute();
  83. $result = $sth->fetchAll();
  84. print_r($result);
  85. }
  86. }
  87.  
  88. $query_user = mysqli_query(Database::getDb(), "SELECT * FROM `region_table`");
Add Comment
Please, Sign In to add comment