Simple php Coding: 01/12/20

Order place code start
<?php
define('TIMEZONE', 'Asia/kolkata');
date_default_timezone_set(TIMEZONE);
?>
<?php
include "connect.php";
//bid-ask price
$url = "https://api.hitbtc.com/api/2/public/ticker/DOGEBTC";
$dataDOGEBTC = json_decode(file_get_contents($url), true);
$symbol=$dataDOGEBTC['symbol'];
$bid=$dataDOGEBTC['bid'];
$ask=$dataDOGEBTC['ask'];

echo "bid : "; echo $bid; echo " ";
echo "ask :"; echo $ask; echo " ";
//sellprice
$sellprice1=$bid*3/1000; $sellprice2=$bid+$sellprice1;
$sellprice=number_format($sellprice2,11);

echo "buy :"; echo $bid; echo " ";
echo "sell price :"; echo $sellprice; echo " ";

//BALANCE
$sqlbal = mysqli_fetch_array(mysqli_query($connection, "SELECT * FROM balance where currency='BTC' AND available >= 0.00000026"));
$id= $sqlbal['id'];
$currency=$sqlbal['currency'];
$available=$sqlbal['available'];
$reserved=$sqlbal['reserved'];
//
echo "S.no ". $id; echo " "; echo "Symbol ". $currency; echo " "; echo "available ". $available; echo " "; echo "reserved ". $reserved; echo " ";
?>
<?php
$available50=$available/2;
$quantity0=$available/$bid; $quantity1=$quantity0/10;
$quantity3 =floor($quantity0 / 10) * 10;
$quantity2=number_format($quantity3,0);
echo "my quantity : "; echo $quantity0; echo " ";
echo "my quantity2 price : "; echo $quantity2; echo " ";
echo "my quantity3 price : "; echo $quantity3; echo " ";
?>

<?php
$sqlbal1 = "SELECT * FROM balance where currency='BTC' AND available >= 0.00000026";
$result123 = $connection->query($sqlbal1);
if ($result123->num_rows > 0) {
// output data of each row
while($row = $result123->fetch_assoc()) {

echo "id: " . $row["id"]. " - Name: " . $row["currency"]. " -available " . $row["available"]." -reserved" .$row["reserved"]. " ";
//echo "S.no ". $id; echo " "; echo "Symbol ". $currency; echo " "; echo "available ". $available; echo " "; echo "reserved ". $reserved; echo " ";

//order on
$symbol = DOGEBTC;
$side = buy;
$type = limit;
$price=$bid;
$quantity=$quantity2;
$timeInForce= GTC;
$date = Date("Y-m-d H:i:s");

$ch = curl_init();
//do a post
curl_setopt($ch,CURLOPT_URL,"https://api.hitbtc.com/api/2/order");
curl_setopt($ch, CURLOPT_USERPWD, 'cHxtLRjcqNVLu7_rZiORQMtbkhD-ZilR:trkn4Y8t3KxpJUVvJjoZRTnkfSnHp-5K'); // API AND KEY
curl_setopt($ch, CURLOPT_POST,1);
curl_setopt($ch,CURLOPT_POSTFIELDS,"symbol=$symbol&side=$side&price=$price&quantity=$quantity&type=$type&timeInForce=$timeInForce");
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
//return the result of curl_exec,instead
//of outputting it directly
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/x-www-form-urlencoded'));
curl_setopt($ch, CURLOPT_HTTPHEADER, array('accept: application/json'));
//curl_setopt($ch,CURLOPT_HTTPHEADER,$header);
$result=curl_exec($ch);
curl_close($ch);
$result=json_decode($result);
echo"<pre>";
print_r($result);
//order end

}
} else {
echo "0 results123";
}
?>
//insert order details
<?php
$sqlupd = "SELECT * FROM balance where currency='BTC' AND available >= 0.00000026 ";
$resultupd = $connection->query($sqlupd);
if ($resultupd->num_rows > 0) {
// output data of each row
while($rowupd = $resultupd->fetch_assoc()) {

$sql ="INSERT INTO trade (symbol,price,sellprice,side,type,quantity,quantity1,quantity2,date) VALUES('$symbol', '$price','$sellprice','$side','$type','$quantity','$quantity','0','$date')";
if ($connection->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . " " . $connection->error;
}

}
} else {
echo "0 results balance low";
}
?>
////////////sell order code ////////////////

