<?php
  include "../vendor/autoload.php";
  include "../connect.php";
?>
<?php
    $eventDate = $_POST['eventDate'];

    // $query="select *, DATE(approveOn) AS date from posts where DATE(approveOn) = '" . $eventDate . "'";
    $query="SELECT *, DATE(approveOn) AS date FROM posts LEFT JOIN posts_categories ON posts.id=posts_categories.postId
    WHERE posts_categories.categoryId=115 AND posts.status='APPROVED_ON' AND DATE(approveOn) = '" . $eventDate . "'";

    // $query="select * from event where datem = '" . $eventDate . "'";
    $result = mysqli_query($conn,$query) or die('Query failed: ' . mysql_error());
    $eventResult = array();
    while ($row = mysqli_fetch_assoc($result)) {
        // $dtime = new DateTime($row['datem']);

        // $row['datem'] = $dtime->format("Y-m-d");
        $eventResult[] = $row;
    }
    echo json_encode($eventResult);


 ?>