Advertisement
Guest User

Untitled

a guest
May 7th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.25 KB | None | 0 0
  1. <?php
  2.  
  3. class db
  4. {
  5.    protected $db = null;
  6.    public function __construct($db_type,$db_host,$db_user,$db_pass, $db_name) {
  7.       $this->db = new {$db_type}($db_host, $db_user, $db_pass, $db_name);
  8.    }
  9. }
  10.  
  11. class MYSQL extends database implements idb
  12. {
  13.  
  14.    public function connect() {
  15.      mysql_connect($this->db_host, $this->db_user, $this->db_pass);
  16.      mysql_select_db($this->db_name);
  17.    }
  18.  
  19.    public function fetch_assoc() {
  20.      return mysql_fetch_assoc($this->db_link);
  21.    }
  22.  
  23.    public function query($sql) {
  24.      mysql_query($sql, $this->db_link);
  25.    }
  26. }
  27.  
  28. abstract class database
  29. {
  30.    protected $db_host = null;
  31.    protected $db_user = null;
  32.    protected $db_pass = null;
  33.    protected $db_name = null;
  34.  
  35.    protected $db_link = null;
  36.  
  37.    public function __construct($db_host, $db_user, $db_pass, $db_name) {
  38.      $this->db_host = $db_host;
  39.      $this->db_user = $db_user;
  40.      $this->db_pass = $db_pass;
  41.      $this->db_name = $db_name;
  42.  
  43.      $this->connect();
  44.    }
  45. }
  46.  
  47. interface idb
  48. {
  49.   public function connect();
  50.   public function fetch_assoc();
  51.   public function query($sql);
  52. }
  53.  
  54. // Usage
  55. $db = new db('MYSQL', 'localhost', 'root', '', 'localhost');
  56. $db->query('SELECT * FROM table');
  57. $result = $db->fetch_assoc();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement