数据库处理中的增删改查
时间：2021-07-01 10:21:17
帮助过：27人阅读
//管理员实体类
class ManageModel
extends Model{
private $id;
private $admin_user;
private $admin_pass;
private $level;
private $limit;
private $last_ip;
//拦截器(__set)
public function __set(
$_key,
$_value){
$this->
$_key=Tool::mysqlString(
$_value);
}
//拦截器(__get)
public function __get(
$_key){
return $this->
$_key;
}
//设置管理员登录统计次数、ip、时间
public function setLoginCount(){
$_sql="
UPDATE
cms_manage
SET
login_count=login_count+1,
last_ip=‘$this->last_ip‘,
last_time=NOW()
WHERE
admin_user=‘$this->admin_user‘
LIMIT
1"
;
return parent::aud(
$_sql);
}
//获取管理员总记录
public function getManageTotal(){
$_sql="
SELECT
COUNT(*)
FROM
cms_manage"
;
return parent::total(
$_sql);
}
//查询登录管理员
public function getLoginManage(){
$_sql="
SELECT
m.admin_user,
l.level_name
FROM
cms_manage m,
cms_level l
WHERE
m.admin_user=‘$this->admin_user‘
AND
m.admin_pass=‘$this->admin_pass‘
AND
l.id=m.level
LIMIT
1"
;
return parent::one(
$_sql);
}
//查询单个管理员
public function getOneManage(){
$_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"
;
return parent::one(
$_sql);
}
//查询所有管理员
public function getAllManage(){
$_sql="
SELECT
m.id,
m.admin_user,
m.login_count,
m.last_ip,
m.last_time,
l.level_name
FROM
cms_manage m,
cms_level l
WHERE
l.id=m.level
ORDER BY
m.id DESC
$this->limit"
;
return parent::all(
$_sql);
}
//新增管理员
public function addManage(){
$_sql="
INSERT INTO
cms_manage(
admin_user,
admin_pass,
level,
reg_time
)
VALUES(
‘$this->admin_user‘,
‘$this->admin_pass‘,
‘$this->level‘,
NOW()
)"
;
return parent::aud(
$_sql);
}
//修改管理员
public function updateManage(){
$_sql = "
UPDATE
cms_manage
SET
admin_pass=‘$this->admin_pass‘,
level=‘$this->level‘
WHERE
id=‘$this->id‘
LIMIT
1"
;
return parent::aud(
$_sql);
}
//删除管理员
public function deleteManage(){
$_sql="
DELETE FROM
cms_manage
WHERE
id=‘$this->id‘
LIMIT 1"
;
return parent::aud(
$_sql);
}
}
数据库处理中的增删改查
标签：mysq string end 数据库 管理 update login log extends