<?php
include "connect.php";
//delete row
//$sqldel = "DELETE FROM trade WHERE quantity1 <= 0";

//if ($connection->query($sqldel) === TRUE) {
// echo "Record deleted successfully";
//} else {
// echo "Error deleting record: " . $connection->error;
//}
//TRADE TABLE
//$sql = mysqli_fetch_array(mysqli_query($connection, "SELECT * FROM trade order by id asc limit 1"));
$sqlsell = mysqli_fetch_array(mysqli_query($connection, "SELECT * FROM trade where symbol='DOGEBTC' order by price desc limit 1"));
$idsell= $sqlsell['id'];
$symbolsell= $sqlsell['symbol'];
$pricesell= $sqlsell['price'];
$sidesell= $sqlsell['side'];
$typesell= $sqlsell['type'];
$quantitysell= $sqlsell['quantity'];
$quantity1sell= $sqlsell['quantity1'];
$quantity2sell= $sqlsell['quantity2'];
$sellpricesell= $sqlsell['sellprice'];
?>
<?php
echo "S.no : ". $idsell; echo " ";
echo "symbol : ". $symbolsell; echo" ";
echo "price : ". $pricesell; echo" ";
echo "side : ". $sidesell; echo" ";
echo "type : ". $typesell; echo" ";
echo "quantity : ". $quantitysell; echo" ";
echo "quantity1 : ". $quantity1sell; echo" ";
echo "quantity2 : ". $quantity2sell; echo" ";
echo "sellprice : ". $sellpricesell; echo" ";

?>

<?php
//$quantity1update=$quantity1-$available;
$quantity1update=$quantity1sell-$quantity1sell;
//$quantity2update=$quantity2+$available;
$quantity2update=$quantity2sell+$quantity1sell;?>
<?php echo $quantity1update; echo " quantity 2"; echo $quantity2update; echo " "; ?>
<?php
$sqlbal1sell = "SELECT * FROM balance where currency='DOGE' AND available >= 10 ";
$result123sell = $connection->query($sqlbal1sell);
if ($result123sell->num_rows > 0) {
// output data of each row
while($rowsell = $result123sell->fetch_assoc()) {

echo "id: " . $rowsell["id"]. " - Name: " . $rowsell["currency"]. " -available " . $rowsell["available"]." -reserved" .$rowsell["reserved"]. " ";
//echo "S.no ". $id; echo " "; echo "Symbol ". $currency; echo " "; echo "available ". $available; echo " "; echo "reserved ". $reserved; echo " ";

//order on
$symbolsell = DOGEBTC;
$sidesell = sell;
$typesell = limit;
$pricesell=$sellpricesell;
$quantitysell=$quantity1sell;
$timeInForcesell= GTC;

$ch1 = curl_init();
//do a post
curl_setopt($ch1,CURLOPT_URL,"https://api.hitbtc.com/api/2/order");
curl_setopt($ch1, CURLOPT_USERPWD, 'cHxtLRjcqNVLu7_rZiORQMtbkhD-ZilR:trkn4Y8t3KxpJUVvJjoZRTnkfSnHp-5K'); // API AND KEY
curl_setopt($ch1, CURLOPT_POST,1);
curl_setopt($ch1,CURLOPT_POSTFIELDS,"symbol=$symbolsell&side=$sidesell&price=$pricesell&quantity=$quantitysell&type=$typesell&timeInForce=$timeInForcesell");
curl_setopt($ch1, CURLOPT_RETURNTRANSFER,1);
//return the result of curl_exec,instead
//of outputting it directly
curl_setopt($ch1, CURLOPT_HTTPHEADER, array('Content-Type: application/x-www-form-urlencoded'));
curl_setopt($ch1, CURLOPT_HTTPHEADER, array('accept: application/json'));
//curl_setopt($ch,CURLOPT_HTTPHEADER,$header);
$resultsell=curl_exec($ch1);
curl_close($ch1);
$resultsell=json_decode($resultsell);
echo"<pre>";
print_r($resultsell);

//order end

}
} else {
echo "0 sell order place doge balance low";
}
?>
//update trade table
<?php
$sqlupd = "SELECT * FROM balance where currency='DOGE' AND available >= 10 ";
$resultupd = $connection->query($sqlupd);
if ($resultupd->num_rows > 0) {
// output data of each row
while($rowupd = $resultupd->fetch_assoc()) {
// $sql3 ="UPDATE trade SET quantity1='$quantity1update' , quantity2='$quantity2update' WHERE id='$id' ";
$sql3 ="UPDATE trade SET quantity1='$quantity1update' , quantity2='$quantity2update' WHERE id='$idsell' ";
if ($connection->query($sql3) === TRUE) {
echo "record updated successfully";
} else {
echo "Error: " . $sql3 . " " . $connection->error;
}

}
} else {
echo "0 balance low";
}
?>
Order place code end
-------------------------------------------------------------------------------------
balance code start

