/** * 检查是否存在指定的记录 * * @param string $value * @param string $colname * @return void */ public static function getUid($value, $colname = 'userid') { $field = array('userid', 'email', 'mobile'); if (!in_array($colname, $field)) { $colname = 'userid'; } $id = Da_Wrapper::getOne(self::DB_NS, "SELECT id FROM ht_users WHERE {$colname} = ?", array($value)); return $id; }
/** * 得到用户数据条数 * @param int $userid 用户id */ public static function getUserActiveCount($userid, $condition = '1=1') { $count = Da_Wrapper::getOne(self::DB_TABLE_ACTIVE, "select count(*) as c from {active} where user_id = {$userid} and {$condition}"); return $count; }