<?php
  session_start();
  $servername = "localhost";
  $username = "root";
  $pass = "pass";
  $dbName = "Revo";
  $conn = mysqli_connect($servername , $username , $pass , $dbName);

  $player = $_POST["player"];
  $name = $_POST["name"];
  $startDate = $_POST["startDate"];
  $endDate = $_POST["endDate"];

  $player = "%".$player."%";
  $name = "%".$name."%";

  $getDemos = $conn->prepare("SELECT player, name, date
                              FROM demoCheck
                              WHERE player LIKE ?
                              AND name LIKE ?
                              AND date >= ?
                              AND date <= ?");

  $getDemos->bind_param("ssss",$player,$name,$startDate,$endDate);
  $getDemos->execute();
  $getDemos->bind_result($playerName,$demoName,$demoDate);

  $demos = array();
  while($getDemos->fetch()){
    $object = (object)[
      "playerName" => $playerName,
      "matchName" => $demoName,
      "demoDate" => $demoDate
    ];
    array_push($demos,$object);
  }
  echo(json_encode($demos));
  $conn->close();

?>