new_block.php 1.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647
  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. $aData=json_decode($_POST["data"]);
  9. PDO_Connect("sqlite:"._FILE_DB_SENTENCE_);
  10. /* 开始一个事务,关闭自动提交 */
  11. $PDO->beginTransaction();
  12. $query="INSERT INTO sent_block ('id','book','paragraph','owner','lang','author','editor','tag','modify_time','receive_time') VALUES (?,?,?,?,?,?,?,?,?,?)";
  13. $sth = $PDO->prepare($query);
  14. foreach ($aData as $data) {
  15. if(isset($_COOKIE["userid"])){
  16. $userid = $_COOKIE["userid"];
  17. }
  18. else{
  19. $userid = $data->userid;
  20. }
  21. $sth->execute(array($data->id,$data->book,$data->paragraph,$userid,$data->lang,$data->author,$data->editor,$data->tag,$data->time,mTime()));
  22. }
  23. $PDO->commit();
  24. $respond=array("status"=>0,"message"=>"");
  25. if (!$sth || ($sth && $sth->errorCode() != 0)) {
  26. /* 识别错误且回滚更改 */
  27. $PDO->rollBack();
  28. $error = PDO_ErrorInfo();
  29. $respond['status']=1;
  30. $respond['message']=$error[2];
  31. }
  32. else{
  33. $respond['status']=0;
  34. $respond['message']="成功";
  35. }
  36. echo json_encode($respond, JSON_UNESCAPED_UNICODE);
  37. ?>