再会。我现在正在尝试创建来自我的 sql 表的详细信息。

这是我的 PHP:-

public function export()
    {
        $query = $this->input->cookie("cookie_invent_query");
        $data['header'] = $this->modelmodel->showdata($query);
        foreach($data['header'] as $header){
            $data['detail'][] = $this->modelmodel->showdata("select * from DeliveryOrderDetail 
                                                            where deliveryordertransno = '".$header->TransactionNo."' ");
        }
        echo "<pre>"; print_r($data['detail']);
        $this->load->view("do_mutasi/export",$data);
    }

用我上面的脚本我得到了 print_r()

结果来自 $data['header']

    Array
    (
        [0] => stdClass Object
            (
                [FinalReleaseStatus] => 1
                [DeliveryOrderDate] => 2016-12-21 17:25:18.487
                [TransactionNo] => DO-DL-K-LFKG-11
                [DocumentNo] => DOZZ-DL-K-LFKG-6
                [ToCustomerCode] => AFF004
                [CategoryCode] => ZZ
                [ETADate] => 2016-12-21 17:25:18.487
            )

    )

结果来自 $data['detail']

Array
(
    [0] => Array
        (
            [0] => stdClass Object
                (
                    [TransactionNo] => DOD-DL-K-LFKG-9
                    [LineNo] => 1000
                    [ItemCode] => FA00000111
                    [DeliveryOrderTransNo] => DO-DL-K-LFKG-11
                    [ExtraRemark] => 0
                    [ExtraRemark2] => 0
                    [Quantity] => 3.00000000000000000000
                    [UOMCode] => PCS
                    [CreatedDate] => 2016-12-21 17:26:25.063
                    [CreatedBy] => boby
                    [ModifiedDate] => 2016-12-21 17:26:25.063
                    [ModifiedBy] => 
                )

        )

)

然后在我将它发送到我的视图之后，这是我现在可以做的

<?php foreach($header as $hdr) { ?>
 Header
    <table class="table">
        <thead>
            <tr>
                <th>Trnsaction No</th>
                <th>Document No</th>
                <th>To Customer</th>
                <th>Delivery Order Date</th>
            </tr>
        </thead>
        <tbody>
            <td><?=$hdr->TransactionNo;?></td>
            <td><?=$hdr->DocumentNo;?></td>
            <td><?=$hdr->ToCustomerCode;?></td>
            <td><?=$hdr->DeliveryOrderDate;?></td>
        </tbody>
    </table>
Detail
<table>
    <thead>
        <tr>
            <th>Transaction No</th>
            <th>Item Code</th>
            <th>Quntity</th>
            <th>Uom Code</th>
        </tr>
    </thead>
    <tbody>
     <?php 

     foreach($detail as $rsltdt =>$key) { ?>
        <tr>
            <td><?=$rsltdt['TransactionNo'];?></td>
            <td><?=$rsltdt['ItemCode'];?></td>
            <td><?=$rsltdt['Quantity'];?></td>
            <td><?=$rsltdt['UOMCode'];?></td>
        </tr>
    <?php } ?>
    </tbody>
</table>

<?php } ?>

如你看到的。我在循环detail内部header循环。因为在一些records有多个细节。我循环标题是因为我想显示多个records而不是一个record

这是到目前为止的结果

我无法显示细节。所以我的问题是。我如何显示细节取决于标题。

[TransactionNo] = [DeliveryOrderTransNo]

解决方案

Check once:-

foreach($detail as $rsltdt) { 
  foreach ($rsltdt as $rsl){ ?> 
    <tr> 
        <td><?=$rsl->TransactionNo;?></td> 
        <td><?=$rsl->ItemCode;?></td> 
        <td><?=$rsl->Quantity;?></td> 
        <td><?=$rsl->UOMCode;?></td> 
    </tr> 
<?php } } ?>