How to use paginate() with a having() clause when column does not exist in table

by

You can calculate the distance in the WHERE part:

DB::table('posts')
    ->whereRaw($haversineSQL . '<= ?', [$distance])
    ->paginate(10);

If you need the distance value in your application, you’ll have to calculate it twice:

DB::table('posts')
    ->select('posts.*', DB::raw($haversineSQL . ' as distance'))
    ->whereRaw($haversineSQL . '<= ?', [$distance])
    ->paginate(10);

More Related Contents:

  1. Laravel redirect back to original destination after login
  2. Laravel Eloquent groupBy() AND also return count of each group
  3. Eloquent Collection: Counting and Detect Empty
  4. Laravel – Route::resource vs Route::controller
  5. How to install Laravel 4 to a web host subfolder without publicly exposing /app/ folder?
  6. Laravel 4 All Routes Except Home Result in 404 Error
  7. global variable for all controller and views
  8. Eloquent eager load Order by
  9. How can I remove a package from Laravel using PHP Composer?
  10. multiple mail configurations
  11. How to Get the Current URL Inside @if Statement (Blade) in Laravel 4?
  12. Laravel. Use scope() in models with relation
  13. laravel with() method versus load() method
  14. Laravel 4: how to run a raw SQL?
  15. Laravel – Forbidden You don’t have permission to access / on this server
  16. Laravel Eloquent “WHERE NOT IN”
  17. Rollback one specific migration in Laravel
  18. Where can I set headers in laravel
  19. What is the difference between queue:work –daemon and queue:listen
  20. Validation of array form fields in laravel 4 error
  21. How to access model hasMany Relation with where condition?
  22. Eloquent push() and save() difference
  23. Laravel 4: Failed to open stream: Permission denied
  24. Set port for php artisan.php serve
  25. First Or Create
  26. Laravel: Returning the namespaced owner of a polymorphic relation
  27. Laravel: Change base URL?
  28. Polymorphic Eloquent relationships with namespaces
  29. Laravel 4 : Route to localhost/controller/action
  30. Clone an Eloquent object including all relationships?

Leave a Comment