<?php
  include "../vendor/autoload.php";
  include "../connect.php";
?>
<?php
// include 'db.php';
// $query = "SELECT *, DATE(approveOn) AS date from posts ";
$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' ";


$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);
?>