Pagination of results with search in two fields

Question

Hello, good morning, I’m looking for help because I’m having trouble creating a results pagination, I made a page that contains two search fields, "what you search" and "where you search", it works and makes the correct filter, however I am not able to make the pagination to limit the researched results, where I am missing in the following code?

    $conexao =mysqli_connect($host,$user,$pass,$bank);
    $pagina = (isset($_GET['pagina'])) ? $_GET['pagina'] : 1 ;


   $consulta1 ="SELECT * FROM registro_clientes";
   $qrTotal  =mysqli_query($conexao,$consulta1) or die(mysqli_error());
   $numTotal =mysqli_num_rows($qrTotal);
   $quantidade = 2;

   $totalPagina=ceil($numTotal/$quantidade);

   $inicio = ($quantidade * $pagina) - $quantidade;


       if(mysqli_connect_errno($conexao)){
           echo "erro conect hen";
           }else{

                 if(isset($_GET['buscar'])&& isset($_GET['onde'])){

                   $nome = $_GET['buscar'];
                   $bairro = $_GET['onde'];
               $consulta = "SELECT * FROM registro_clientes 
               WHERE nome_cliente LIKE '%$nome%' AND bairro LIKE '%$bairro%' 
               ORDER BY preferencial ASC 
               LIMIT $inicio, $quantidade ";
               $executar = mysqli_query($conexao,$consulta);

               $total = mysqli_num_rows($executar);

                    echo  "Encontrado     ".$total. "     resultado(s):";
                        echo "<br>";
                        echo "<hr>";                        

               while ($ln=mysqli_fetch_array($executar))

Answer 1

• You better use the SELECT COUNT(*) FROM registro_clientes; to find out how many records there are. The query is much smaller and more peformatica.
• I didn’t really understand the account you wanted to use, but this should work better. $inicio = ($pagina - 1) * $numTotal