sql语句管理员

查询单个管理员

"SELECT 
            id,
        admin_user,
        admin_pass,
        level 
FROM 
        cms_manage 
WHERE 
        id='$this->_id'
    OR
        admin_user='$this->_admin_user'
    OR
        level='$this->level'
LIMIT 
        1"   

查询所有

"SELECT 
        m.id,
        m.admin_user,
        m.login_count,
        m.last_ip,
        m.last_time,
        l.level_name
FROM 
        cms_manage as m,
        cms_level as l
WHERE 
        l.id = m.level    
ORDER BY
        m.id ASC 
        $this->_limit"

 新增管理员

"INSERT INTO 
            cms_manage(
                        admin_user,
                        admin_pass,
                        level,
                        reg_time
            )
VALUES (
        '$this->_admin_user',
        '$this->_admin_pass',
        '$this->_level',
        NOW()
        )"

修改管理员

"UPDATE 
        cms_manage 
SET 
        admin_pass = '$this->_admin_pass',
        level = '$this->_level'
WHERE 
        id='$this->_id' 
LIMIT 
        1"

 删除管理员

"DELETE FROM 
            cms_manage 
 WHERE 
             id='$this->_id' 
 LIMIT 1"

获取管理员总记录

"SELECT 
        COUNT(*) as c 
FROM 
        cms_manage"

 

转载于:https://www.cnblogs.com/oceanden/p/4040729.html