<?php
	//delete row
	include "connect.php";
	$sqldel = "DELETE FROM trade WHERE quantity1 <= 0";

	if ($connection->query($sqldel) === TRUE) {
	echo "Record deleted successfully";
	} else {
	echo "Error deleting record: " . $connection->error;
	}
	?>
	<?php
	$ch = curl_init('https://api.hitbtc.com/api/2/trading/balance');
	curl_setopt($ch, CURLOPT_USERPWD, 'api_key : secret_key'); // API AND KEY
	curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
	curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/x-www-form-urlencoded'));
	curl_setopt($ch, CURLOPT_HTTPHEADER, array('accept: application/json'));
	$return = curl_exec($ch);
	curl_close($ch);
	//print_r($return);
	// $data = json_decode(file_get_contents($ch), true);
	if (time()-filemtime($url) > 10) { // file older than 20 minutes

	$json = file_get_contents($return, true); //getting the file content
	$decode = json_decode($return, true); //getting the file content as array

	$fp = fopen('balance.json', 'w');
	fwrite($fp, json_encode($decode));
	fclose($fp);

	echo $json;

	} else {
	// file younger than 20 minutes
	$json = file_get_contents($url);
	// echo the JSON
	echo $json;
	}
	?>

	<div class="container box">
	<h3 align="center">Import JSON File Data into Mysql Database in PHP</h3><br />
	<?php
	$sql123 = "TRUNCATE TABLE balance ";

	if ($connection->query($sql123) === TRUE) {
	echo "Record updated successfully";
	} else {
	echo "Error updating record: " . $connection->error;
	}
	$query = '';
	$table_data = '';
	$filename = "balance.json";
	$data = file_get_contents($filename); //Read the JSON file in PHP
	$array = json_decode($data, true); //Convert JSON String into PHP Array
	foreach($array as $row) //Extract the Array Values by using Foreach Loop
	{
	$query .= "INSERT INTO balance(currency, available,reserved) VALUES ('".$row["currency"]."', '".$row["available"]."','".$row["reserved"]."'); "; // Make Multiple Insert Query
	$table_data .= '
	<tr>
	<td>'.$row["currency"].'</td>
	<td>'.$row["available"].'</td>
	<td>'.$row["reserved"].'</td>
	</tr>
	'; //Data for display on Web page
	}
	if(mysqli_multi_query($connection, $query)) //Run Mutliple Insert Query
	{
	echo '<h3>Imported JSON Data</h3><br />';
	echo '
	<table class="table table-bordered">
	<tr>
	<th width="45%">currency</th>
	<th width="10%">available</th>
	<th width="45%">reserved</th>
	</tr>
	';
	echo $table_data;
	echo '</table>';
	}

	$sql = "SELECT * FROM balance";
	$result1 = $connection->query($sql);

	if ($result1->num_rows > 0) {
	// output data of each row
	while($row = $result1->fetch_assoc()) {
	echo "id: " . $row["id"]. " - Currency: " . $row["currency"]. " " . $row["available"]. " " . $row["reserved"]. "<br>";
	}
	} else {
	echo "0 results";
	}

	?>


	?>

blance code end

full coding available on https://github.com/aksharmty/hitbtc

Simple php Coding

Sunday, 12 January 2020

Hitbtc auto trading bot in php

Cheap Web Hosting Service

Choose for best experience with

sakhihosting

Learn Mantra Sadhana on Phone

No need leave your home

akshar mantra tantra yantra

Share your ideas and short

Post Article for permanent backlink

Post Article & thoughts Now

Free Traffic Exchange

send or receive traffic