php query data according to yesterday

In our daily development, sometimes we need to query data based on yesterday's date, such as querying yesterday's order records, yesterday's visits, etc. In php, we can use the following methods to achieve this operation.

Method 1: Use the date() function to calculate yesterday’s date

We can use the date() function to get the current time, and then get yesterday’s timestamp by subtracting the seconds of the day , and then convert the timestamp to date format. The specific code is as follows:

$yesterday = date('Y-m-d', strtotime('-1 day'));

Here we use the strtotime() function to get the timestamp one day ago, and then use the date() function to convert the timestamp into date format.

Method 2: Use the DateTime class to calculate yesterday's date

Another way is to use the DateTime class in php to calculate yesterday's date. The specific code is as follows:

$today = new DateTime();
$yesterday = $today->modify("-1 day")->format("Y-m-d");

Here we first create a new DateTime object, then use the modify() method to subtract the time of day, and finally use the format() method to format the date into a string.

Method 3: Use the strtotime() function to directly query yesterday’s data

If we are using a MySQL database, we can directly use the strtotime() function in the SQL query statement to query yesterday’s data Data, the specific code is as follows:

SELECT * FROM orders WHERE date(created_at) = date(NOW() - INTERVAL 1 DAY);

Here we use the NOW() function to get the current time, then subtract one day to get yesterday's time, and then use the date() function to convert the time into a date query format.

All of the above methods can be used to query yesterday's data. Which method to choose depends on the specific business needs and implementation plan. It should be noted that when using time-related functions, it is best to use one time zone uniformly. You can use the date_default_timezone_set() function to set the time zone.

The above is the detailed content of php query data according to yesterday. For more information, please follow other related articles on the PHP Chinese website!