Context Navigation

Changeset 1779013

Timestamp:

11/30/2017 08:38:26 PM (8 years ago)

Author:

viewup

Message:

fix function logic

Location:

up-user-datakeeper/trunk/class

Files:

-                      r1779012
+                      r1779013
+    }
     static function getCol($tableName, $column, $valueLike){
+    static function getCol($query, $args){
         global $wpdb;
+        $sql = $wpdb->prepare("SELECT $column FROM $tableName WHERE $column LIKE %s", [
+            $valueLike
+        ]);
+        return $wpdb->get_col($sql);
+        $sql = $wpdb->prepare($query, $args);
+        return $wpdb->get_col($sql);
+    }

-                      r1779010
+                      r1779013
+        }
+        public function getColByKey($key){
+            $tableName = UpUserDatakeeper::$tableName;
+            return DB::getCol($tableName, '_key', $key);
+        public function getCol($key, $userId){
+            $tableName = UpUserDatakeeper::$tableName;
+            $query = "SELECT _key FROM $tableName WHERE _key LIKE %s AND user_id";
+            $args = [ $key ];
+            return DB::getCol($query, $args);
+        }

Note: See TracChangeset for help on using the changeset viewer.