MySQL and PHP calculate distance between two latitude and longitude coordinates.md

Coordinates

<?php
/**
 * Author: Archie, Disono (disono.apd@gmail.com)
 */

namespace App\Models;

class Route
{
  /**
  * Distance
  * Returns the distance in kilometers, assuming earth radius of 6,371 km.
  *
  * @param $lat
  * @param $lng
  *
  * @return string
  */
  private static function distanceStart($lat, $lng)
  {
      return '6371 * 2 * ASIN(SQRT(POWER(SIN((' . $lat .
          ' - ABS(table_name.lat)) * PI() / 180 / 2), 2) + COS(' . $lat .
          ' * PI() / 180) * COS(ABS(table_name.lat) * PI() / 180) * POWER(SIN((' . $lng .
          ' - table_name.lng) * PI() / 180 / 2), 2)))';
  }
}