帝国CMS封装后的增、删、改、查语句:

//修改  
$res=$empire->query("update {$dbtbpre}t_report set `handle`='{$handle}' where `id`=$id");  
  
//插入  
$res=$empire->query("insert into {$dbtbpre}t_app_version (`version_code`,`version_name`,`log`,`time`) values ('{$version_code}','{$version_name}','{$log}',$time)");  
  
//删除  
$res=$empire->query("delete from {$dbtbpre}school_location_v1_1 where `id`=$id");  
  
//查询单条数据  
$res=$empire->fetch1("select * from {$dbtbpre}t_circle_comment_comment where `comment_id`='{$comment['id']}'");  
  
//查询多条数据  
$sql=$empire->query("select * from {$dbtbpre}t_circle_praise where `user_id`='$id'");  
while($praise=$empire->fetch($sql)){  
  $res=$empire->fetch1("select * from {$dbtbpre}t_circle_about_me where `from_id`='{$praise['id']}' and `type`=1");  
  if($res){  
    $empire->query("delete from {$dbtbpre}t_circle_about_me where `from_id`='{$praise['id']}' and `type`=1");    //点赞是1  
  }  
}  

 

posted @ 2017-07-03 16:29  八路逆袭寡妇村  阅读(686)  评论(0编辑  收藏  举报
www.zxzidian.com