function getLocation($self = false) { if ($self) { $ip = $_SERVER['REMOTE_ADDR']; } else { $ip = $_GET['ip']; } $key = '7fc7e88c3b4c0e83127bce07a721043839574567756c1a0b85a4518ce1fa8fbf'; $yql_base_url = "http://query.yahooapis.com/v1/public/yql"; $yql_query = "select * from ip.location where ip='{$ip}' and key='{$key}'"; $yql_query_url = $yql_base_url . "?q=" . urlencode($yql_query) . "&format=json&env=store://datatables.org/alltableswithkeys"; $locResult = getResultFromYQL($yql_query_url); $markup = 'Failed to convert IP to Location, please try again'; if (isset($locResult['query']) && isset($locResult['query']['results']) && !empty($locResult['query']['results']['Response'])) { $resp = $locResult['query']['results']['Response']; $markup = ''; if ($self) { $markup .= "<h2>Your IP Address = {$_SERVER['REMOTE_ADDR']}</h2>"; } else { $markup .= "<h2>Entered IP Address = {$_GET['ip']}</h2>"; } $markup .= '<table id="resultarea" border="1" cellpadding="20" align="center">'; foreach ($resp as $key => $value) { if (empty($value)) { $value = "-"; } $markup .= <<<MARKUP <tr><td>{$key}</td><td>{$value}</td></tr> MARKUP; } $markup .= '</table>'; } if ($self) { return $markup; } else { echo $markup; } }
function find($location, $query) { $yelpql = "use 'http://github.com/spullara/yql-tables/raw/master/yelp/yelp.review.search.xml' as yelp; select * from yelp where term='" . $query . "' and location='" . $location . "' and ywsid='AMP_5mIt_VCZiw7xYK0DJw'"; $result = getResultFromYQL($yelpql); return $result->query->results; }
function weather($woeid) { $yql = 'select * from weather.forecast where woeid=' . $woeid; $result = getResultFromYQL($yql); return $result->query->results; }
function news() { $yelpql = 'select title from rss where url="http://rss.news.yahoo.com/rss/topstories" LIMIT 10'; $result = getResultFromYQL($yelpql); return $result->query->results; }
<body> <h1>Movie Search</h1> <form action="" method="get"> <?php echo 'Search for <input type="text" name="q" value="'; if (empty($_GET['q'])) { $_GET['q'] = ""; } // Echo the query in the search text field $query = htmlentities($_GET['q'], ENT_QUOTES, 'UTF-8'); echo $query . '" /> <input type="submit" value="Go" /></form>'; // If there is a query if (!empty($_GET['q'])) { echo '<hr />'; $url = 'select * from boss.search where q="The Artist" and sites="imdb.com,movies.yahoo.com,indiatimes.com" and ck="dj0yJmk9YWF3ODdGNWZPYjg2JmQ9WVdrOWVsWlZNRk5KTldFbWNHbzlNVEEyTURFNU1qWXkmcz1jb25zdW1lcnNlY3JldCZ4PTUz" and secret="a3d93853ba3bad8a99a175e8ffa90a702cd08cfa"'; $res = getResultFromYQL($url); foreach ($res->query->results->bossresponse->web->results->result as $item) { echo '<div class="result"><a href="' . $item->url . '">' . $item->title->content . '</a><br/>' . $item->abstract->content . '<br><font color="green">' . $item->dispurl->content . '</font></div>'; } } /** * Function to get results from YQL * * @param String $yql_query - The YQL Query * @param String $env - Environment in which the YQL Query should be executed. (Optional) * * @return object response */ function getResultFromYQL($yql_query) { $yql_base_url = "http://query.yahooapis.com/v1/public/yql";
function stock($symbol) { $yelpql = "\n\tUSE 'http://www.datatables.org/yahoo/finance/yahoo.finance.quotes.xml' AS yahoo.finance.quotes;select * from yahoo.finance.quotes where symbol in ('{$symbol}')"; $result = getResultFromYQL($yelpql); return $result->query->results; }
function getResultFromYQL($yql_query) { $session = curl_init($yql_query); curl_setopt($session, CURLOPT_RETURNTRANSFER, true); $json = curl_exec($session); curl_close($session); return json_decode($json, true); } if (!empty($_GET['ip'])) { $ip = $_GET['ip']; $key = '7fc7e88c3b4c0e83127bce07a721043839574567756c1a0b85a4518ce1fa8fbf'; $yql_base_url = "http://query.yahooapis.com/v1/public/yql"; $yql_query = "select * from ip.location where ip='{$ip}' and key='{$key}'"; $yql_query_url = $yql_base_url . "?q=" . urlencode($yql_query) . "&format=json&env=store://datatables.org/alltableswithkeys"; echo "<pre>"; var_dump(getResultFromYQL($yql_query_url)); echo "</pre>"; } else { $html = <<<MARKUP <html> <head><title>IP Locator</title></head> <body> <form method="GET"> <p>Enter IP Address: <input type="text" id="ip" name="ip" /></p> <p><input type="submit" value="Submit" /> </form> </body> </html> MARKUP; echo $html; }