Mysqli 如何获取并填充3列数据

我有一张桌子。我的桌子如下。

id | product_name | price

我有列表视图。我想获取数据并像这样填充。

<div class="container">
    <div class="row">
        <div class="col s4">product_name (first)</div>
        <div class="col s4">product_name (second)</div>
        <div class="col s4">product_name (third)</div>
    </div>
    <div class="row">
        <div class="col s4">product_name (fourth)</div>
        <div class="col s4">product_name (fifth)</div>
        <div class="col s4">product_name (sixth)</div>
    </div>
</div>

我怎样才能做到这一点？

我尝试 mysqli_fetch_assoc 但我想填充从表中订购数据的行中的列。

您可以通过使用来实现这一点模运算符 http://php.net/manual/en/language.operators.arithmetic.php.

<?php
$result = [
    ['id' => 1, 'product_name' => 'a'],  
    ['id' => 2, 'product_name' => 'b'],  
    ['id' => 3, 'product_name' => 'c'],  
    ['id' => 4, 'product_name' => 'd'],  
    ['id' => 5, 'product_name' => 'e'],  
    ['id' => 6, 'product_name' => 'f'],  
    ['id' => 7, 'product_name' => 'g'],  
    ['id' => 8, 'product_name' => 'h'],  
    ['id' => 9, 'product_name' => 'i'],  
    ['id' => 10, 'product_name' => 'j'],  
];
?>
<div class="container">
<?php foreach ($result as $key => $value) {
    if ($key % 3 == 0) { // change 3 to how many items between rows
        if ($key != 0) { echo '</div>'.PHP_EOL; }
        echo '<div class="row">'.PHP_EOL;
    }
    echo '<div class="col s4">'.$value['product_name'].'</div>'.PHP_EOL;
}
?>
  </div>
</div>

https://3v4l.org/vKrf9 https://3v4l.org/vKrf9

Result:

<div class="container">
  <div class="row">
    <div class="col s4">a</div>
    <div class="col s4">b</div>
    <div class="col s4">c</div>
  </div>
  <div class="row">
    <div class="col s4">d</div>
    <div class="col s4">e</div>
    <div class="col s4">f</div>
  </div>
  <div class="row">
    <div class="col s4">g</div>
    <div class="col s4">h</div>
    <div class="col s4">i</div>
  </div>
  <div class="row">
    <div class="col s4">j</div>
  </div>
</div>