Show only 1 record at a time with go to next button

Asked

Viewed 35 times

0

Good night to you all.

I would like to: Show records sequentially, (1 at a time), on a web page for a set of more than 100,000 records. I can show all at once, but I would like to only 1 at a time with go button to the next one. My table is unique and has 22 fields.

<?php
$conexao = mysqli_connect('localhost', 'aiseco14_america', 'Aise15481415*', 'aiseco14_cedato');

$sql = $conexao->query("Select cnpj, empresas, obs, data From empresas");
if($sql){ // If $sql is True
    while($exibe = $sql->fetch_assoc()){
        foreach($exibe as $key => $value){
            echo "<br />" . $value;
        }}}
?> 

I put 3 fields just to illustrate. inserir a descrição da imagem aqui

Thanks in advance for the guidelines

  • you then need to ask a related question: https://answall.com/questions/26303/como-fazer-pagina%C3%A7%C3%a3o-php-e-mysql

  • I really appreciate your suggestion. I took the test with everyone and that wouldn’t be it. The purpose of showing one by one is to prevent the user from choosing which client to work with and leaving the less profitable ones aside, so paging is not interesting. And the last suggestion shows all products side by side in horizontal. Even so, thank you very much for the attention.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.