Как отобразить значение 5 дней в php?

Question

SELECT dateofbooking, count(id) AS total FROM participant WHERE dateofbooking >= $datepick AND 
  dateofbooking <= DATE_ADD($datepick, INTERVAL 5 DAY)GROUP BY dateofbooking;

Как отобразить значение 5 дней в php?

Answer 1

Используйте этот код

$from = date('Y-m-d');
$to = date('Y-m-d',strtotime("5 day"));
SELECT dateofbooking, count(id) AS total FROM participant WHERE `dateofbooking` BETWEEN '$from' AND '$to' GROUP BY dateofbooking;