?? GreyFile

?? GreyFile — Mystic File Browser

Current path: home/webdevt/cryptoimpot.fr/tools/

?? Editing: update.php

<?php

//function getExchangeRates($currency =, DateTime $dateTime) {
//
//        $urlApi = 'https://api.exchangeratesapi.io/';
//        // asset fsym
//
//        $urlApi .= $dateTime->format('Y-m-d');
//        $urlApi .= '?base=EUR';
//        $urlApi .= '&symbols=' . $currency;
//
//
//        // fetch data
//        $curl = curl_init();
//        curl_setopt($curl, CURLOPT_URL, $urlApi);
//        curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
//        $rawData = curl_exec($curl);
//        curl_close($curl);
//
//// decode to array
//        $data = json_decode($rawData, true);
//        
//        if (!isset($data['rates'][$currency])) {
//            throw New \Exception('Taux de change non trouvé.');
//            //throw new Exception('Market value not found');
//            echo $dateTime->format('Y-m-d');
//            $price = 0;
//        } else {
//            return $data['rates'][$currency];
//        }
//        
//    }

$dsn = "mysql:host=localhost;dbname=ledgio";
$user = "ledgio";
$passwd = "jUH5DhzJrTvBxy88";

$pdo = new PDO($dsn, $user, $passwd);
require('Aspirateur.php');

//foreach ($pdo->query('SELECT * FROM devise', PDO::FETCH_ASSOC) as $row) {
//
//
//    echo $row['code'];
////    exit;
//}
//
//exit;

