Wednesday 6 July 2016

Get Radius in Miles using Latitude & Longitude in MySQL

Here is the trick to find the radius distance in miles directly from the latitude & longitude data store in your mysql table. This is a very helpful trick which i use while creating webservices for mobile apps.


SELECT
  id, (
    3959 * acos (
      cos ( radians(78.3232) )
      * cos( radians( lat ) )
      * cos( radians( lng ) - radians(65.3234) )
      + sin ( radians(78.3232) )
      * sin( radians( lat ) )
    )
  ) AS distance
FROM markers
HAVING distance < 30
ORDER BY distance
LIMIT 0 , 20;

Monday 1 February 2016

Circuit Scribe

A new innovative technique to create electronics circuit with very low cost materials on the paper, checkout the video.

Sunday 3 January 2016

Know Your Provident Fund Balance.

Ever wondered that how much money has been submitted by your employer, you can checkout your EPF (Employer' Provident Balance) just by the click of the mouse.
Here is the link for checking the link for it.

CLICK HERE TO CHECK PROVIDENT FUND



Just fill the form and you will get the provident fund balance to the phone number mentioned by your employer.