<?php
//db variables
$dbuser = 'dbuser';
$dbpass = 'dbpass';
$dbname = 'dbname';
$dbhost = 'localhost';

error_reporting(E_ALL);
ini_set('display_errors', 1);

$data = $_POST['payload'];

$data_array = json_decode($data, true);

//store in PHP variables
list($ip_address,$env,$study) = explode("|", $data_array['data']['payload']);
$vid_name = $data_array['data']['videoName'];
$date_time = $data_array['data']['dateTime'];
$time_zone = $data_array['data']['timeZone'];
$id = $data_array['data']['id'];
$referer = $data_array['data']['httpReferer'];


print_r($data);

//text file used to verify data being received
$myFile = "testFile1.txt";
$fh = fopen($myFile,'a') or die("cant open file");
$stringData = $data;
fwrite($fh, $stringData);
fclose($fh);



//echo for testing hard-coded JSON
echo"[ $ip_address / $vid_name / $date_time / $time_zone ]";

// EDIT : added query

// connect to DB
$mysqli = mysqli_connect("$dbhost", "$dbuser", "$dbpass", "$dbname");

if (mysqli_connect_errno()) { echo "Error connecting : " . mysqli_connect_error($mysqli); }

$query = " INSERT INTO myTable (`study`, `id`, `IpAddress`, `VideoName`, `Environment`, `DateTime`, `Timezone`, `HttpReferer`, `JSON`) VALUES (?,?,?,?,?,?,?,?,?) ";
$stmt = $mysqli->prepare($query);

print_r($stmt->error_list);

$stmt->bind_param("sssssssss", $study, $id, $ip_address, $vid_name, $env, $date_time, $time_zone, $referer, $data);

if (!$stmt->execute()) { echo $stmt->error; } else { echo"true"; }

?>