Changeset 810 for trunk/lib/DB.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/DB.inc.php (modified) (1 diff)

trunk/lib/DB.inc.php

@@ -119 +119 @@
      * @param  array    $params     Array of parameters (key => val pairs).
      */
-    public function setParam($params)
-    {
-        $app =& App::getInstance();
-
-        if (isset($params) && is_array($params)) {
-            // Merge new parameters with old overriding only those passed.
-            $this->_params = array_merge($this->_params, $params);
-        } else {
-            $app->logMsg(sprintf('Parameters are not an array: %s', $params), LOG_ERR, __FILE__, __LINE__);
+    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->escapeString($val)));
+                    break;
+                }
+            }
         }
     }