File: src/_update.php

Recommend this page to a friend!
  Classes of Max Base  >  PHP Corona Virus Database  >  src/_update.php  >  Download  
File: src/_update.php
Role: Example script
Content type: text/plain
Description: Example script
Class: PHP Corona Virus Database
An API to lookup information about Corona Virus
Author: By
Last change:
Date: 3 months ago
Size: 1,700 bytes
 

Contents

Class file image Download
<?php
// Max Base
// https://github.com/BaseMax/CoronaVirusDatabase
define("BASE", __DIR__ . "/");
require_once
"_core.php";
require_once
"_netphp.php";
$fileName="response.json";
$url_api="https://services1.arcgis.com/0MSEUqKaxRlEPj5g/arcgis/rest/services/ncov_cases/FeatureServer/2/query?f=json&where=Confirmed%20%3E%200&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outFields=*&orderByFields=Confirmed%20desc&resultOffset=0&resultRecordCount=1000&cacheHint=true";

function
parseCheck() {
    global
$fileName;
   
parseContent(file_get_contents($fileName));
}

function
parseContent($data) {
    global
$db;
   
$json=json_decode($data, true);
   
$features=$json["features"];
   
$items=[];
    foreach(
$features as $feature) {
       
$items[]=$feature["attributes"];
    }
   
// print_r($items);
    // OBJECTID, Country_Region, Last_Update, Lat, Long_, Confirmed, Deaths, Recovered
   
foreach($items as $item) {
       
$clauses=[
           
"name"=>strtolower($item["Country_Region"]),
        ];
       
$values=[
           
"name"=>strtolower($item["Country_Region"]),
           
"totalCase"=>$item["Confirmed"],
           
"totalRecovered"=>$item["Recovered"],
           
"totalDeath"=>$item["Deaths"],
        ];
        if(
$db->count("country", $clauses) == 0) {
           
$db->insert("country", $values);
        }
        else {
            if(
$db->count("country", $values) == 0) {
               
// skip
           
}
            else {
                print
"Update...\n";
               
$db->update("country", $clauses, $values);
            }
        }
    }
}

if(isset(
$argv) and isset($argv[1]) and $argv[1] == "update") {
   
$res=get($url_api);
   
file_put_contents($fileName, $res[0]);
   
parseContent($res[0]);
}
// else {
// if(file_exists($fileName)) {
// parseContent(file_get_contents($fileName));
// }
// else {
// exit("Error: file not exists!\n");
// }
// }


For more information send a message to info at phpclasses dot org.