在php mysql中通过日期，星期和月份获取记录不起作用

I am trying to get the records per current day, week and month in php mysql. The date column is of date type. The issue is here is that my week records and months records are getting same from below script. Here is my code, have a look. I am trying to get the records per current day,