Check the Last Day in Month $startDate = “20150624”;$endDate = “20150722”;$startDate = strtotime($startDate);$endDate = strtotime($endDate);$dayLength = 60 * 60 * 24;$checkDateRange = ($endDate – $startDate) / $dayLength;$datesStartMonth = date(‘t’, $startDate);if ($checkDateRange > $datesStartMonth) {echo $error = “Date range should be with in one month”;}
Below simple program will export mysql data values to excel sheet without using any PHP libraries. Export to Excel Using PHP and Mysql Note: IF you get errors or in excel all the data is in one column, then instead t tab space use, comma ‘,’.
