我正在尝试获取两个日期之间的所有日期,并将它们全部插入到一个表中。我怎样才能做到这一点呢?
//current date
$currentDate = date('Y-m-d');
//find next monday from current date
$nextMonday = date('Y-m-d', strtotime('next monday', strtotime($currentDate)));
//get last day of current year
$yearEnd = date('Y-m-d', strtotime('12/31'));
//get all dates between nextMonday and yearend
[...]
foreach ($period as $dateCreated) {
//insert the dates in db
$stmt = $conn->prepare("INSERT INTO user_schedule (userId,dateCreated) VALUES (?,?)");
$stmt ->bind_param('is',$userid,$dateCreated);
$stmt ->execute();
$stmt ->close();
}
https://stackoverflow.com/questions/50957009
复制相似问题