How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php

How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php 

 <table class="table table-bordered">

    <tr>

        <th>Month</th>

        <th>Franchise Name</th>

        

    </tr>

<?php 

include '../db_connect.php';

$year= $_POST['year'];

for ($m=1; $m<=12; $m++) {

    $month = date('F', mktime(0,0,0,$m, 1, date('Y')));

    

     $from_date=date(''.$year.'-'.$m.'-01');

     

     $lastdays= cal_days_in_month(CAL_GREGORIAN, $m, $year); 

      $to_date=date(''.$year.'-'.$m.'-'.$lastdays.'');

?>

<tr>

        <td><?php echo $month ." ".$year;?></td>

        <td>

            <?php

            $i=0;

            $sqlLastQuery=mysqli_query($conn,"SELECT * FROM `store` where DATE(date_added) BETWEEN DATE('".$from_date."') AND ('".$to_date."')");

            while($fetchFormatFranchise=mysqli_fetch_array($sqlLastQuery)){

                echo ++$i.". ". $fetchFormatFranchise['store_location'];

                echo "<br><br>";

                

            }

            ?>

        </td>

        

    </tr>

<?php } ?>

</table>