Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 346501" data-attributes="member: 36373">Found this example that might help you out![CODE]namespacePersistence\Connection\Config;interfacePDOConfig{publicfunction getDSN();publicfunction getUsername();publicfunction getPassword();publicfunction getDriverOptions();}classMySqlConfigimplementsPDOConfig{private $username;private $password;private $db;private $host ='localhost';private $charset ='utf8';publicfunction __construct($username, $password, $db){$this-&gt;username = $username;$this-&gt;password = $password;$this-&gt;db = $db;}// getters and setters, etcpublicfunction getDSN(){return sprintf('mysql:host=%s;dbname=%s;charset=%s',$this-&gt;host, $this-&gt;db, $this-&gt;charset);}publicfunction getDriverOptions(){return[PDO::ATTR_ERRMODE =&gt; PDO::ERRMODE_EXCEPTION,PDO::ATTR_EMULATE_PREPARES =&gt;false,PDO::ATTR_DEFAULT_FETCH_MODE =&gt; PDO::FETCH_ASSOC];}}namespacePersistence\Connection;usePersistence\Connection\Config\PDOConfig;classRegistry{privatestatic $connection;privatestatic $config;publicstaticfunction setConfig(PDOConfig $config){self::$config = $config;}publicstatic getConnection(){if(self::$connection ===null){if(self::$config ===null){thrownewRuntimeException('No config set, cannot create connection');}$config =self::$config;self::$connection =new \PDO($config-&gt;getDSN(), $config-&gt;getUsername(),$config-&gt;getPassword(), $config-&gt;getDriverOptions());}returnself::$connection;}}[/CODE]Then, at some point (early) in your application execution cycle[CODE]usePersistence\Connection\Config\MySqlConfig;usePersistence\Connection\Registry;$config =newMySqlConfig('username','password','dbname');Registry::setConfig($config);[/CODE]Then, you can useRegistry::getConnection();anywhere in your code to retrieve the PDO instance.Source:<a href="http://stackoverflow.com/questions/19848384/php-pdo-instance-as-private-static-property" target="_blank"> Here</a></blockquote>

[QUOTE="JayC, post: 346501, member: 36373"] Found this example that might help you out! [CODE] namespacePersistence\Connection\Config; interfacePDOConfig{publicfunction getDSN();publicfunction getUsername();publicfunction getPassword();publicfunction getDriverOptions();} classMySqlConfigimplementsPDOConfig{private $username;private $password;private $db;private $host ='localhost';private $charset ='utf8'; publicfunction __construct($username, $password, $db){ $this->username = $username; $this->password = $password; $this->db = $db;} // getters and setters, etc publicfunction getDSN(){return sprintf('mysql:host=%s;dbname=%s;charset=%s', $this->host, $this->db, $this->charset);} publicfunction getDriverOptions(){return[ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_EMULATE_PREPARES =>false, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC ];}} namespacePersistence\Connection; usePersistence\Connection\Config\PDOConfig; classRegistry{privatestatic $connection;privatestatic $config; publicstaticfunction setConfig(PDOConfig $config){self::$config = $config;} publicstatic getConnection(){if(self::$connection ===null){if(self::$config ===null){thrownewRuntimeException('No config set, cannot create connection');} $config =self::$config;self::$connection =new \PDO($config->getDSN(), $config->getUsername(), $config->getPassword(), $config->getDriverOptions());}returnself::$connection;}} [/CODE] Then, at some point (early) in your application execution cycle [CODE] usePersistence\Connection\Config\MySqlConfig;usePersistence\Connection\Registry; $config =newMySqlConfig('username','password','dbname');Registry::setConfig($config); [/CODE] Then, you can use Registry::getConnection(); anywhere in your code to retrieve the PDO instance. Source:[URL='http://stackoverflow.com/questions/19848384/php-pdo-instance-as-private-static-property'] Here[/URL] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members