You can use the following code where users can select a date range from a drop down with quick dates. Very often, you will also need a date range calendar; you can use jquery date picker tool for the purpose.
if ($quickDates==”today”){
$dateFrom = date(“Y-m-d”);
$dateTo = date(“Y-m-d”, time() + 60 * 60 * 24);
}else if ($quickDates==”yesterday”){
$dateFrom = date(“Y-m-d”, time() – 60 * 60 * 24);
$dateTo = date(“Y-m-d”);
}else if ($quickDates==”lastWeek”){
$dateFrom = date(“Y-m-d”, time() – 7*60 * 60 * 24);
$dateTo = date(“Y-m-d”);
}else if ($quickDates==”thisMonth”){
$dateFrom = date(“Y-m-1”);
$dateTo = date(“Y-m-d”,strtotime(“+1 months”));
}else if ($quickDates==”lastMonth”){
$dateFrom = date(“Y-m-d”,strtotime(“-1 months”));
$dateTo = date(“Y-m”);
}else if ($quickDates==”allTime”){
$dateFrom = “all”;
$dateTo = “all”;
}
You can utilize this range in a query as follows
$dateFilter = “”;
if ($dateFrom != “all”){
$dateFilter = ” where ( date >= ‘$dateFrom’ and date < ‘$dateTo’) “;
}
$sql = ” select * from table $dateFilter order by date desc”;
HTML for a quick date selector can be as folows:
<select id=’cmbQuickDates’ name=’cmbQuickDates’>
<option value=”>Select</option>
<option value=’today’>Today</option>
<option value=’yesterday’>Yesterday</option>
<option value=’lastWeek’>Last week</option>
<option value=’thisMonth’>This month</option>
<option value=’lastMonth’>Last month</option>
<option value=’allTime’>All time</option>
<{/select> From: http://sitestree.com/?p=147
Categories:Software Development, Web Development, Root, By Sayed Ahmed
Tags:PHP, Date
Post Data:2013-01-01 05:52:23
Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada
