php - 防止一个数据循环

Question

<?php
include ("config.php");
$results = $mysqli->query
("
    SELECT              orders_history.transaction_id,
                        orders_history.items,
                        orders_history.quantity,
                        orders_history.one_product_price,

                        orders_list.status,
                        orders_list.invoices,
                        orders_list.payment_method,
                        orders_list.order_method,


                        delivery_orders.address,
                        delivery_orders.service,
                        delivery_orders.cost,
                        delivery_orders.city

    FROM                orders_history
    LEFT JOIN           orders_list
    ON                  orders_history.transaction_id = orders_list.transaction_id
    LEFT JOIN           infistall_order
    ON                  orders_history.transaction_id = infistall_order.transaction_id
    LEFT JOIN           delivery_orders
    ON                  orders_history.transaction_id = delivery_orders.transaction_id
    WHERE               orders_list.customer_name = 'Klaudia'"      
);

$orders = array();     
$html = '';     
if ($results) {
    while($obj = $results->fetch_object()) {
        $orders[$obj->transaction_id][$obj->items] = array(
            'invoices' => $obj->invoices, 
            'status' => $obj->status, 
            'payment_method' => $obj->payment_method, 
            'service' => $obj->service, 
            'cost' => $obj->cost, 
            'quantity' => $obj->quantity, 
            'one_product_price' => $obj->one_product_price, 
            'city' => $obj->city);
    }

    $html .= '<table width="70%"><tr>';
    $html .= '<td>transaction_id</td>';
    $html .= '<td>items</td>';
    $html .= '<td>quantity</td>';
    $html .= '<td>one_product_price</td>';
    $html .= '<td>status</td>';
    foreach ($orders AS $order_id => $order) {
        $html .= '<tbody><tr><td rowspan="' . count($order) . '">' . $order_id . '</td>';
        $row = 1;
        foreach ($order AS $item => $data) {
            if ($row > 1) { $html .= '</tr><tr>'; }
            $html .= '<td>' . $item . '</td>';
            $html .= '<td>' . $data['quantity'] . '</td>';
            $html .= '<td>' . $data['one_product_price'] . '</td>';
            $row++;
            $html .= '<td rowspan="' . count($order) . '">' . $data['status'] . '</td>';
        }
        $html .= '</tr><tbody>';
    }
    $html .= '</table>';
} 
echo $html;
?>

上面的代码会产生这样的结果:

 -----------------------------------------------------------------------
 id_cart         products        quantity       invoices     status
 -----------------------------------------------------------------------
                 this               2             $20        
                 -------------------------------------------------------    
  0001           that               1             $20        pending
                 -------------------------------------------------------    
                 those              2             $20                 pending  pending
 -----------------------------------------------------------------------
                                 Total Invoices:  $60   
 -----------------------------------------------------------------------

                 this               2             $20        
                 -------------------------------------------------------    
  0002           that               1             $20        approved
                 -------------------------------------------------------    
                 those              2             $20                approved   approved
 -----------------------------------------------------------------------
                                 Total Invoices:  $60   

查看状态栏，结果在循环中。

我想要的是它不应该循环并且只得到一个结果作为 id_cart 列的样子。这是状态栏的代码

  $html .= '<td rowspan="' . count($order) . '">' . $data['status'] . '</td>';

我需要解决它!

[编辑]

当我这样移动代码时:

    foreach ($orders AS $order_id => $order) {
        $html .= '<tbody><tr><td rowspan="' . count($order) . '">' . $order_id . '</td>';
        $row = 1;
        foreach ($order AS $item => $data) {
            if ($row > 1) { $html .= '</tr><tr>'; }
            $html .= '<td>' . $item . '</td>';
            $html .= '<td>' . $data['quantity'] . '</td>';
            $html .= '<td>' . $data['one_product_price'] . '</td>';
            $row++;
        }
        $html .= '<td rowspan="' . count($order) . '">' . $data['status'] . '</td>';
        $html .= '</tr><tbody>';


 -----------------------------------------------------------------------
 id_cart         products        quantity       invoices     status
 -----------------------------------------------------------------------
                 this               2             $20        
                 -------------------------------------------------------    
  0001           that               1             $20        
                 -------------------------------------------------------    
                 those              2             $20        pending  
 -----------------------------------------------------------------------
                                 Total Invoices:  $60   
 -----------------------------------------------------------------------
                 this               2             $20        
                 -------------------------------------------------------    
  0002           that               1             $20        
                 -------------------------------------------------------    
                 those              2             $20        approved   
 -----------------------------------------------------------------------
                                 Total Invoices:  $60   

结果在 tbody 最底部的状态栏中。我想要它作为 id_cart 的列。

Answer 1

每个 tbody 需要 1 个状态值，因此将其放在循环之外。另外，因为您正在重复使用 $order , 我把 count($order)在一个单独的变量中。另外，关闭你的 </tbody>标签。

foreach ($orders AS $order_id => $order) {
        $orderCount = count($order);
        $html .= '<tbody><tr><td rowspan="' . $orderCount . '">' . $order_id . '</td>';
        $row = 1;
        foreach ($order AS $item => $data) {
            if ($row > 1) { $html .= '</tr><tr>'; }
            $html .= '<td>' . $item . '</td>';
            $html .= '<td>' . $data['quantity'] . '</td>';
            $html .= '<td>' . $data['one_product_price'] . '</td>';
            if ($row == 1) 
              $html .= '<td rowspan="' . $orderCount . '">' . $data['status'] . '</td>';
            $row++;
        }
          $html .= '</tr></tbody>';
    }