Skip to content

Instantly share code, notes, and snippets.

@anubhaw2091
Created March 9, 2016 20:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anubhaw2091/0d32fea3de37b6f032dd to your computer and use it in GitHub Desktop.
Save anubhaw2091/0d32fea3de37b6f032dd to your computer and use it in GitHub Desktop.
<?php
if($_SERVER['REQUEST_METHOD']=='GET'){
$request = $_GET["data"];
$jsonData = json_decode($request,true);
echo($request);
echo "\r\nDivide";
echo $jsonData;
echo $jsonData->['numbers'];
$link = mysqli_connect("xx", "xx", "xx", "xx") or die("Error " . mysqli_error($link));
foreach($jsonData as $key => $value)
{
// request id
$requestID = $value['requestId'];
$userId = $value['userId'];
$senderId = $value['senderId'];
foreach($value['report'] as $key1 => $value1)
{
//detail description of report
$desc = $value1['desc'];
// status of each number
$status = $value1['status'];
// destination number
$receiver = $value1['number'];
//delivery report time
$date = $value1['date'];
$query = "INSERT INTO mytable (request_id,user_id,sender_id,date,receiver,status,description) VALUES ('" . $requestID . "','" . $userId . "','" . $senderId . "','" . $date . "','" . $receiver . "','" . $status . "','" . $desc . "')";
mysqli_query($link, $query);
}
}
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment