Subversion Repositories PHPX

Rev

Rev 41 | Rev 47 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

1
<?php

require_once __DIR__ . '/Database.php';

class MySQLDB extends Database
{
  /**
   * Database host
   * @var string
   */

  protected $_host;

  /**
  * Database name
  * @var string
  */

  protected $_dbname;

  /**
   * Username to access the database
   * @var string
   */

  protected $_username;

  /**
   * Password to access the database
   * @var string
   */

  protected $_password;

  /**
   * Optional charset parameter value
   * @var string
   */

  protected $_charset = null;

  /**
   * (non-PHPdoc)
   * @see Database::_leftQuote
   */

    protected $_leftQuote = '`';

  /**
   * (non-PHPdoc)
   * @see Database::_rightQuote
   */

  protected $_rightQuote = '`';

  public function __construct()
  {
    $this->_dsn = "mysql:host={$this->_host}"
      . (!is_null($this->_dbname) ? ";dbname={$this->_dbname}" : '')
      . (!is_null($this->_charset) ? ";charset={$this->_charset}" : '');

    if (!is_null($this->_charset))
    {
      $this->_options[PDO::MYSQL_ATTR_INIT_COMMAND] = "SET NAMES " . $this->_charset;
    }

    parent::__construct();
  }

  /**
   * Creates this MySQL database
   *
   * @param string $username = null
   * @param string $password = null
   * @param boolean $force = false
   * @see Database::create()
   */

  public function create ($username = null, $password = null, $force = false)
  {
    return parent::create(
      "mysql:host={$this->_host}"
      . (!is_null($this->_charset) ? ";charset={$this->_charset}" : ''),
      $username, $password, null, $force);
  }
}