rcindex.php

<?php

echo "<h1>Roast Coins API<br /></h1>";
echo "<ul><li><a href="full_index.php">Full Index of all Transactions</a></li>";
echo "<li><a href="pending.php">Pending Transactions</a></li>";
echo "<li><a href="completed.php">Completed Transactions</a></li>";
echo "<li>Get Transactions by External Address:<br /><li>get_transactions_by_external_address.php?external=EXTERNAL_ADDRESS</li></li>";
echo "<li>Get Transactions by Transaction ID:<br /><li>get_transactions_by_txid.php?txid=BLOCKCHAIN_TRANSACTION_ID</li></li>";
echo "<li>Get Transactions by Blockhash:<br /><li>get_transactions_by_blockhash.php?blockhash=BLOCKCHAIN_BLOCKHASH</li></li>";
echo "<li>Get Transactions by Crypto Code and External Address:<br /><li>get_crypto_symbol_by_external_address.php?cryptocode=XYZ?external=EXTERNAL_ADDRESS</li></li>";
echo "<li>Get Transactions by Timestamp and External Address:<br /><li>get_external_address_by_timestamp.php?timestamp=UNIX_TIMESTAMP?external=EXTERNAL_ADDRESS</li></li>";
echo "</ul><br />";

/*Template for GETs
require_once 'config.php';
$conn = mysql_connect($db_host,$db_user,$db_pass)
or die ('Error connecting to mysql!  Please check config.php and your database for any inconsistencies.');

//SQL query executed returning an array
//Use a while loop to print each line by ID then append with the newline character
/*Template for GETS with variables
//GET the var1 and var2

$var1 = htmlspecialchars($_GET["var1"])

//GET var2

$var2 = htmlspecialchars($_GET["var2"])
//Comment this below section an modify it to your liking if implementing your own custom external addresses
//the regular expression for validating ripple addresses

$ripple_exp = '/^r[rpshnaf39wBUDNEGHJKLM4PQRST7VWXYZ2bcdeCg65jkm8oFqi1tuvAxyz]{27,35}$/';

//validate the passed external address, first by maximum valid length then by regular expression
if(strlen($external) > 53) {
    $error_message .= 'The external address you entered does not appear to be valid.<br />';
  }  elseif (!preg_match($ripple_exp,$external)) {
	  $error_message .= 'The external address you entered does not appear to be valid.<br />';
  }
 
 //produce error messages, if any
if(strlen($error_message) > 0) {
    died($error_message);
  }
  */
  /*
//assign SQL to a variable for query execution
//Ensure to add WHERE keyword to below query, especially important when using GET variables!
$sql = "SELECT id, crypto_symbol, crypto_address, external_address, direction,  timestamp, finished FROM coin_index;";
//connect to the database, execute the $sql, store the returned array within $result
//script exits gracefully if connection cannot be established
$result = $conn->query($sql);

//if the returned array has data
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Crypto Symbol: " . $row["crypto_symbol"]. " - Cryptocurrency Address: " . $row["crypto_address"].
" - External Address: " . $row["external_address"].
 " - Time-stamp: " . $row["timestamp"]. " - Direction: " . $row["direction"]. " - Finished: " . $row["finished"]. "<br />";
    }
} else {
          //else there were no results, notify RC operator
    echo "0 results";
}
$conn->close();
*/
?>