Current path: home/webdevt/cryptoimpot.fr/tools/
?? Go up: /home/webdevt/cryptoimpot.fr
<?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']);
//}