CODE EXAMPLE FOR PHP

generate report daily weekly monthly php mysql

SELECT COUNT(*), DAY(timestamp), WEEK(timestamp), MONTH(timestamp), YEAR(timestamp) FROM transaction GROUP BY YEAR(timestamp), MONTH(timestamp), WEEK(timestamp), DAY(timestamp)