Javascript-mysql seven-day payment

Paylog Table Date UserID Todaypay
Now I'm going to look for a sevendaypay.

is to add the sum of nearly seven days per UID for each date and the best one SQL can handle

Reply content:

Paylog Table Date UserID Todaypay
Now I'm going to look for a sevendaypay.

is to add the sum of nearly seven days per UID for each date and the best one SQL can handle

It's like that. (Thanks to Rebiekong's reminder)

What you need is a function subdate ()

select sum(todayPay) as subPay from paylog where date >= unix_timestamp(DATE_SUB(curdate(),INTERVAL 6 DAY))  group by uid

Of course, if you want to work with PHP, you can calculate the current time minus 7 days/6 days of timestamp, and then put in SQL replace it.

SELECT * from article WHERE date_sub (Curdate (), INTERVAL 7 day) <= date ( add_time );
You can refer to PHP programmer Rechesson's Blog: http://www.leixuesong.cn/2065

