• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Tutsplanet

Tutsplanet

Free Technical and Blogging Resources

  • Home
  • Web Hosting
  • Programming
  • Plugins
  • Twitter Trends
  • Tools
  • About Us

Programming TagsLaravel

How to Get Last Week Data in Laravel using Carbon?

Jun 7, 2022 Editorial Staff Leave a Comment

Share
Tweet
Share

In today’s tutorial, we are showing how to get last week’s data in Laravel using Carbon. In other words, you need to pull all the orders received in the last week. In this case, last week does not mean the last 7 days, but it’s a full week starting from Monday to Sunday. For example, if you pull the data on June 7, 2022, the last week will be May 30, 2022, to June 5, 2022.

Hope you understand what we are going to achieve in this post. Instead of using raw PHP date functions, we will use we use Carbon – A simple PHP API extension for DateTime, which is inherited from the PHP DateTime class.

As an illustration, we have a table filled with orders received from our valuable customers. We need to show all the orders received last week in the dashboard to make it easy for the finance team.

In the code, we will have the below lines.

use Carbon\Carbon;

// Today 7 Jun 2022
$startWeek = Carbon::now()->subWeek()->startOfWeek(); // 30 May 2022
$endWeek   = Carbon::now()->subWeek()->endOfWeek();  // 5 June 2022

$orders    = Order::query()->whereBetween('created_at',[ $startWeek,$endWeek ])->get();


dd($orders);

This will print the last week’s records.


Editorial Staff

Editorial Staff at Tutsplanet is a dedicated team to write various tutorials about subjects like Programming, Technology and Operating Systems.

View all posts by Editorial Staff

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Quick Links

  • Top 21 Website Ideas To Make Money Online in 2021
  • A Simple YouTube Video Downloader Script in PHP
  • The 50 Most Useful jQuery Plugins for Frontend Development
  • Replace “\n” with new line characters, using Notepad++
  • Using Third-Party Libraries in Codeigniter
  • Upload Multiple Images and Store in Database using PHP and MySQL.
  • Hierarchical Tree view Category Example in Laravel
  • Laravel Image Intervention Tutorial With Example
  • How to import sql file in MySQL database using PHP?
  • Free VAT Calculator Online

Subscribe

* indicates required



Search Here

Share

   



Hot topics

  • Replace “\n” with new line characters, using Notepad++ 37 views
  • How to enter new line in Microsoft Teams? 34 views
  • Simple PHP Shopping Cart 18 views
  • Add FTP/SFTP in Visual Studio Code 15 views
  • Open a URL in a new tab using JavaScript 13 views
  • Laravel: Download files to storage from SFTP 12 views
  • Solution: windows photo viewer opens each time save a pic file 12 views
  • A Simple YouTube Video Downloader Script in PHP 11 views
  • Laravel Eloquent Select Column as Alias 11 views
  • Get Uploads Directory Path in WordPress 9 views

Categories

  • Design & Development
  • Drupal
  • Facebook
  • General
  • How To
  • ios
  • Javascript
  • Linux
  • Magento
  • Marketing
  • News
  • PHP
  • Plugins
  • Programming
  • Snippets List
  • Social Media
  • Softwares
  • Themes
  • Tips
  • Wordpress
  • YouTube























Copyright © 2023 · Planet on Genesis Framework · Powered By BunnyCDN . Network wallpapernoon.com