Izidoro Stoppa

Tenho uma pagina php que faço filtro em menu dropdown puxando informação do banco, quando o usuario seleciona as opções desejadas ele e clica em filtrar eu trago o resultado abaixo, porém eu gostaria de manter os dados da pesquisa feita pelo usuario, quando o usuario clica em filtrar ele volta para opção padrão do dropdown que é Todas. alguém sabe como manter o que foi pesquisado após a consulta? segue meu código: ?php $modality = $_POST["modality"]; $place = $_POST["place"]; date_default_timezone_set('America/Sao_Paulo'); $dateNow = date('d/m/Y'); $resultado2 = $conexao->query("SELECT * from modality"); $resultado3 = $conexao->query("SELECT * from city"); ###################FILTER################################# if($modality==0 && $place!=0){ $resultado = $conexao->query("SELECT *, TIME_FORMAT(event_start, '%T') AS 'start', TIME_FORMAT(event_end, '%T') AS 'end',TIME_FORMAT(event_date, '%Y-%m-%d')AS 'date_evt' FROM event_tb WHERE event_place=$place ORDER BY event_date and event_participants DESC"); }else if($modality!=0 && $place==0){ $resultado = $conexao->query("SELECT *, TIME_FORMAT(event_start, '%T') AS 'start', TIME_FORMAT(event_end, '%T') AS 'end',TIME_FORMAT(event_date, '%Y-%m-%d')AS 'date_evt' FROM event_tb WHERE event_modality=$modality ORDER BY event_date and event_participants DESC"); }else if($modality!=0 && $place!=0){ $resultado = $conexao->query("SELECT *, TIME_FORMAT(event_start, '%T') AS 'start', TIME_FORMAT(event_end, '%T') AS 'end',TIME_FORMAT(event_date, '%Y-%m-%d')AS 'date_evt' FROM event_tb WHERE event_place=$place AND event_modality=$modality ORDER BY event_date and event_participants DESC"); }else{ $resultado = $conexao->query("SELECT *, TIME_FORMAT(event_start, '%T') AS 'start', TIME_FORMAT(event_end, '%T') AS 'end',TIME_FORMAT(event_date, '%Y-%m-%d')AS 'date_evt' FROM event_tb ORDER BY event_date and event_participants DESC"); } ?> <br> <div class="container-fluid"> <div class="row"> <form action="customer.php?link=16" method="post" class="agile_form"> <div class="col-md-2"> <div class="btn-group"> <!--<div class="dropdown"> <button class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-expanded="false" type="button">Modalidades <span class="caret"></span></button> <ul class="dropdown-menu" role="menu">--> <label >Modalidade</label> <select id="searchbygenerals_currency" name="modality" class="form-control"> <option value="0">Todas</a></option> <?php if (mysqli_num_rows($resultado2) > 0){ while($dados = $resultado2->fetch_array()){ #echo "<li><a href=customer.php?link=2&id=".$dados['modality_id'].">".$dados['modality_name']."</a></li>"; echo "<option value=".$dados['modality_id'].">".$dados['modality_name']."</option>"; #$mo_id = $dados['modality_id']; } }else{ echo "<h3>Nenhuma Modalidade Encontrada</h3>"; } ?> <!--<li class="divider" role="separator"></li>--> <!--</ul> </ul>--> </select> </div> </div> <div class="col-md-2"> <div class="btn-group"> <!--<div class="dropdown"> <button class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-expanded="false" type="button">Cidades <span class="caret"></span></button> <ul class="dropdown-menu" role="menu">--> <label >Cidade</label> <select id="searchbygenerals_currency" name="place" class="form-control"> <option value="0">Todas</a></option> <?php if (mysqli_num_rows($resultado3) > 0){ while($dados = $resultado3->fetch_array()){ #echo "<li><a href=customer.php?link=15&cid=".$dados['city_id'].">".$dados['city_name']."</a></li>"; echo "<option value=".$dados['city_id'].">".$dados['city_name']."</option>"; } }else{ echo "<h3>Nenhuma Cidade Encontrada</h3>"; } ?> <!--<li class="divider" role="separator"></li>--> <!--</ul> </ul>--> </select> </div> </div> <div class="col-md-6"> <input type="submit" value="Filtrar"> </div> </div> </form> </div> </div> <br> <table class="table table-bordered"> <thead class="w3ls-table"> <tr> <td>Arena</td> <td>Vagas</td> <td>Data</td> <td>Inicio</td> <td>Fim</td> <td>Status</td> <td>Visualizar</td> </tr> </thead> <?php echo "Modalidade buscada: $modality"; if (mysqli_num_rows($resultado) > 0){ while($dados = $resultado->fetch_array()){ echo "<tr>"; // $modality_id = $dados['event_modality']; // $modality = $conexao->query("SELECT modality_name from modality where modality_id = $modality_id"); // if (mysqli_num_rows($modality) > 0){ // while($dados2 = $modality->fetch_array()){ // echo "<td>".$dados2['modality_name']."</td>"; // } // } $company_id = $dados['event_company']; $company = $conexao->query("SELECT company_name from company where company_id = $company_id"); if (mysqli_num_rows($company) > 0){ while($dados2 = $company->fetch_array()){ echo "<td>".$dados2['company_name']."</td>"; } } $data = date('d/m/Y',strtotime($dados['event_date'])); $date_evt = strtotime($dados['date_evt']); #echo $data."#"; #$date_now = strtotime($dateNow); #echo $dateNow; $vagas = $dados['event_participants']; echo "<td>".$vagas."</td>"; echo "<td>".$data."</td>"; echo "<td>".$dados['start']."</td>"; echo "<td>".$dados['end']."</td>"; //echo "<td>".$dados['event_place']."</td>"; $status = $dados['event_participants']; if ($status > 0 && $data >= $date_now ){ echo "<td>"."Aberto"."</td>"; echo "<td class=wthree-table-enq><a class=login href=customer.php?link=3&event_id=".$dados['event_id']."><font size=3>Abrir</a></td></font>"; }else{ echo "<td>"."Fechado"."</td>"; } echo "</tr>"; } }else{ echo "NADA ENCONTRADO"; } ?> </tbody> </table>