Search content
Sort by
Showing 19 of 19 results by nzbmaster
Re: $40 in BTC for some php/mysql coding help, quick problem
Assuming the primary key for db1 is 'ID':
$db->commit();
?>
Code:
$db->beginTransaction();
$Process = $db->prepare("UPDATE db1 SET num = ?, usd = ?, btc = ?, date = ? WHERE ID = ?");
$Process->execute(array($_GET['op'], $_POST['usd'], $_POST['btc'], date('Y-m-d H:i:s'), $r['id']));
echo 'Processed.
';$Process = $db->prepare("UPDATE db1 SET num = ?, usd = ?, btc = ?, date = ? WHERE ID = ?");
$Process->execute(array($_GET['op'], $_POST['usd'], $_POST['btc'], date('Y-m-d H:i:s'), $r['id']));
echo 'Processed.
$db->commit();
?>
Re: $40 in BTC for some php/mysql coding help, quick problem
You don't really provide enough code to do this (ie what variable is table b's data stored in, assuming its already been queried). However I would hazard it would be something like the following (assuming table b's data is already queried and stored in $tableB as an array):
echo '
'.$r['id'].'
';
foreach($tableB as $b)
{
if ($b['ID'] == $r['id'])
{
echo ' '.$b['msg'].' ';
}
}
echo '
';
?>
Code:
echo '
'.$r['id'].'
';
foreach($tableB as $b)
{
if ($b['ID'] == $r['id'])
{
echo '
}
}
echo '
?>
Here's a super quick take on your request. Call via url with ?coin=ftc for example or change $defaultCoin to the coin you want the last hashrate for.
It's probably easier to ask the dev to include the data in the json output though...
$defaultCoin = 'cnc';
$cryptoCurrencies = array(
'ppc'=>'PPCoin',
'trc'=>'Terracoin',
'frc'=>'Freicoin',
'bbq'=>'BBQCoin',
'nvc'=>'Novacoin',
'ftc'=>'Feathercoin',
'bte'=>'Bytecoin',
'btb'=>'BitBar',
'cnc'=>'CHNCoin',
'jkc'=>'JKC',
'frk'=>'Franko',
'gld'=>'Goldcoin'
);
$baseUrl = 'http://%s.cryptocoinexplorer.com/chain/%s/q/nethash/1/-1';
$coin = (isset($_GET['coin']) && array_key_exists($_GET['coin'], $cryptoCurrencies)) ? $_GET['coin'] : $defaultCoin;
$url = sprintf($baseUrl, $coin, $cryptoCurrencies[$coin]);
$rawdata = file_get_contents($url);
if ($rawdata)
{
if (preg_match("/\n(?P[a-z,]+)\nSTART DATA\n(?P.*?)\n/i", $rawdata, $matches))
{
$headers = explode(',', $matches['headers']);
$data = explode(',', $matches['data']);
$result = array_combine($headers, $data);
echo $result['netHashPerSecond'];
//print_r($result);
}
}
?>
It's probably easier to ask the dev to include the data in the json output though...
Code:
$defaultCoin = 'cnc';
$cryptoCurrencies = array(
'ppc'=>'PPCoin',
'trc'=>'Terracoin',
'frc'=>'Freicoin',
'bbq'=>'BBQCoin',
'nvc'=>'Novacoin',
'ftc'=>'Feathercoin',
'bte'=>'Bytecoin',
'btb'=>'BitBar',
'cnc'=>'CHNCoin',
'jkc'=>'JKC',
'frk'=>'Franko',
'gld'=>'Goldcoin'
);
$baseUrl = 'http://%s.cryptocoinexplorer.com/chain/%s/q/nethash/1/-1';
$coin = (isset($_GET['coin']) && array_key_exists($_GET['coin'], $cryptoCurrencies)) ? $_GET['coin'] : $defaultCoin;
$url = sprintf($baseUrl, $coin, $cryptoCurrencies[$coin]);
$rawdata = file_get_contents($url);
if ($rawdata)
{
if (preg_match("/\n(?P[a-z,]+)\nSTART DATA\n(?P.*?)\n/i", $rawdata, $matches))
{
$headers = explode(',', $matches['headers']);
$data = explode(',', $matches['data']);
$result = array_combine($headers, $data);
echo $result['netHashPerSecond'];
//print_r($result);
}
}
?>
try blockchai.info i think they have some option for this. If you have a cellphone with android, you will see more options to buy btc, and maybe something more suitable for you.
EDIT: try https://www.virwox.com/ they accept paypal
EDIT: try https://www.virwox.com/ they accept paypal
Paypal->BTC via Virwox works well but can be a bit slow. Search the forums for a guide.
