Displaying columns and rows in grid format. MYSQL, PHP

Question

I've been trying to figure out a way to do this for a while now and I can't work it out at all.

product_column   product_row    product_name
__________________________________________________
1                1              product_1
1                2              product_2
1                3              product_3
2                1              product_4
2                2              product_5
2                3              product_6
3                1              product_7
3                2              product_8
3                3              product_9
4                1              product_10
4                2              product_11
4                3              product_12

That's a snippet of the table, what I'm trying to establish is a grid-like display of the products, where the product_columns are parent divs and the product_rows in these columns are child divs, like below;

<div class = "parent">
   <div class = "child">
      product_1
   </div>
   <div class = "child">
      product_2
   </div>
   <div class = "child">
      product_3
   </div>
</div>
<div class = "parent">
   <div class = "child">
      product_4
   </div>
   <div class = "child">
      product_5
   </div>
   <div class = "child">
     product_6
   </div>
</div>

Like I say I've been plugging away it for quite a while now and I've hit a stumbling block. The number of columns is not a set number either.

Thank you in advance for any help I receive.

how could the number of columns in a db table not be a set ? — lagbox
– lagbox, Commented Oct 5, 2014 at 16:57
Not in the database table, I mean the product_column field will be updated regularly so there could be 20 or 200. — user3339243
– user3339243, Commented Oct 5, 2014 at 16:58

tenhsor · Accepted Answer · 2014-10-05 18:13:08Z

1

You can put all the products that belongs to a column in an array with the same index, something like this:

$sql = "SELECT product_column, product_row, product_name FROM table";
$query = mysqli_query($con,$sql);
$products = array();
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC)){
  $products[$row['product_column']][] = $row;
}

And to iterate trough this array you can do something like this:

foreach ($products as $product_column => $list_products) {
  echo "<div class='parent'>";
    foreach($list_products as $product){
      echo "<div class='child'>".$product['product_name']."</div>";
    }  
  echo "</div>";
}

answered Oct 5, 2014 at 18:13

tenhsor

3311 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Displaying columns and rows in grid format. MYSQL, PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related