API

1> All Currency Api

http://finance.yahoo.com/webservice/v1/symbols/allcurrencies/quote

2>Get data by passing city name

http://api.openweathermap.org/data/2.5/forecast/daily?q=Ahmedabad&mode=json&units=metric&cnt=7

3>Get Data by passing Lat & Long

http://api.openweathermap.org/data/2.5/forecast/daily?lat=23&lon=72&cnt=7&mode=json

4> MySQL Query to get radius of longitude and latitude

$distance = 10;
$latitude = 37.295092;
$longitude = -121.896490;

$sql = "SELECT loc.*, (((acos(sin(($latitude*pi()/180)) * sin((`latitude`*pi()/180))+cos(($latitude*pi()/180)) * cos((`latitude`*pi()/180)) * cos((($longitude - `longitude`)*pi()/180))))*180/pi())*60*1.1515) AS `distance` FROM table_with_lonlat_ref loc HAVING distance < $distance";

5>

WORLD CITY LOCATIONS DATABASE

http://askbahar.com/2010/07/02/world-city-locations-database/

6>  Get Currency Code

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s