lundi 4 décembre 2017

Complex query using query builder in laravel

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