如何显示4列连续在一个循环与引导和SQL查询 - How to display 4 columns continuously in a loop with Bootstrap and SQL query

How to display 4 columns continuously in a loop with Bootstrap and SQL query

我想用Bootstrap显示每一行SQL查询的4个图像结果。如何在PHP中使用循环?

<div class="row">
   <?php 
        $query = "SELECT * FROM table WHERE nombre='x' ORDER BY nombre";
        $consulta = mysql_query($query, $conexion);
        while ($data = mysql_fetch_assoc($consulta)) { ?>
        <div class='col-md-3 portfolio-item'>
            <a href='img/<?php echo $data['imagen']; ?>'>
                <img class='img-responsive' src='img/<?php echo $data['imagen']; ?>' alt='<?php echo $data['nombre']; ?>'>
            </a>
            <div class='panel panel-default'>
                <div class='panel-body'>
                    <?php echo $data['nombre']; ?>
                </div>
            </div> 
        </div> 
    <?php } ?> 
</div>

关闭并打开新的row -

    <div class="row">
       <?php 
            $query = "SELECT * FROM table WHERE nombre='x' ORDER BY nombre";
            $consulta = mysql_query($query, $conexion);
            $i = 1;
            while ($data = mysql_fetch_assoc($consulta)) { ?>
            <div class='col-md-3 portfolio-item'>
                <a href='img/<?php echo $data['imagen']; ?>'>
                    <img class='img-responsive' src='img/<?php echo $data['imagen']; ?>' alt='<?php echo $data['nombre']; ?>'>
                </a>
                <div class='panel panel-default'>
                    <div class='panel-body'>
                        <?php echo $data['nombre']; ?>
                    </div>
                </div> 
            </div> 
        <?php 
            if($i % 4 === 0) echo "</div><div class='row'>"; // close and open a div with class row
            $i++; // increment
        } 
        ?> 
    </div>