php - 仅从数据库获取上周结果

Question

我正在使用这个 php class 。它正在帮助我处理数据库。

因此一个名为:vocabulary 的表的行名为:datetime_uploaded

示例结果:2018-08-31-11-13-05

现在我只想从这个 php 类的数据库宽度中获取上周的结果。

我有函数获取上周的日期

function getLastWeekDates()      
       {
          $lastWeek = array();

          $prevMon = abs(strtotime("previous monday"));
          $currentDate = abs(strtotime("today"));
          $seconds = 86400; //86400 seconds in a day

          $dayDiff = ceil( ($currentDate-$prevMon)/$seconds );

          if( $dayDiff < 7 )
          {
              $dayDiff += 1; //if it's monday the difference will be 0, thus add 1 to it
              $prevMon = strtotime( "previous monday", strtotime("-$dayDiff day") );
          }

          $prevMon = date("Y-m-d",$prevMon);

          // create the dates from Monday to Sunday
          for($i=0; $i<7; $i++)
          {
              $d = date("Y-m-d-H-i-s", strtotime( $prevMon." + $i day") );
              $lastWeek[]=$d;
          }

          return $lastWeek;
      }

它给了我结果:

(
    [0] => 2018-08-27-00-00-00
    [1] => 2018-08-28-00-00-00
    [2] => 2018-08-29-00-00-00
    [3] => 2018-08-30-00-00-00
    [4] => 2018-08-31-00-00-00
    [5] => 2018-09-01-00-00-00
    [6] => 2018-09-02-00-00-00
)

但不知道如何从数据库中获取它。

我的 php 版本是 7.x

Answer 1

SELECT *
FROM table
WHERE DATE(date + INTERVAL (YEAR(NOW()) - YEAR(date)) YEAR)
      BETWEEN
      DATE(NOW() - INTERVAL WEEKDAY(NOW()) DAY)
      AND
      DATE(NOW() + INTERVAL 6 - WEEKDAY(NOW()) DAY);