Row and Column Loop in PHP

Question

I’m trying to make a loop where every 5 records on the line, skips a line and so on until it reaches 6 lines, when it gets to 6 lines for the loop.

Example:

12345
12345
12345
12345
12345
12345
Para o laço

Thank you

Answer 1

You can do using a condition with %module. It would be something like.

if($item%5==0){
   // insira o item + <br/> <-- onde br representa a quebra de linha
else 
   // insira o item normalmente

The logic is this: the percent operator % means module in programming, which checks the rest of the division of a certain value. In this case it is so, every time the value of the $item is divided by 5 and its rest is 0, then do something. As in the example, the tag is placed <BR/> to skip a line. See more details in the documentation.

Now see a complete code here using PDO. See:

<?php   

    // Instancia o objeto PDO
    $pdo = new PDO('mysql:host=localhost;dbname=db', 'root', '');
    // define para que o PDO lance exceções caso ocorra erros
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $consulta = $pdo->query("SELECT id FROM category;");

    $item = 1;
    while ($linha = $consulta->fetch(PDO::FETCH_ASSOC)) {
        // aqui eu mostro os valores de minha consulta

        if($item%5==0)
            echo "{$linha['id']}<br/>";
        else 
            echo "{$linha['id']}";
        }        
        $item++;
    }
?>