Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // data set being sent:
- [
- {data:{
- app_installDate:"Mon Oct 24 2016 11:15:35 GMT-0400 (EDT)",
- app_installTime:"Mon Oct 24 2016 11:15:35 GMT-0400 (EDT)",
- user_address1:"",
- user_address2:"",
- user_city:"",
- user_country:"",
- user_email:"rolinger1972@gmail.com",
- user_fName:"",
- user_lName:"",
- user_phone:"13104663399",
- user_state:"",
- user_zip:""
- },
- table:"userTable",
- task:1
- },
- {data: {
- app_curVersion:"0.1.8",
- app_installDate:"Mon Oct 24 2016 11:15:35 GMT-0400 (EDT)",
- app_installTime:"Mon Oct 24 2016 11:15:35 GMT-0400 (EDT)",
- app_installVersion:"0.1.8",
- dev_ID:"353300064006726",
- dev_OS:"Android",
- dev_OSVersion:"6.0.1",
- dev_UUID:"db9cc73e418309bf",
- dev_carrier:"T-Mobile",
- dev_email:"rolinger1972@gmail.com",
- dev_model:"SM-G900T",
- dev_phoneNumber:"13104663399",
- dev_serial:"21939b63",
- dev_sim:"8901260422735014534",
- dev_simCountry:"us",
- dev_vendor:"samsung",
- },
- table:"userDevice",
- task:1
- }
- ]
- // code to process above data:
- $pdo = new PDO('mysql:host=localhost;dbname=foobar', 'foo', 'bar');
- $input = json_decode(file_get_contents('php://input'),true) ;
- $method = $_SERVER['REQUEST_METHOD'];
- foreach ($input as $row) {
- $table = $row['table'] ;
- $task = $row['task'] ;
- $sid = $row['sid'] ;
- $sidValue = $row['sidValue'] ;
- $sqlCols = array() ;
- $sqlValues = array() ;
- $sqlParams = array() ;
- $sqlInserts = array() ;
- foreach ($row['data'] as $key => $val) {
- $sqlCols[] = $key ;
- $sqlValues[] = $val ;
- $sqlInserts[] = "?" ;
- $sqlParams[":$key"] = $val ;
- }
- $colString = implode(",",$sqlCols) ;
- $valString = implode(",",$sqlValues) ;
- $insString = implode(",",$sqlInserts) ;
- // $stmt->exec([':foo'=>$foo]);
- if ($method == 'POST') { // INSERT
- $stmt = $pdo->prepare("INSERT INTO $table ($colString) VALUES ($insString)");
- $result = $stmt->execute($sqlParams);
- } elseif ($method == 'PUT') { // UPDATE
- $stmt = $pdo->prepare("UPDATE $table SET $colString WHERE $sid = $sidValue");
- $result = $stmt->execute([":$sid"=>$sidValue]) ;
- } elseif ($method == 'GET') { // SELECT
- $stmt = $pdo->prepare("SELECT * FROM $table WHERE $sid = $sidValue");
- $result = $stmt->execute([":$sid"=>$sidValue]) ;
- }
- var_dump($result) ; //returning: bool(false), and nothing is being inserted into db (obviously).
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement