Reply to thread

Message

<blockquote data-quote="SeanRog" data-source="post: 359270" data-attributes="member: 585">Use the same connection trough out the script.Take my database handler as an example:[CODE]/*** @var Database\Connection*/private static $connection;/*** @return Database\Connection*/public static function GetConnection(){&nbsp; &nbsp; if(is_null(self::$connection))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; // Connect to database&nbsp; &nbsp; &nbsp; &nbsp; $credentials = \App\Config\Database::GetAll();&nbsp; &nbsp; &nbsp; &nbsp; self::$connection = new Database\Connection(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $credentials['dsn'],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $credentials['username'],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $credentials['password'],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; isset($credentials['options'])?$credentials['options']:null&nbsp; &nbsp; &nbsp; &nbsp; );&nbsp; &nbsp; &nbsp; &nbsp; // Set exceptions error mode&nbsp; &nbsp; &nbsp; &nbsp; self::$connection-&gt;setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);&nbsp; &nbsp; }&nbsp; &nbsp; return self::$connection;}[/CODE]</blockquote>

[QUOTE="SeanRog, post: 359270, member: 585"] Use the same connection trough out the script. Take my database handler as an example: [CODE] /** * @var Database\Connection */ private static $connection; /** * @return Database\Connection */ public static function GetConnection() { if(is_null(self::$connection)) { // Connect to database $credentials = \App\Config\Database::GetAll(); self::$connection = new Database\Connection( $credentials['dsn'], $credentials['username'], $credentials['password'], isset($credentials['options'])?$credentials['options']:null ); // Set exceptions error mode self::$connection->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION); } return self::$connection; } [/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members