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 
}