dict_updata_user.php 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. <?php
  2. /*
  3. 更新用户字典,已经不使用了
  4. */
  5. include "./_pdo.php";
  6. include "config.php";
  7. $serverError = "";
  8. $serverReturn = "";
  9. $serverOp = "";
  10. $input = file_get_contents("php://input");
  11. $xml = simplexml_load_string($input);
  12. $db_file = $dir_dict_user . $file_dict_user_default;
  13. PDO_Connect("$db_file");
  14. $wordsList = $xml->xpath('//word');
  15. $recorderCount = 0;
  16. /**/
  17. foreach ($wordsList as $ws) {
  18. $id = $ws->id;
  19. if ($id == "0") {
  20. //new recorder
  21. $query = "INSERT INTO dict ('id','pali','type','gramma','parent','mean','detail','factors','factormean','confer','class','lock','tag') VALUES (null,?,?,?,?,?,?,?,?,?,?,?,?)";
  22. $params = array($ws->pali, $ws->type, $ws->gramma, $ws->parent, $ws->mean, $ws->note, $ws->factors, $ws->fm, $ws->confer, $ws->status, $ws->lock, $ws->tag);
  23. $stmt = @PDO_Execute($query, $params);
  24. $last_id = $PDO->lastInsertId();
  25. $serverOp = "insert";
  26. $serverReturn = $last_id;
  27. } else {
  28. $query = "UPDATE dict SET type = ? ,gramma = ? ,parent = ? ,mean = ? ,detail = ? ,factors = ? ,factormean = ? ,confer = ? ,class = ? ,lock = ? ,tag = ? WHERE id = ?";
  29. $params = array($ws->type, $ws->gramma, $ws->parent, $ws->mean, $ws->note, $ws->factors, $ws->fm, $ws->confer, $ws->status, $ws->lock, $ws->tag, $id);
  30. $stmt = @PDO_Execute($query, $params);
  31. $serverOp = "update";
  32. $serverReturn = $id;
  33. }
  34. if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
  35. $error = PDO_ErrorInfo();
  36. $serverError .= "error - $error[2]";
  37. $serverReturn = -1;
  38. } else {
  39. $recorderCount++;
  40. }
  41. $output = '{ "sever_op":"insert" , "server_return":2345 , , "server_error":"haha"}';
  42. $output = '{"msg":[' . '{"server_op":"' . $serverOp . '","server_return":' . $serverReturn . ',"server_error":"' . $serverError . '" }]}';
  43. echo $output;
  44. }