<?php
require_once 'easybitcoin.php';
$tesla = new Bitcoin('tesla', 'swag', 'localhost', '1857');
$single = $_GET['single'];
$blockCount = $tesla->getblockcount();
$lastBlocks = "";
if ($single == "false") {
for ($i = $blockCount; $i > $blockCount - 10; $i--) {
$blockHash = $tesla->getblockhash($i);
$info = $tesla->getblock($blockHash);
$lastBlocks .= "<tr><td>" . $info['height'] . "</td><td>" . number_format($info['difficulty'], 3) . "</td><td>" . $info['confirmations'] . "</td></tr>";
}
} else {
$blockHash = $tesla->getblockhash($blockCount);
$info = $tesla->getblock($blockHash);
$lastBlocks = "<tr><td>" . $info['height'] . "</td><td>" . number_format($info['difficulty'], 3) . "</td><td>" . $info['confirmations'] . "</td></tr>";
}
echo $lastBlocks;
<html>
<?php
require_once 'easybitcoin.php';
$tesla = new Bitcoin('tesla', 'swag', 'localhost', '1857');
$credFile = file_get_contents('mysql.properties');
$credRows = explode("\r\n", $credFile);
foreach ($credRows as $value) {
$valueSplit = explode("::", $value);
$creds[$valueSplit[0]] = $valueSplit[1];
}
$db = new PDO($creds["serverInfo"], $creds["username"], $creds["password"]);
for ($i = 0; $i < $tesla->getblockcount(); $i++) {
$hash = $tesla->getblockhash($i);
$blockData = $tesla->getblock($hash, true);
foreach ($blockData['tx'] as $tx) {
foreach ($tx['vout'] as $out) {
if (array_key_exists('addresses', $out['scriptPubKey'])) {
$db->exec("INSERT INTO `addresses` (address, balance) VALUES ('" . $out['scriptPubKey']['addresses'][0] . "', '" . $out['value'] . "') ON DUPLICATE KEY UPDATE balance = balance + " . $out['value']);
}
}
}
//$stmt = $db->prepare("SELECT * FROM table WHERE id=:id AND name=:name");
//$stmt->execute(array(':id' => $id, ':name' => $name));
//$testRows = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
?>
</html>
