我正在编写一个PHP程序，它将获取当前工作周（不包括星期一）的所有日期。我的代码如下：
//Get Year
$sql = "SELECT YEAR(CURDATE()) AS CurYear";
$result = mysqli_query($db, $sql);
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
$curyear = $row['CurYear'];
//Get Week
$sql = "SELECT WEEK(CURDATE()) AS CurWeek";
$result = mysqli_query($db, $sql);
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
$curweek = $row['CurWeek'];
//Get Date of Tuesday
$sql = "SELECT STR_TO_DATE('$curyear$curweek Tuesday', '%X%V %W') AS TueDate";
$result = mysqli_query($db, $sql);
$row = mysqli_fetch_array($result,MYSQLI_ASSOC);
$tuedate = $row['TueDate'];
它起作用，并将返回本周二的日期，但有没有一个更有效的方法来这样做，而且在接下来的3天内这样做？
最佳答案
如前所述：How to find the day of week from a date using PHP?
您可以使用date命令：
$time = time(); // present time
$day = 3; //the day of the week we are looking for 0: sunday, 1 monday and so on
$dayofweek = date('w', $time); //current day week number
$result = date('Y-m-d', strtotime(($day - $dayofweek).' day', $time));
关于php - MYSQL-选择当前工作周的日期，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/36093016/