Subversion Repositories PHPX

Rev

Rev 51 | Rev 58 | 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 
 
51 PointedEar 3 
namespace PointedEars\PHPX\Db;
4 
 
27 PointedEar 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 
  {
47 PointedEar 51 
        $this->readConfig();
51 PointedEar 52 
 
27 PointedEar 53 
    $this->_dsn = "mysql:host={$this->_host}"
54 
      . (!is_null($this->_dbname) ? ";dbname={$this->_dbname}" : '')
55 
      . (!is_null($this->_charset) ? ";charset={$this->_charset}" : '');
41 PointedEar 56 
 
27 PointedEar 57 
    if (!is_null($this->_charset))
58 
    {
51 PointedEar 59 
      $this->_options[\PDO::MYSQL_ATTR_INIT_COMMAND] = "SET NAMES " . $this->_charset;
27 PointedEar 60 
    }
41 PointedEar 61 
 
27 PointedEar 62 
    parent::__construct();
63 
  }
44 PointedEar 64 
 
65 
  /**
66 
   * Creates this MySQL database
67 
   *
46 PointedEar 68 
   * @param string $dsn
69 
   *   Ignored.  Required for strict compatibility only.
44 PointedEar 70 
   * @param string $username = null
71 
   * @param string $password = null
46 PointedEar 72 
   * @param array? $options = null
73 
   *   Ignored.  Required for strict compatibility only.
74 
   * @param string $dbspec = null
75 
   *   Currently ignored.
44 PointedEar 76 
   * @param boolean $force = false
77 
   * @see Database::create()
78 
   */
46 PointedEar 79 
  public function create ($dsn, $username = null, $password = null,
80 
    array $options = null, $dbspec = null, $force = false)
44 PointedEar 81 
  {
82 
    return parent::create(
83 
      "mysql:host={$this->_host}"
84 
      . (!is_null($this->_charset) ? ";charset={$this->_charset}" : ''),
85 
      $username, $password, null, $force);
86 
  }
27 PointedEar 87 
}