Generate report in Excel filtering query in MySQL database

You are looking for travel data with getAll() that should be why you are returning all data, create a method where you only search the filtered data, or pass by parameter to the method geraExcel() the data already filtered and manipulate this data.

@ Mauricio3012. Your code does not make sense. You pass the $ arrayRow variable as the function parameter. In the code snippet below, you pass the value of it to another variable, but at no time do you use it:

$arr[] = $arrayRow;

In the section below, you apparently make a query:

$result = $obj->getAll();

In the getAll () method, no parameter is used, so the result is always the same.

Here's a template for how you can adjust your function:

private function geraExcel($parametros) { 

$this->load->helper('xls');     

$obj = new Viagem(); 
$result = $obj->metodoPesquisaPorParametro($parametros); 



if (isset($result) && count($result) > 0) { 

    foreach ($result['rows'] as $v) { 

    $arr[] = array( 

    utf8_decode($v->getUsuario()->getNome()), 
        $v->getFormaPagamento()->getNome(), 
        $v->getStatus()->getNome(),
        $v->getDistancia(), 
        $v->getValor(), 
        $v->getValorExtra(), 
        dataHoraBr($v->getDataCriado()), 
        $v->getEntregador()->getNome() 

    );}     
}     
    array_to_xls($arr, 'financeiro'.date("m-d-y").'.xls'); 
}

Change according to your needs. It seems to me the easiest way to do it.

<?php 
    include_once('conetar.php');

    $query = "[Introduz o select que desejar]";

     $result = mysqli_query($conn, $query);
    $contar = mysqli_num_rows($result);//para contar o numero de linhas 

    //tabela HTML
    $html=[];
    for($i=0;$i<1;$i++){   
    $html[$i] = "";
        $html[$i] .= "<table>";
        $html[$i] .= "<tr>";
        $html[$i] .= "<td><b>Coluna1</b></td>";
        $html[$i] .= "<td><b>Coluna2</b></td>";
        $html[$i] .= "<td><b>Coluna3</b></td>";
        $html[$i] .= "</tr>";
        $html[$i] .= "</table>";
    }

    $i = 1;
    while($ret = mysqli_fetch_array($result)){
        error_reporting(E_ERROR | E_PARSE);
        $retorno_resultado1= $ret['Coluna1'];
        $retorno_resultado2= $ret['Coluna2'];
        $retorno_resultado3= $ret['Coluna3'];
        $html[$i] .= "<table>";
        $html[$i] .= "<tr>";
        $html[$i] .= "<td>".$retorno_resultado1."</td>";
        $html[$i] .= "<td>".$retorno_resultado2."</td>";
        $html[$i] .= "<td>".$retorno_resultado3."</td>";
        $html[$i] .= "</tr>";
        $html[$i] .= "</table>";
        $i++;
    }

    $arquivo = 'export.xls';
    header ("Expires: Mon, 26 Jul 2100 05:00:00 GMT");
    header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
    header ("Cache-Control: no-cache, must-revalidate");
    header ("Pragma: no-cache");
    header ("Content-type: application/x-msexcel");
    header ("Content-Disposition: attachment; filename={$arquivo}" );
    header ("Content-Description: PHP Generated Data" );

    for($i=0;$i<=$contar;$i++){  
        echo $html[$i];
    }

     ?>

I understood. Here is an example of a query with parameters:

$search_ID = 1; 
$search_product = "PD1001"; 

$query = "SELECT id, product_code, product_desc, price FROM products 
WHERE ID=? AND product_code=?";
$statement = $mysqli->prepare($query);
$statement->bind_param('is', $search_ID, $search_product);
$statement->execute();
$statement->bind_result($id, $product_code, $product_desc, $price);

print '<table border="1">';
while($statement->fetch()) {
    print '<tr>';
    print '<td>'.$id.'</td>';
    print '<td>'.$product_code.'</td>';
    print '<td>'.$product_desc.'</td>';
    print '<td>'.$price.'</td>';
    print '</tr>';

}   
print '</table>';

//close connection
$statement->close();