guys i really need help in using laravels query builder to execute the query the query below. I dnt seem to know how to get it working in laravel 5.4
$mlat = 40.792866;
$mlng = -74.042130;
$radius = 10;
// Search the rows in the markers table
//change 3959 to 6371 for distance in KM
$sql = sprintf("SELECT address, name, lat, lng, ( 3959 * acos( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) AS distance FROM stores HAVING distance < '%s' ORDER BY distance LIMIT 0 , 20",
mysqli_real_escape_string($oLink,$mlat),
mysqli_real_escape_string($oLink,$mlng),
mysqli_real_escape_string($oLink,$mlat),
mysqli_real_escape_string($oLink,$radius));
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire