Discover my Udemy courses

How to Get Today's Records in Laravel

1 year ago admin Laravel

In this lesson, we will see how to retrieve only today's records from the database in Laravel, let's assume that we have an e-commerce website and we want to get the orders done today.

Get today's orders

So to get today's orders we use the following eloquent model query:

                                                        
                                                                                                                        
<?php

namespace App\Http\Controllers\Admin;

use Carbon\Carbon;
use App\Models\Order;
use App\Http\Controllers\Controller;

class AdminController extends Controller
{
    /**
     * Get today's orders 
    */
    public function index()
    {
        return view('admin.index')->with([
            'todayOrders' => Order::whereDay('created_at', Carbon::today())->get()
        ]);
    }
}
Previous Next

Popular Tutorials

PHP

How to Get the Min and the Max Value from an Array in PHP

In today's lesson, we will see how to get the min and the max value from an array in PHP, so let's assume...

Nodejs

How to Integrate Stripe Payment with Node js & React js Part 2

In the second part of this tutorial, we will move to the front end, we will create the C...

Laravel

How to Mask a Credit Card Number in Laravel

In this lesson, we are going to see how to mask a credit card number in Laravel, the mask helper method is used

PHP

How to Select a Part of an Array in PHP

In this lesson, we will see how to select a part of an array in PHP and return the selected part.

Laravel

How to Compare Old Password with New Password in Laravel

In Laravel when a user tries to change his password sometimes you need to compare the ol...

Vuejs

Build a Shopping Cart Using Vue js 3 Composition API Laravel 11 & Stripe Payment Gateway Part 2

In the second part of this tutorial, we will create the product and ord...

Laravel

How to Broadcast events with Laravel Echo and Vuejs Part 1

In today's tutorial, we are going to see how to broadcast an event with Laravel Echo and Vuejs 3.We will c...

Vuejs

Create a Custom 404 Component using Vuejs 3

In today's lesson, we are going to see how to redirect a user to a custom 404 Vue Component if a route does not exist.

Laravel

How to Get Today's Records in Laravel

In this lesson, we will see how to retrieve only today's records from the database in Laravel, let's assume that...

Css

How to Change the Background Color of a Read Only Input Field

In this lesson, we will see how to change the background color of a read-only input field, as you know the

Related Tutorials

How to Override Laravel Fortify Default Registration Redirect

In this lesson, we will see how to override Laravel Fortify default registration redirect, sometimes...

How to Override Laravel Fortify Default Login Redirect

In this lesson, we will see how to override Laravel Fortify default login redirect, sometimes when w...

How to Use the Same Validation Form Request for both Create and Update in Laravel

In this lesson, we will see how to use the same validation form request for both create and update i...

How to Get Raw SQL Output from the Eloquent Model in Laravel 11

In this lesson, we will see how to get raw SQL output from the eloquent model in Laravel 11, sometim...

How to Check if a Record Does Not Exist in Laravel

in this lesson, we will see how to check if a record does not exist in laravel, sometimes you need t...

How to Check if a Record Exists in Laravel

in this lesson, we will see how to check if a record exists in laravel, sometimes you need to check...

How to Decrement Multiple Fields in Laravel

In this lesson, we will see how to decrement multiple fields in Laravel, in the old versions of lara...

How to Increment Multiple Fields in Laravel

In this lesson, we will see how to increment multiple fields in Laravel, in the old versions of lara...

How to Use the Same Request Validation Rules for Storing and Updating in Laravel

In this lesson, we will see how to use the same request validation rules for storing and updating in...

How to Go Back to the Previous URL in Laravel Blade

In this lesson, we will see how to go back to the previous URL in Laravel Blade, sometimes we need t...