Changeset 497 for trunk/lib/DB.inc.php

Timestamp:

Sep 15, 2014 9:44:27 PM (10 years ago)

Author:

anonymous

Message:

Beginning the process of adapting codebase to foundation styles.

File:

• trunk/lib/DB.inc.php (modified) (1 diff)

trunk/lib/DB.inc.php

@@ -441 +441 @@
     }
 
+    /**
+     * Returns the values of an ENUM or SET column, returning them as an array.
+     *
+     * @param  string $db_table   database table to lookup
+     * @param  string $db_col     database column to lookup
+     * @param  bool   $sort          Sort the output.
+     * @return array    Array of the set/enum values on success, false on failure.
+     */
+    public function getEnumValues($db_table, $db_col, $sort=false)
+    {
+        $app =& App::getInstance();
+
+        $qid = $this->query("SHOW COLUMNS FROM " . $this->escapeString($db_table) . " LIKE '" . $this->escapeString($db_col) . "'", false);
+
+        $row = mysql_fetch_row($qid);
+        if (preg_match('/^enum|^set/i', $row[1]) && preg_match_all("/'([^']*)'/", $row[1], $matches)) {
+            if ($sort) {
+                natsort($matches[1]);
+            }
+            return $matches[1];
+        } else {
+            $app->logMsg(sprintf('No set or enum fields found in %s.%s', $db_table, $db_col), LOG_ERR, __FILE__, __LINE__);
+            return false;
+        }
+    }
+
+
 } // End.