Skip to main content

How to retrieve data of current date in Laravel



Are you looking for a way to retrieve today's records from database using Laravel? Well you have just come to the right place. In this tutorial I will explain a simple approach I often use in this kind of problems when am working on a project. So, read carefully!


Another way to get the exact record of today's transactions is by using the like operator in conjunction with Carbon for example in Laravel 9+:

<?php
 $date = Carbon::now(); $todaySales = Sales::query() ->where("created_at", "like", "%{$date->today()->toDateString()}%") ->get();
 dd($todaySales);


The above will return an array of records for today.

Now why do we use this approach? I want you to take a good look at the created_at column field this is how it looks like: 2023-04-14 11:33:23. With this using where statement the result will be an empty array why? Because where statement uses an = operator by default which means the sql statement will attempt to match the records exactly the way it is.

Here is how the query will look like:

SELECT * FROM sales WHERE created_at={$todaysDate}

// in this case todays date is 2023-04-14
 // but the value in the database is rather containing time
 // e.g.: 023-04-14 11:33:23 so definitely the select operation will fail and return empty results.


Looking at the above query there's no way the sql query is going to evaluate to any result but with the like operator the sql query will attempt to search for records that has todays date in them: 2023-04-14 which will return all records for today. If you're looking to retrieve records from a range let's say from Monday through to Friday you can use Laravel whereBetween() method otherwise try this approach.

Hope this help you solve the problem.
Labels:

Comments

Post a Comment

Popular posts from this blog

An Intro To Web Dev - Part-1: HTML Markups

  An Intro To Web Dev Part-1: HTML Markups Introduction HTML (Hypertext Markup Language) is a foundational language of web development. It is used to create the structure of web pages and defines the different elements of a web page such as headings, paragraphs, images, and links. In this article, we will dive deep into HTML and explore its different elements and their programmable properties. HTML Document Structure An HTML document consists of several sections. Here's a basic structure of an HTML document: html <!DOCTYPE html >   < html >      < head > < title > Page Title </ title >      </ head >      < body >         <!-- Content goes here -->      </ body >   </ html > The <!DOCTYPE html> declaration at the beginning tells the browser that the document is an HTML5 document. The <html> element cont...
Post a Comment
Read more

Principles And Best Practices of REST API Design

  Principles & Best Practices of REST API Design   RESTful API Design  the Best Practice This best-practices article intends for developers interested in creating RESTful Web services that provided high reliability and consistency across multiple services suites; following these guidelines; services are positioned for rapid, widespread, public adoption by internal and external clients. Here is the complete diagram to easily understand RES API’s principles, methods and best practices. Now, let’s begin with elaborating on each box by starting with tis principles . The Six Principles / Constraints Client-Server Separation of concerns is the principle behind the client-server constraints. By separating the user interface concerns from the data storage concerns, we improve the portability of the user interface across multiple platforms and improve scalability by simplifying the server components. Stateless Communication must be stateless, as in ...
Post a Comment
Read more