36 lines
899 B
PHP
36 lines
899 B
PHP
<?php
|
|
|
|
include('connection.php');
|
|
include('coinmarketcap.php');
|
|
|
|
$conn = OpenCon();
|
|
|
|
$selectSql = "SELECT tokenCode,tokenName FROM Tweets";
|
|
$selectQuery = mysqli_query($conn, $selectSql);
|
|
|
|
$output = "";
|
|
|
|
while($row=mysqli_fetch_assoc($selectQuery)){
|
|
$symbol = str_replace(" ","",$row['tokenCode']);
|
|
$tokenName = str_replace(" ","",$row['tokenName']);
|
|
|
|
$price = GetTokenPrice($symbol );
|
|
$tokenCheckSql = "SELECT * FROM Tokens WHERE symbol='$symbol'";
|
|
if(mysqli_num_rows(mysqli_query($conn, $tokenCheckSql)) <= 0){
|
|
$insertSql = "INSERT INTO Tokens (symbol, price) VALUES('$symbol', $price)";
|
|
if(mysqli_query($conn, $insertSql)){
|
|
|
|
}
|
|
}else{
|
|
$updateSql = "UPDATE Tokens SET price=$price WHERE symbol='$symbol'";
|
|
if(mysqli_query($conn, $updateSql)){
|
|
|
|
}
|
|
}
|
|
$output .= $row['tokenCode'] . ",";
|
|
}
|
|
|
|
|
|
echo substr($output,0,-1);
|
|
|
|
?>
|