$asp = new Aspirateur('2019-01-01', '2020-05-08', 'XLM');
exit;
foreach ($pdo->query('SELECT * FROM devise', PDO::FETCH_ASSOC) as $row) {
    
    
    echo 'aspirateur';
    echo $row['code']; exit;

//$row['code'] = 'ATOM';
//    if (empty($row['id_cmp'])) {
        $url = 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/map';
//        $url = 'https://pro-api.coinmarketcap.com/v1//cryptocurrency/listings/latest';
        $parameters = [
  'symbol' => $row['code']
//    'id' => 7,
//            'limit' => 5000
        ];

$headers = [
            'Accepts: application/json',
            'X-CMC_PRO_API_KEY: 5922b05c-4c84-47c6-a462-f303e6c209be'
        ];
        $qs = http_build_query($parameters); // query string encode the parameters
        $request = "{$url}?{$qs}"; // create the request URL

$curl = curl_init(); // Get cURL resource
// Set cURL options
        curl_setopt_array($curl, array(
            CURLOPT_URL => $request, // set the request URL
            CURLOPT_HTTPHEADER => $headers, // set the headers 
            CURLOPT_RETURNTRANSFER => 1         // ask for raw response instead of bool
        ));

$response = curl_exec($curl); // Send the request, save the response
        $arrayResponse = json_decode($response); // print json decoded response
        curl_close($curl); // Close request
echo 'response aspirateur';
        var_dump($arrayResponse);
        exit;

if ($arrayResponse->data) {
            foreach ($arrayResponse->data as $obj) {

$first = new DateTime();
                // $first->setTimestamp(strtotime($obj->first_historical_data));
//       $last = Datetime::createFromFormat(Datetime::ATOM, $obj->last_historical_data);
                $last = new DateTime();
                //$last->setTimestamp(strtotime($obj->last_historical_data));
                //var_dump($first, $last); exit;
                //echo 'UPDATE `devise` SET `id_cmc` = ' . $obj->id . ', `name_cmc` = "' . $obj->name . '", `first_historical_data_cmc` = "' . $first->format('Y-m-d H:i:s') . '", `last_historical_data_cmc` = "' . $last->format('Y-m-d H:i:s') . '"  WHERE `devise`.`code` = "' . $obj->symbol . '" AND `devise`.`nom` = "' . $obj->name . '";';
//       $pdo->query('UPDATE `devise` SET `id_cmc` = ' . $obj->id . ', `name_cmc` = "' . $obj->name . '", `first_historical_data_cmc` = "' . $first->format('Y-m-d H:i:s') . '", `last_historical_data_cmc` = "' . $last->format('Y-m-d H:i:s') . '"  WHERE `devise`.`code` = "' . $obj->symbol .  '";');
                $pdo->query('UPDATE `devise` SET `id_cmc` = ' . $obj->id . ', `name_cmc` = "' . $obj->name . '"  WHERE `devise`.`code` = "' . $obj->symbol . '";');
                $pdo->query('UPDATE `devise` SET `id_cmc` = null, `name_cmc` = null  WHERE `devise`.`code` = "' . $obj->symbol . '" AND `devise`.`nom` != "' . $obj->name . '";');
                echo 'UPDATE `devise` SET `id_cmc` = null, `name_cmc` = null  WHERE `devise`.`code` = "' . $obj->symbol . '" AND `devise`.`nom` != "' . $obj->name . '";'; 
// var_dump(count($pdo->query('SELECT * FROM devise WHERE `id_cmc` = "' . $obj->id . '"', PDO::FETCH_ASSOC))); exit;

//                if (empty($pdo->query('SELECT * FROM devise WHERE `id_cmc` = "' . $obj->id . '"', PDO::FETCH_ASSOC)))
//                    $pdo->query('INSERT INTO `devise` (`id_cmc`, `name_cmc`) VALUES ("' . $obj->id . '", "' . $obj->name . '");');
            } 
//            exit;
            //var_dump($arrayResponse->data); exit;
            if (count($arrayResponse->data) == 1) {

//var_dump($arrayResponse->data); exit;
                $obj = $arrayResponse->data[0];

//       ["id"]=>
//  int(3330)
//  ["name"]=>
//  string(20) "Paxos Standard Token"
//  ["symbol"]=>
//  string(3) "PAX"
//  ["slug"]=>
//  string(20) "paxos-standard-token"
//  ["is_active"]=>
//  int(1)
//  ["rank"]=>
//  int(38)
//  ["first_historical_data"]=>
//  string(24) "2018-09-27T20:54:23.000Z"
//  ["last_historical_data"]=>
//  string(24) "2019-08-26T08:14:09.000Z"
//  ["platform"]=>
//  object(stdClass)#7 (5) {
//    ["id"]=>
//    int(1027)
//    ["name"]=>
//    string(8) "Ethereum"
//    ["symbol"]=>
//    string(3) "ETH"
//    ["slug"]=>
//    string(8) "ethereum"
//    ["token_address"]=>
//    string(42) "0x8e870d67f660d95d5be530380d0ec0bd388289e1"
//       $first = Datetime::createFromFormat('Y-m-d\TH:i:s.000Z', $obj->first_historical_data);
                $first = new DateTime();
                $first->setTimestamp(strtotime($obj->first_historical_data));
//       $last = Datetime::createFromFormat(Datetime::ATOM, $obj->last_historical_data);
                $last = new DateTime();
                $last->setTimestamp(strtotime($obj->last_historical_data));

//var_dump($first, $last); exit;
                echo 'UPDATE `devise` SET `id_cmc` = ' . $obj->id . ', `name_cmc` = "' . $obj->name . '", `first_historical_data_cmc` = "' . $first->format('Y-m-d H:i:s') . '", `last_historical_data_cmc` = "' . $last->format('Y-m-d H:i:s') . '"  WHERE `devise`.`code` = "' . $obj->symbol . '" AND `devise`.`nom` = "' . $obj->name . '";';

//       if (!$pdo->query('UPDATE `devise` SET `id_cmc` = ' . $obj->id . ', `name_cmc` = "' . $obj->name . '", `first_historical_data_cmc` = "' . $first->format('Y-m-d H:i:s') . '", `last_historical_data_cmc` = "' . $last->format('Y-m-d H:i:s') . '"  WHERE `devise`.`code` = "' . $obj->symbol . '" AND `devise`.`nom` = "' . $obj->name . '";')) {
//           $pdo->query('INSERT INTO `devise` (`id_cmc`, `name_cmc`, `first_historical_data_cmc`, `last_historical_data_cmc`) VALUES (' .$obj->id . ', ' . $obj->name . ', "' . $first->format('Y-m-d H:i:s') .'", ' . $last->format('Y-m-d H:i:s') .'");');
//        
//       }
                //var_dump($obj);
            } else {
                var_dump($arrayResponse->data);
                exit;
            }
        }
//exit;
    }

//$asp = new Aspirateur('2019-01-01', '2019-08-20', $row['code']);
//}

?? crypto-cours | ??? Delete
?? .DS_Store | ?? Edit | ??? Delete
?? Aspirateur.php | ?? Edit | ??? Delete
?? update.php | ?? Edit | ??? Delete