Plugin Directory

Changeset 1779007


Ignore:
Timestamp:
11/30/2017 08:37:20 PM (8 years ago)
Author:
viewup
Message:

implement get col method

Location:
up-user-datakeeper/trunk/class
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • up-user-datakeeper/trunk/class/api.php

    r1779004 r1779007  
    3333        return Utils::decode($data);
    3434    }
     35
     36    public static function getUserCol($col, $value){
     37        return User::getCol($col, $value);
     38    }
    3539}
    3640
  • up-user-datakeeper/trunk/class/db.php

    r1779006 r1779007  
    7272
    7373    static function getCol($tableName, $column, $valueLike){
     74        global $wpdb;
     75       
    7476        $sql = $wpdb->prepare('SELECT * FROM %s WHERE %s LIKE %s', [
    7577            $tableName,
     
    7779            $valueLike
    7880        ]);
     81
     82        return $wpdb->get_col($sql);       
    7983    }
    8084
  • up-user-datakeeper/trunk/class/user.php

    r1779001 r1779007  
    191191        }
    192192
     193        public function getCol($column, $value){
     194            $tableName = UpUserDatakeeper::$tableName; 
     195            return DB::getCol($tableName, $column, $value);
     196        }
     197
    193198        public function removeData($userId, $key, $value){
    194199            global $wpdb;
Note: See TracChangeset for help on using the changeset viewer.