Php,mysql calculating distances and sorting according to latitude and longitude

The calculation formula given on the net is this:

• Lng1 represents a point of latitude and longitude, and Lat2 Lng2 represents the B-point latitude and longitude
• A = Lat1–lat2 is two points of latitude difference B = lng1-lng2 is two point longitude difference
• 6378.137 is the radius of the Earth, the unit is kilometer
• The calculated result is measured in kilometers.

Select *,(2 * 6378.137* ASIN(SQRT(POW (SIN(PI()*(111.86141967773438-Lng/ the),2)+COS(PI()*33.07078170776367/ the)* COS(Lat* PI()/ the)*POW (SIN(PI()*(33.07078170776367-Lat/ the),2)))) asJuli from' Area 'Order  byJuliASCLimit0, -

Php,mysql calculating distances and sorting according to latitude and longitude