{
  "remoteMovie": {
    "tmdbId": 1234,
    "imdbId": "5678",
    "title": "Test title",
    "year": 1970
  },
  "release": {
    "quality": "Test Quality",
    "qualityVersion": 1,
    "releaseGroup": "Test Group",
    "releaseTitle": "Test Title",
    "indexer": "Test Indexer",
    "size": 9999999
  },
  "eventType": "Test",
  "movie": {
    "id": 1,
    "title": "Test Title",
    "releaseDate": "1970-01-01",
    "folderPath": "C:\testpath"
  }
}

ini_set('display_errors', 'On');

# MySQL database connection info
    $host = 'XXXX';
    $dbname = 'XXXX';
    $username = 'XXXX';
    $password = 'XXXX';

//$input = file_get_contents('mysql_webhook_payload.json'); # Local file for debugging
    $input = file_get_contents('php://input'); # POST data from webhook
    $payload = json_decode($input, true);

  //Data Set To Retrieve
    $movie_id = $payload['movie']['id'];
    $movie_name = $payload['movie']['title'];
    $poster = "http://XXXX.com:XXXX/MediaCover/".$movie_id."/poster.jpg";
    $DateTime = new DateTime();

// Send Everything To The DB
    try {
    $conn = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO new_movies (id, movieID, Title, movie_poster, date_added) VALUES ('','".$movie_id."', '".$movie_name."', '".$poster."', '1')";
    //$sql = "INSERT INTO new_movies (id, movieID, Title, movie_poster, date_added) VALUES ('0','1', '1', '1', '1')";
    // use exec() because no results are returned
    $conn->exec($sql);
        echo "New record created successfully";
    }
catch(PDOException $e)
    {
    echo $sql . "<br> Oh No!" . $e->getMessage();
    }


$conn = null;
echo "just testing";

$fWrite = fopen("log.txt","a");
$wrote = fwrite($fWrite, var_dump($input));
fclose($fWrite);