0,"message"=>""); if(!isset($_COOKIE["userid"])){ #不登录不能新建 $respond['status']=1; $respond['message']="no power create article"; echo json_encode($respond, JSON_UNESCAPED_UNICODE); exit; } # 检查当前用户是否有修改权限 $redis = redis_connect(); $collection = new CollectInfo($redis); $power = $collection->getPower($_POST["id"]); if($power<20){ $respond["status"]=1; $respond["message"]="No Power For Edit"; echo json_encode($respond, JSON_UNESCAPED_UNICODE); exit; } add_edit_event(_COLLECTION_EDIT_,$_POST["id"]); PDO_Connect(_FILE_DB_USER_ARTICLE_); $query="UPDATE collect SET title = ? , subtitle = ? , summary = ?, article_list = ? , status = ? , lang = ? , receive_time= ? , modify_time= ? where id = ? "; $sth = $PDO->prepare($query); $sth->execute(array($_POST["title"] , $_POST["subtitle"] ,$_POST["summary"], $_POST["article_list"] , $_POST["status"] , $_POST["lang"] , mTime() , mTime() , $_POST["id"])); $respond=array("status"=>0,"message"=>""); if (!$sth || ($sth && $sth->errorCode() != 0)) { $error = PDO_ErrorInfo(); $respond['status']=1; $respond['message']=$error[2]; } else{ if($redis){ $redis->del("collection://".$_POST["id"]); $redis->del("power://collection/".$_POST["id"]); } # 更新 article_list 表 $query = "DELETE FROM article_list WHERE collect_id = ? "; PDO_Execute($query,array($_POST["id"])); $arrList = json_decode($_POST["article_list"]); if(count($arrList)>0){ /* 开始一个事务,关闭自动提交 */ $PDO->beginTransaction(); $query = "INSERT INTO article_list (collect_id, article_id,level,title) VALUES ( ?, ?, ? , ? )"; $sth = $PDO->prepare($query); foreach ($arrList as $row) { $sth->execute(array($_POST["id"],$row->article,$row->level,$row->title)); if($redis){ #删除article权限缓存 $redis->del("power://article/".$row->article); } } $PDO->commit(); if (!$sth || ($sth && $sth->errorCode() != 0)) { /* 识别错误且回滚更改 */ $PDO->rollBack(); $error = PDO_ErrorInfo(); $respond['status']=1; $respond['message']=$error[2]; } } } echo json_encode($respond, JSON_UNESCAPED_UNICODE); ?>