WebSVN - PHPX - Diff - Rev 51 and 52


<?php

namespace PointedEars\PHPX\Db;

 
 
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->readConfig();

    $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 $dsn
   *   Ignored.  Required for strict compatibility only.
   * @param string $username = null
   * @param string $password = null
   * @param array? $options = null
   *   Ignored.  Required for strict compatibility only.
   * @param string $dbspec = null
   *   Currently ignored.
   * @param boolean $force = false
   * @see Database::create()
   */
  public function create ($dsn, $username = null, $password = null,
    array $options = null, $dbspec = null, $force = false)
  {
    return parent::create(
      "mysql:host={$this->_host}"
      . (!is_null($this->_charset) ? ";charset={$this->_charset}" : ''),
      $username, $password, null, $force);
  }
}

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

Subversion Repositories PHPX

(root)/trunk/Db/MySQLDB.php @ 58 - Rev 51 → 52