How to bind parameters to a raw DB query in Laravel that’s used on a model?

by

OK, after some experimenting, here’s the solution that I came up with:

$property = 
    Property::select(
        DB::raw("title, lat, lng, ( 
            3959 * acos( 
                cos( radians(  ?  ) ) *
                cos( radians( lat ) ) * 
                cos( radians( lng ) - radians(?) ) + 
                sin( radians(  ?  ) ) *
                sin( radians( lat ) ) 
            )
       ) AS distance")
    )
    ->having("distance", "<", "?")
    ->orderBy("distance")
    ->take(20)
    ->setBindings([$lat, $lng, $lat,  $radius])
    ->get();

Basically, setBindings has to be called on the query. Wish this was documented!

More Related Contents:

  1. PDOException SQLSTATE[HY000] [2002] No such file or directory
  2. belongsToMany relationship in Laravel across multiple databases
  3. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  4. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  5. Laravel Eloquent get results grouped by days
  6. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  7. Change name of Laravel’s created_at and updated_at
  8. PHP Laravel: No connection could be made because the target machine actively refused it
  9. How to create a database-driven multi-level navigation menu using Laravel
  10. PHP PDO and Mysql [closed]
  11. How to properly set up a PDO connection
  12. PHP PDO prepared statements
  13. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  14. How to do this in Laravel, subquery where in
  15. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  16. mysql PDO how to bind LIKE
  17. Download files in laravel using Response::download
  18. How do I redirect after download in Laravel?
  19. How do I loop through a MySQL query via PDO in PHP?
  20. Could not open input file: artisan
  21. “No such file or directory” or “No such host is known” when running migrations
  22. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  23. How to handle PDO exceptions [duplicate]
  24. How to create a subquery using Laravel Eloquent?
  25. Eloquent model mass update
  26. How do I get database column names in Laravel?
  27. PDO and MySQL Fulltext searches
  28. Eloquent many-to-many-to-many – how to load distant relation easily
  29. How to send data using redirect with Laravel
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment