<?php
include 'DBController.php';
$db_handle = new DBController();
    
    if (! empty($_POST['day'] && $_POST['month'] && $_POST['year'])) {
        $date = $_POST['day'].'-'.$_POST['month'].'-'.$_POST['year'];
        $_POST['date'] = array(date("d-m-Y", strtotime($date))); 
        
        $query = "SELECT * from result";
        $i = 0;
        $selectedOptionCount = count($_POST['date']);
        $selectedOption = "";
        while ($i < $selectedOptionCount) {
            $selectedOption = $selectedOption . "'" . $_POST['date'][$i] . "'";
            if ($i < $selectedOptionCount - 1) {
                $selectedOption = $selectedOption . ", ";
            }
            
            $i ++;
        }
        $query = $query . " WHERE date in (" . $selectedOption . ") ORDER BY id ASC";
        
        $result = $db_handle->runQuery($query);
        echo json_encode($result);
        die;
    }
?>