Subversion Repositories PHPX

Rev

Rev 41 | Rev 46 | 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
   *
66
   * @param string $username = null
67
   * @param string $password = null
68
   * @param boolean $force = false
69
   * @see Database::create()
70
   */
71
  public function create ($username = null, $password = null, $force = false)
72
  {
73
    return parent::create(
74
      "mysql:host={$this->_host}"
75
      . (!is_null($this->_charset) ? ";charset={$this->_charset}" : ''),
76
      $username, $password, null, $force);
77
  }
27 PointedEar 78
}