dousui6193 2019-07-18 17:21
浏览 69
已采纳

对于PHP / MySQL中的每3行

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

  • 写回答

2条回答 默认 最新

  • drbuowqe02101 2019-07-18 17:58
    关注

    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

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型