对于PHP / MySQL中的每3行

Question

I'm retrieving data from MySQL which I'm listing on a page with HTML. I need each three throws from MySQL to be placed in a separate div when I'm looping through them.

My current code works but it prints all of the rows in a single div.

<div class="flex">
<?php 
    $get_plans = $database->sql("SELECT * FROM plans", array(), 'count');

    if ($get_plans != 0)
    {
        $get_plans = $database -> sql("SELECT * FROM plans", array(), 'rows');

        foreach ($get_plans as $plan)
        {
            $id = $plan['id'];
            $name = $plan['name'];

            echo '
                <div class="flex-33">
                    ID: '.$id.'
                    Name: '.$name.'
                </div>
            ';
        }
    }
?>
</div>

I would like the generated HTML to look like this: http://prntscr.com/ogx2bu

Answer 1

I would use array_chunk():

foreach (array_chunk($get_plans, 3) as $chunk) {
    echo '<div class="flex">';
    foreach ($chunk as $plan) {
        echo '<div class="flex-33">';
        echo 'ID: ' . $plan['id'] . '; ' . 'Name: ' . $plan['name'];
        echo '</div>';
    }
    echo '</div>';
}

The result will be like:

<div class="flex">
    <div class="flex-33">ID: ID1; Name: Name1</div>
    <div class="flex-33">ID: ID2; Name: Name2</div>
    <div class="flex-33">ID: ID3; Name: Name3</div>
</div>
<div class="flex">
    <div class="flex-33">ID: ID4; Name: Name4</div>
    <div class="flex-33">ID: ID5; Name: Name5</div>
    <div class="flex-33">ID: ID6; Name: Name6</div>
</div>
<div class="flex">
    <div class="flex-33">ID: ID7; Name: Name7</div>
</div>

See demo on rextester.com