function createProcedures($mysqli, $api_data)
{
foreach ($api_data as $entry) {
$procedure = $entry->procedure;
$proc_params = getInputParams($entry);
print_r($entry->procedure->proc_name);
print_r(": \n");
print_r($proc_params);
print_r("\n\n\n");
if (isset($proc_params) && isset($procedure->proc_body)) {
$sql_drop = 'DROP PROCEDURE IF EXISTS ' . $procedure->proc_name . "; \n";
$sql_create = "CREATE PROCEDURE " . $procedure->proc_name . "(" . $proc_params . ") " . "BEGIN \n" . $procedure->proc_body . " \nEND; \n\n";
if (!$mysqli->query($sql_drop) || !$mysqli->query($sql_create)) {
return false;
}
}
}
return true;
}
if (isset($_GET["name"])) {
$query = "http://dev.markitondemand.com/MODApis/Api/v2/Lookup/json?input=" . urlencode($_GET["name"]);
$result = file_get_contents($query) or die("Unable to retrieve values from Market on Demand");
echo $result;
}
} else {
if (isset($_GET["operation"]) && $_GET["operation"] == "getstock") {
if (isset($_GET["symbol"])) {
$query = "http://dev.markitondemand.com/MODApis/Api/v2/Quote/json?symbol=" . urlencode($_GET["symbol"]);
$result = file_get_contents($query) or die("Unable to retrieve values from Market on Demand");
echo $result;
}
} else {
if (isset($_GET["operation"]) && $_GET["operation"] == "charts") {
if (isset($_GET["symbol"])) {
$query = "http://dev.markitondemand.com/MODApis/Api/v2/InteractiveChart/json?parameters=" . urlencode(getInputParams($_GET["symbol"], $_GET["duration"], $_GET["period"]));
$result = file_get_contents($query) or die("Unable to retrieve values from Market on Demand");
echo $result;
}
} else {
if (isset($_GET["operation"]) && $_GET["operation"] == "news") {
if (isset($_GET["symbol"])) {
$query = "https://ajax.googleapis.com/ajax/services/search/news?v=1.0&userip=173.194.204.141&q=" . urlencode($_GET["symbol"]);
$result = file_get_contents($query) or die("Unable to retrieve values from Market on Demand");
echo $result;
}
} else {
if (isset($_GET["operation"]) && $_GET["operation"] == "bingnews") {
if (isset($_GET["symbol"])) {
$accountKey = 'dwO9E9fD4soMHF83khoFbhWoSdMSvqYjsj9cfAnUSFM';
$ServiceRootURL = 'https://api.datamarket.azure.com/Bing/Search/v1/';
