covid_test_2.php

<?php
require "config.php"; 

// existing code to fetch numbers here

try {
  $connection = new PDO($dsn, $username, $password, $options);
}
  catch(PDOException $error) {
    echo "Cannot connect to database. Fix that." . "<br>" . $error->getMessage();
    logfile($error->getMessage());
  }
  

$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, 'https://coronavirus-tracker-api.herokuapp.com/v2/locations/665?source=nyt&timelines=false');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'GET');


$headers = array();
$headers[] = 'Accept: application/json';
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);

$result = curl_exec($ch);
$json = json_decode($result, true);
$table = "hernando";

$confirmed = $json['location']['latest']['confirmed'];
$deaths = $json['location']['latest']['deaths'];

if (curl_errno($ch)) {
    echo 'Error:' . curl_error($ch);
} else {
	//  This is simplified

$sql = sprintf(
  "INSERT INTO %s (%s) values (%d, %d)", 
  $table, "confirmed , deaths", $confirmed, $deaths
  );

try { 
  $statement = $connection->prepare($sql);
  $statement->execute($ret);
}
 
   catch(PDOException $error) {
    echo $sql . "<br>" . $error->getMessage();
    logfile($error->getMessage());
  } 

}
curl_close($ch);
?>