Problem with the code (Find values between one date and another in the database)

The problem is as follows. I am working on a code that will fetch a series of flights that are available between one date and another entered by the user. Dates are entered through the datepicker in js, but I think this part is working fine and is not related to the problem. Although I have not yet been successful, the data is never returned. I have already used the if conditions to change the data return but it is still in error. I think I have to see the $ _GET parameter misapplied. I was very grateful for all the support provided, in case I need any more information, please request that I will cool it right away.

 <?php

if (isset($_GET["botao"])){
$parms = array();
$filter = array();

$query = "SELECT V.ID FROM voo as V WHERE ";
    if (isset($_GET["origem"]) && !empty($_GET["origem"])) {
        $filter[] = "(V.IDLocalOrigem=?)";
        $parms[] = $_GET["origem"];
    }

    $query = "SELECT V.ID FROM voo as V WHERE ";
    if (isset($_GET["destino"]) && !empty($_GET["destino"])) {
        $filter[] = "(V.IDLocalDestino=?)";
        $parms[] = $_GET["destino"];
    }

    $query = "SELECT V.ID FROM voo as V WHERE ";
    if (isset($_GET["data"]) && !empty($_GET["data"])) {
        $filter[] = "(V.DataPartida>=?)";
        $parms[] = $_GET["data"];
    }

    $query = "SELECT V.ID FROM voo as V WHERE ";
    if (isset($_GET["entre"]) && !empty($_GET["entre"])) {
        $filter[] = "(V.DataChegada<=?)";
        $parms[] = $_GET["entre"];
    }

}       


        $query .= explode(' AND ',$filter);

   ?>       

        <pre><?php var_dump($filter); ?></pre>
  <?php



    /*$query= "select V.ID, V.IDLocalOrigem, L1.Nome, V.IDLocalDestino,".
    " L2.Nome, V.IDAviao, V.DataPartida, V.DataChegada,".
    " V.PrecoBilhete, V.Estado, L1.Nome as nomeOrigem, L2.Nome as nomeDestino".
    " FROM Voo as V".
    " INNER JOIN Local as L1 ON V.IDLocalOrigem = L1.ID".
    " INNER JOIN Local as L2 ON V.IDLocalDestino = L2.ID".
    " WHERE ((V.IDLocalOrigem=?) OR (? is NULL)) AND".
    " ((V.IDLocalDestino=?) OR (? is NULL)) AND".
    " ((V.DataPartida>=?) OR (? is NULL)) AND".
    " ((V.DataPartida<=?) OR (? is NULL)) AND".
    " ((V.PrecoBilhete=?) OR (? is NULL)) AND".
    " ((V.Estado=?) OR (? is NULL))";*/


      // RESOLVER: Pesquisar todos os voos entre datas
    $stmt = $mydb->prepare($query);
    $Origem = !empty($_GET["origem"]) ? $_GET["origem"] : null;
    $Destino =!empty($_GET["destino"]) ? $_GET["destino"] : null;
    $DataPartida = null;
    if (!empty($_GET["data"])){
        $DataPartida = $_GET["data"].' 00:00:00';   
    }
    if (!empty($_GET["entre"])){
        $DataChegada = $_GET["entre"].' 23:59:59';  
    }

    $Preco = null;

    $Estado = null;

    $stmt->bind_param("iiii", $Origem, $Destino, 
    $DataPartida $DataChegada);

    $stmt->execute();


    $result = $stmt->get_result();
    $todosDados = $result->fetch_all(MYSQL_ASSOC);

    foreach($todosDados as $r   )
        {
        echo "<h1>Ida</h1>";

        echo "<table border=1>";
        echo "<tr>";
        echo "<td>";

        echo "Origem:".$r["nomeOrigem"]."</br>";
        echo "Destino:".$r["nomeDestino"]."</br>";
        echo "DataPartida:".$r["DataPartida"]."</br>";
        echo "DataChegada:".$r["DataChegada"]."</br>";
        echo "Preço:".$r["PrecoBilhete"]."</br>";
        echo "Estado:".$r["Estado"]."</br>";
        echo '<a href="lugares.php?idvoo='.$r["ID"].'" class="btn btn-primary">Comprar</a>';

        echo "</td>";
        echo "</tr>";
        echo "</table>";
        }   

    $result->free();


    $stmt->bind_param("iiii", $Origem, $Destino, 
    $DataPartida, $DataChegada);

    $stmt->execute();


    $result = $stmt->get_result();
    $todosDados = $result->fetch_all(MYSQL_ASSOC);




    foreach($todosDados as $r   )
        {
        echo "<h1>Ida</h1>";

        echo "<table border=1>";
        echo "<tr>";
        echo "<td>";

        echo "Origem:".$r["nomeOrigem"]."</br>";
        echo "Destino:".$r["nomeDestino"]."</br>";
        echo "DataPartida:".$r["DataPartida"]."</br>";
        echo "DataChegada:".$r["DataChegada"]."</br>";
        echo "Preço:".$r["PrecoBilhete"]."</br>";
        echo "Estado:".$r["Estado"]."</br>";
        echo '<a href="lugares.php?idvoo='.$r["ID"].'" class="btn btn-primary">Comprar</a>';

        echo "</td>";
        echo "</tr>";
        echo "</table>";
        }   

    $result->free();
    $stmt->close();
?>

The $ filter displays this var_dump:

array(4) {
  [0]=>
  string(19) "(V.IDLocalOrigem=?)"
  [1]=>
  string(20) "(V.IDLocalDestino=?)"
  [2]=>
  string(18) "(V.DataPartida>=?)"
  [3]=>
  string(18) "(V.DataChegada<=?)"
}