Laravel $q->where() between dates

by

You can chain your wheres directly, without function(q). There’s also a nice date handling package in laravel, called Carbon. So you could do something like:

$projects = Project::where('recur_at', '>', Carbon::now())
    ->where('recur_at', '<', Carbon::now()->addWeek())
    ->where('status', '<', 5)
    ->where('recur_cancelled', '=', 0)
    ->get();

Just make sure you require Carbon in composer and you’re using Carbon namespace (use Carbon\Carbon;) and it should work.

EDIT:
As Joel said, you could do:

$projects = Project::whereBetween('recur_at', array(Carbon::now(), Carbon::now()->addWeek()))
    ->where('status', '<', 5)
    ->where('recur_cancelled', '=', 0)
    ->get();

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. How to do this in Laravel, subquery where in
  3. Laravel OrderBy relationship count
  4. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  5. Eloquent many-to-many-to-many – how to load distant relation easily
  6. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  7. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  8. Automatically deleting related rows in Laravel (Eloquent ORM)
  9. Get Specific Columns Using “With()” Function in Laravel Eloquent
  10. Laravel Eloquent Query Using WHERE with OR AND OR?
  11. Laravel update model with unique validation rule for attribute
  12. How can I convert many statement mysql to laravel eloquent?
  13. Eloquent ORM Code Hinting in PhpStorm
  14. Get the Query Executed in Laravel 3/4
  15. What does “Mass Assignment” mean in Laravel?
  16. Laravel Checking If a Record Exists
  17. Laravel 5 hasMany relationship on two columns
  18. “No such file or directory” or “No such host is known” when running migrations
  19. Order By before Group By using Eloquent (Laravel)
  20. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  21. How to Merge Two Eloquent Collections?
  22. How to create a subquery using Laravel Eloquent?
  23. Eloquent model mass update
  24. Difference between Eloquent\Model::get() and all()
  25. Laravel Eloquent get results grouped by days
  26. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  27. Change name of Laravel’s created_at and updated_at
  28. How do I get database column names in Laravel?
  29. Find or Create with Eloquent
  30. Create a Insert… Select statement in Laravel

Leave a Comment