Changeset 810 for trunk/lib/PDO.inc.php

Timestamp:

Mar 4, 2024 12:30:57 AM (2 months ago)

Author:

anonymous

Message:

Enable setting db_timezone during runtime. Refactor setParam() in App, DB, and PDO.

File:

• trunk/lib/PDO.inc.php (modified) (2 diffs)

trunk/lib/PDO.inc.php

@@ -103 +103 @@
      * @param string $params    Configuration parameters for this object.
      */
-    public function __construct($params=null)
+    public function __construct(Array $params=[])
     {
         // Set custom parameters.
@@ -131 +131 @@
      * @param  array $params   Array of param keys and values to set.
      */
-    public function setParam($params=null)
-    {
-        if (isset($params) && is_array($params)) {
-            // Merge new parameters with old overriding only those passed.
-            $this->_params = array_merge($this->_params, $params);
+    public function setParam(Array $params)
+    {
+        if (!isset($params) || !is_array($params)) {
+            trigger_error(sprintf('%s failed; not an array: %s', __METHOD__, getDump($params, false, SC_DUMP_PRINT_R)), E_USER_ERROR);
+        }
+
+        // Merge new parameters with old overriding only those passed.
+        $this->_params = array_merge($this->_params, $params);
+
+        if ($this->isConnected()) {
+            // Params that require additional processing if set during runtime.
+            foreach ($params as $key => $val) {
+                switch ($key) {
+                case 'timezone':
+                    // Set timezone used by MySQL.
+                    $this->query(sprintf("SET time_zone = %s;", $this->quote($val)));
+                    break;
+                }
+            }
         }
     }