Rev 44 | Rev 47 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed
Rev | Author | Line No. | Line |
---|---|---|---|
27 | PointedEar | 1 | <?php |
2 | |||
29 | PointedEar | 3 | require_once __DIR__ . '/Database.php'; |
27 | PointedEar | 4 | |
5 | class MySQLDB extends Database |
||
6 | { |
||
7 | /** |
||
8 | * Database host |
||
9 | * @var string |
||
10 | */ |
||
11 | protected $_host; |
||
41 | PointedEar | 12 | |
27 | PointedEar | 13 | /** |
14 | * Database name |
||
15 | * @var string |
||
16 | */ |
||
17 | protected $_dbname; |
||
41 | PointedEar | 18 | |
27 | PointedEar | 19 | /** |
20 | * Username to access the database |
||
21 | * @var string |
||
22 | */ |
||
23 | protected $_username; |
||
41 | PointedEar | 24 | |
27 | PointedEar | 25 | /** |
26 | * Password to access the database |
||
27 | * @var string |
||
28 | */ |
||
29 | protected $_password; |
||
41 | PointedEar | 30 | |
31 | /** |
||
27 | PointedEar | 32 | * Optional charset parameter value |
41 | PointedEar | 33 | * @var string |
27 | PointedEar | 34 | */ |
35 | protected $_charset = null; |
||
41 | PointedEar | 36 | |
32 | PointedEar | 37 | /** |
38 | * (non-PHPdoc) |
||
39 | * @see Database::_leftQuote |
||
40 | */ |
||
41 | protected $_leftQuote = '`'; |
||
41 | PointedEar | 42 | |
32 | PointedEar | 43 | /** |
44 | * (non-PHPdoc) |
||
45 | * @see Database::_rightQuote |
||
46 | */ |
||
47 | protected $_rightQuote = '`'; |
||
41 | PointedEar | 48 | |
27 | PointedEar | 49 | public function __construct() |
50 | { |
||
51 | $this->_dsn = "mysql:host={$this->_host}" |
||
52 | . (!is_null($this->_dbname) ? ";dbname={$this->_dbname}" : '') |
||
53 | . (!is_null($this->_charset) ? ";charset={$this->_charset}" : ''); |
||
41 | PointedEar | 54 | |
27 | PointedEar | 55 | if (!is_null($this->_charset)) |
56 | { |
||
57 | $this->_options[PDO::MYSQL_ATTR_INIT_COMMAND] = "SET NAMES " . $this->_charset; |
||
58 | } |
||
41 | PointedEar | 59 | |
27 | PointedEar | 60 | parent::__construct(); |
61 | } |
||
44 | PointedEar | 62 | |
63 | /** |
||
64 | * Creates this MySQL database |
||
65 | * |
||
46 | PointedEar | 66 | * @param string $dsn |
67 | * Ignored. Required for strict compatibility only. |
||
44 | PointedEar | 68 | * @param string $username = null |
69 | * @param string $password = null |
||
46 | PointedEar | 70 | * @param array? $options = null |
71 | * Ignored. Required for strict compatibility only. |
||
72 | * @param string $dbspec = null |
||
73 | * Currently ignored. |
||
44 | PointedEar | 74 | * @param boolean $force = false |
75 | * @see Database::create() |
||
76 | */ |
||
46 | PointedEar | 77 | public function create ($dsn, $username = null, $password = null, |
78 | array $options = null, $dbspec = null, $force = false) |
||
44 | PointedEar | 79 | { |
80 | return parent::create( |
||
81 | "mysql:host={$this->_host}" |
||
82 | . (!is_null($this->_charset) ? ";charset={$this->_charset}" : ''), |
||
83 | $username, $password, null, $force); |
||
84 | } |
||
27 | PointedEar | 85 | } |