dict_updata_user.php 1.6 KB

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