new_block.php 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. <?php
  2. /*
  3. get xml doc from db
  4. */
  5. require_once "../config.php";
  6. require_once "../public/_pdo.php";
  7. require_once "../public/function.php";
  8. $aData = json_decode($_POST["data"]);
  9. PDO_Connect("" . _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. } else {
  18. $userid = $data->userid;
  19. }
  20. $sth->execute(array($data->id, $data->book, $data->paragraph, $userid, $data->lang, $data->author, $data->editor, $data->tag, $data->time, mTime()));
  21. }
  22. $PDO->commit();
  23. $respond = array("status" => 0, "message" => "");
  24. if (!$sth || ($sth && $sth->errorCode() != 0)) {
  25. /* 识别错误且回滚更改 */
  26. $PDO->rollBack();
  27. $error = PDO_ErrorInfo();
  28. $respond['status'] = 1;
  29. $respond['message'] = $error[2];
  30. } else {
  31. $respond['status'] = 0;
  32. $respond['message'] = "成功";
  33. }
  34. echo json_encode($respond, JSON_UNESCAPED_UNICODE);