how to convert query php to laravel framework

by

you can use carbon to help you building your query:

 $beforeThirtyDay = Carbon::now()->subDays(30);
 DB::table('dbx_a')->select('*')->whereBetween('date', array(Carbon::now(), $beforeThirtyDay))
            ->where('name', '=', 'MANAGEMENT')->orderByDesc('date')->get();

More Related Contents:

  1. Trying to get property of non-object error on laravel 5.4
  2. Browser Version and laravel Version
  3. Laravel – Eloquent “Has”, “With”, “WhereHas” – What do they mean?
  4. Laravel redirect back to original destination after login
  5. How to place the ~/.composer/vendor/bin directory in your PATH?
  6. Eloquent Collection: Counting and Detect Empty
  7. How to install Laravel 4 to a web host subfolder without publicly exposing /app/ folder?
  8. Add new methods to a resource controller in Laravel
  9. Eloquent eager load Order by
  10. laravel with() method versus load() method
  11. NotFoundHttpException with Lumen
  12. Laravel 5.4^ – How to customize notification email layout?
  13. How to use paginate() with a having() clause when column does not exist in table
  14. Select Last Row in the Table
  15. How to get distinct values for non-key column fields in Laravel?
  16. Where can I set headers in laravel
  17. What is the difference between queue:work –daemon and queue:listen
  18. How to select specific columns in laravel eloquent
  19. Laravel API, how to properly handle errors
  20. First Or Create
  21. Has many through many-to-many
  22. Is it possible to change props value from method in Vue component?
  23. Laravel: Change base URL?
  24. How to setup conditional relationship on Eloquent
  25. Laravel Eloquent – Where In All
  26. Variable undefined error in laravel blade view
  27. socialite laravel authantication error with google API
  28. Modify existing Authorization module (email to username)
  29. Clone an Eloquent object including all relationships?
  30. Laravel: how to set date format on model attribute casting?

Leave a Comment