count record based on variable

Question

Hello

I am trying to build a search in the Mysql record by two parameters; name and dates.

For example, I need to do an execution in Php where I enter the name of who registered ( Box) and dates that occurred the registration( From date x to date y). So far I have obtained this line of code that informs me in an organized way everything that has in the table. But in my search I did not find any native mysql command that filters the way I need.

Can someone tell me what I should do to separate and display only the data I need? Thanks a lot.

<?php
 $caixa= $_POST['caixa'];
 $datade=$_POST['datade'];
 #muda o padrão de data é indespensavel para o mysql ler os dados
 $datade= date("Y-m-d",strtotime(str_replace('/','-',$datade)));
 $dataate=$_POST['dataate'];
 #muda o padrão de data é indespensavel para o mysql ler os dados
 $dataate= date("Y-m-d",strtotime(str_replace('/','-',$dataate)));

 $sql= mysqli_query($conn,"SELECT caixa,data COUNT(*) FROM clientes group by caixa");

 echo "$sql";
 ?>

Answer 1

Use Mysql’s BETWEEN to search for a range.

$sql= mysqli_query($conn,"SELECT caixa, data, COUNT(*) FROM clientes WHERE caixa = '{$caixa}' AND data BETWEEN '{$datade}' AND '{$dataate}' GROUP BY caixa, data");