Guest User

Untitled

a guest
Sep 8th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. start work with PHP OOP
  2. <?php
  3. //Config
  4. $db_user = 'root';
  5. $db_pass = '';
  6. $db_host = 'localhost';
  7. $db_name = 'test';
  8.  
  9. class Database
  10. {
  11. private $Database;
  12. private static $instance;
  13.  
  14. public static function instance()
  15. {
  16. if ( !self::$instance )
  17. self::$instance = new Database();
  18. return self::$instance;
  19. }
  20.  
  21. public function connect($host, $user, $password, $name)
  22. {
  23. $this->db_link = mysql_connect($host, $user, $password);
  24. mysql_set_charset('utf8');
  25. mysql_select_db($name, $this->db_link);
  26. }
  27.  
  28. public function query($quory)
  29. {
  30. $sql = mysql_query($quory);
  31. $row = mysql_fetch_array($sql);
  32.  
  33. return $row;
  34. }
  35. }
  36.  
  37. class Book extends Database
  38. {
  39. public function getData2()
  40. {
  41. $sql = $this->query('SELECT * FROM users WHERE price = "7"');
  42. return $sql['name'];
  43. }
  44. }
  45.  
  46. $db = Database::instance();
  47. $db->connect($db_host, $db_user, $db_pass, $db_name);
  48.  
  49. $b = new Book();
  50. $res = $b->getData2();
  51. print_r($res);
  52.  
  53. ?>
  54.  
  55. $myDb = new dbLayer($settings);
  56.  
  57. $myBook = new book($myDb);
  58.  
  59. $a = $myBook->getAllData($someParameter);
  60.  
  61. in the constructor of book you save the reference to the dblayer...
  62.  
  63. class book {
  64. var $dbTier;
  65. __constructor($db) {
  66. $this->dbTier = $db;
  67. ...
  68.  
  69. class Book
  70. {
  71. var $db;
  72.  
  73. function __construct() {
  74. $this->db = Database::instance();
  75. }
  76. }
Add Comment
Please, Sign In to add comment