Beispiel #1
1
<?php

$db_host = 'localhost';
$db_user = '******';
$db_pass = '******';
$db_name = 'db';
$db_connect = new SafeMysql(array('user' => $db_user, 'pass' => $db_pass, 'db' => $db_name, 'charset' => 'utf8'));
$db_array = $db_connect->getAll("SELECT * from bc_config");
Beispiel #2
0
function giveinfobalance(){
$dblocation = "localhost";
$dbuser = "******";
$dbpasswd = "libertos";
$dbname="bitcoin_db";
$db = new SafeMysql(array('user' => $dbuser, 'pass' => $dbpasswd,'db' => $dbname, 'charset' => 'utf8'));

$kon="1";
$timestamplast=strtotime("2013-06-04");
$today=date("Y-m-d",$timestamplast);	
$todaynow=date("Y-m-d");
	for (;$kon != "0" ;){
	$timestamplast=strtotime("$today");
	$today=date("Y-m-d",$timestamplast+(24*60*60));	
	echo " ,['".$today."',  ";
$result = $db->query("select * from btce_balance where date like \"%$today%\"");
$maximum=0;
while ($row = $db->fetch($result)){ 
	if ($row['balance'] > $maximum){
	$maximum=$row['balance'];
	}
}
		echo "$maximum";
		echo ",";

$result = $db->query("select * from mtgox_balance where data like \"%$today%\"");
$maximum2=0;
while ($row = $db->fetch($result)){ 
	if ($row['balance'] > $maximum2){
	$maximum2=$row['balance'];
	}
}		
		echo "$maximum2";
		echo ", ";
		
		$allmax=$maximum2+$maximum;
		echo "$allmax";
		
		echo "] ";
		if ($today == $todaynow){
		$kon="0";
		}
	}	
	
}
    <script type="text/javascript">
      google.load('visualization', '1', {packages: ['corechart']});
    </script>
    <script type="text/javascript">
      function drawVisualization() {
        var data = google.visualization.arrayToDataTable([
         
		
			<?
ini_set("session.gc_maxlifetime", 3600);
include_once('../safemysql.class.php');
$dblocation = "localhost";
$dbuser = "******";
$dbpasswd = "libertos";
$dbname="bitcoin_db";
$db = new SafeMysql(array('user' => $dbuser, 'pass' => $dbpasswd,'db' => $dbname, 'charset' => 'utf8'));
$stack=array();

$b=0;
$ba=720;
for ($i=0; $i < 60; $i++){
$min=10000;
$max=0;
$result = $db->query("select * from mtgox_ticker order by id desc limit $b,720;");
while ($row = $db->fetch($result)){
	$where=$row['date'];
	if ($row['current'] < $min){
	$min=$row['current'];
	}
	if ($row['current'] > $max){
	$max=$row['current'];