update.php 1002 B

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. <?php
  2. /*
  3. get xml doc from db
  4. */
  5. require_once "../path.php";
  6. require_once "../public/_pdo.php";
  7. require_once "../public/function.php";
  8. require_once "../ucenter/active.php";
  9. $aData=json_decode($_POST["data"]);
  10. add_edit_event("wbw",array("book"=>0,"para"=>0));
  11. PDO_Connect("sqlite:"._FILE_DB_USER_WBW_);
  12. /* 开始一个事务,关闭自动提交 */
  13. $PDO->beginTransaction();
  14. $query="UPDATE wbw SET data= ? , receive_time= ? , modify_time= ? where block_id= ? and wid= ? ";
  15. $sth = $PDO->prepare($query);
  16. foreach ($aData as $data) {
  17. $sth->execute(array($data->data,mTime(),$data->time,$data->block_id,$data->word_id));
  18. }
  19. $PDO->commit();
  20. $respond=array("status"=>0,"message"=>"");
  21. if (!$sth || ($sth && $sth->errorCode() != 0)) {
  22. /* 识别错误且回滚更改 */
  23. $PDO->rollBack();
  24. $error = PDO_ErrorInfo();
  25. $respond['status']=1;
  26. $respond['message']=$error[2];
  27. }
  28. else{
  29. $respond['status']=0;
  30. $respond['message']="成功";
  31. }
  32. echo json_encode($respond, JSON_UNESCAPED_UNICODE);
  33. ?>