根据查询结果显示不同的Div

Question

Here what I got in view

I want to show it as Separate divs based on vendor name

How can i Group the vandor names and Show in different divs ?

Answer 1

I don't know how the data is being stored/retrieved but here is how I might do such sorting - assuming the variable $rows is set contains an associative array of all rows (similar to the results of a basic database query) and assuming "vendor" is the column name for the vendors (TSZ, TSR, etc), "sku" is the name of the SKU column, and "store_price" is the name of the store price column:

<?php

$vendorData = [];

foreach( $rows as $row ) {
    if( !isset($vendorData[$row['vendor']]) ) {
        $vendorData[$row['vendor']] = '';
    }
    $vendorData[$row['vendor']] .= '<div class="sku">' .
        $row['sku'] . '</div>' .
        '<div class="price">' . $row['store_price'] . '</div>';
}

foreach( $vendorData as $vendorName => $vendorHTML ) {
    echo '<div id="' . $vendorName . '" class="vendor">' .
        '<h3 class="name">' . $vendorName . '</h3>' .
        '<div class="data">' . $vendorHTML . '</div></div>';
}

?>