Advertisement
rolinger

Untitled

Oct 28th, 2016
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.36 KB | None | 0 0
  1. // data set being sent:
  2.  
  3. [
  4. {data:{
  5. app_installDate:"Mon Oct 24 2016 11:15:35 GMT-0400 (EDT)",
  6. app_installTime:"Mon Oct 24 2016 11:15:35 GMT-0400 (EDT)",
  7. user_address1:"",
  8. user_address2:"",
  9. user_city:"",
  10. user_country:"",
  11. user_email:"rolinger1972@gmail.com",
  12. user_fName:"",
  13. user_lName:"",
  14. user_phone:"13104663399",
  15. user_state:"",
  16. user_zip:""
  17. },
  18. table:"userTable",
  19. task:1
  20. },
  21. {data: {
  22. app_curVersion:"0.1.8",
  23. app_installDate:"Mon Oct 24 2016 11:15:35 GMT-0400 (EDT)",
  24. app_installTime:"Mon Oct 24 2016 11:15:35 GMT-0400 (EDT)",
  25. app_installVersion:"0.1.8",
  26. dev_ID:"353300064006726",
  27. dev_OS:"Android",
  28. dev_OSVersion:"6.0.1",
  29. dev_UUID:"db9cc73e418309bf",
  30. dev_carrier:"T-Mobile",
  31. dev_email:"rolinger1972@gmail.com",
  32. dev_model:"SM-G900T",
  33. dev_phoneNumber:"13104663399",
  34. dev_serial:"21939b63",
  35. dev_sim:"8901260422735014534",
  36. dev_simCountry:"us",
  37. dev_vendor:"samsung",
  38. },
  39. table:"userDevice",
  40. task:1
  41. }
  42. ]
  43.  
  44. // code to process above data:
  45. $pdo = new PDO('mysql:host=localhost;dbname=foobar', 'foo', 'bar');
  46. $input = json_decode(file_get_contents('php://input'),true) ;
  47. $method = $_SERVER['REQUEST_METHOD'];
  48. foreach ($input as $row) {
  49. $table = $row['table'] ;
  50. $task = $row['task'] ;
  51. $sid = $row['sid'] ;
  52. $sidValue = $row['sidValue'] ;
  53. $sqlCols = array() ;
  54. $sqlValues = array() ;
  55. $sqlParams = array() ;
  56. $sqlInserts = array() ;
  57. foreach ($row['data'] as $key => $val) {
  58. $sqlCols[] = $key ;
  59. $sqlValues[] = $val ;
  60. $sqlInserts[] = "?" ;
  61. $sqlParams[":$key"] = $val ;
  62. }
  63. $colString = implode(",",$sqlCols) ;
  64. $valString = implode(",",$sqlValues) ;
  65. $insString = implode(",",$sqlInserts) ;
  66.  
  67. // $stmt->exec([':foo'=>$foo]);
  68. if ($method == 'POST') { // INSERT
  69. $stmt = $pdo->prepare("INSERT INTO $table ($colString) VALUES ($insString)");
  70. $result = $stmt->execute($sqlParams);
  71. } elseif ($method == 'PUT') { // UPDATE
  72. $stmt = $pdo->prepare("UPDATE $table SET $colString WHERE $sid = $sidValue");
  73. $result = $stmt->execute([":$sid"=>$sidValue]) ;
  74. } elseif ($method == 'GET') { // SELECT
  75. $stmt = $pdo->prepare("SELECT * FROM $table WHERE $sid = $sidValue");
  76. $result = $stmt->execute([":$sid"=>$sidValue]) ;
  77. }
  78. var_dump($result) ; //returning: bool(false), and nothing is being inserted into db (obviously).
  79. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement