PHP 和 SQL WHERE(更改变量)

Question

美好的一天，我正在努力处理这段代码..
结果“10”设置为 $fod，但需要替换它以显示被调用行的 id，以便 SQL WHERE 可以列出相关行中的正确数据。请参阅图片了解我得到的结果。

See Current Result and Desired Result
正如您所看到的，我需要 ROW ID 10 来显示 10 的项目，并需要 ROW ID 11 来显示 11 的项目。请帮助我，如何调用这些行才能正确显示？
调用功能:
Controller .php

$data['order_list'] = $this->product->data_ordershalf();
$fod = 10;
$data['order_listfull'] = $this->product->data_ordersfull($fod);

函数.php:

function data_ordershalf(){
    $this->db->select('*');
    $this->db->join('order_detail', 'order_detail.orderid=orders.id', 'left');
    $this->db->join('customers', 'customers.id=orders.customerid', 'left');
    $this->db->join('testshop_products', 'testshop_products.product_id=order_detail.productid', 'left');
    $this->db->from('orders');
    $this->db->group_by('orderid');
    $rs = $this->db->get();
    return $rs->result_array();
}
function data_ordersfull($fod){
    $this->db->select('*');
    $this->db->join('orders', 'orders.id=order_detail.orderid', 'left');
    $this->db->join('testshop_products', 'testshop_products.product_id=order_detail.productid', 'left');
    $this->db->from('order_detail');
    $this->db->where('orderid',$fod);
    $rs = $this->db->get();
    return $rs->result_array();

查看.php:

<?php if(!$order_list){ ?>
<tbody>
    <tr>
        <th colspan="7"><center>No orders placed</center></th>
    </tr>
</tbody>
<?php } else { $sr = 1; ?>
<tbody>
    <?php foreach( $order_list as $row) { ?>
    <tr>
        <th scope="row"><?php echo $row['id']; ?></th>
        <td><?php echo $row['date']; ?></td>
        <td><?php echo $row['name']; ?></td>
        <td>
            <table>
                <?php foreach( $order_listfull as $row2) { ?>
                <tr>
                    <th scope="row"><?php echo $row2['id']; ?></th>
                    <td><?php echo $row2['product_name']; ?></td>
                    <td><?php echo $row2['quantity']; ?></td>
                    <td></td>
                    <td><?php echo $row2['price']; ?></td>
                 </tr>
                <?php } ?>
            </table>
        </td>
        <td><?php echo $row['quantity']; ?></td>
        <td><?php echo $row['price']; ?></td>
    </tr>
    <?php } ?>
</tbody>
<?php } ?>

Answer 1

您可以创建助手并在其中添加以下函数。

function data_ordersfull($fod){
    $this->db->select('*');
    $this->db->join('orders', 'orders.id=order_detail.orderid', 'left');
    $this->db->join('testshop_products', 'testshop_products.product_id=order_detail.productid', 'left');
    $this->db->from('order_detail');
    $this->db->where('orderid',$fod);
    $rs = $this->db->get();
    return $rs->result_array();
}

====================View.php========================== =============

<?php if(!$order_list){ ?>
            <tbody>
              <tr>
                <th colspan="7"><center>No orders placed</center></th>
              </tr>
            </tbody>
            <?php } else { $sr = 1; ?>
            <tbody>
              <?php foreach( $order_list as $row) { 
$order_listfull=data_ordersfull($row['id']);
?>
              <tr>
                <th scope="row"><?php echo $row['id']; ?></th>
                <td><?php echo $row['date']; ?></td>
                <td><?php echo $row['name']; ?></td>
                <td><table>
              <?php foreach( $order_listfull as $row2) { ?>
              <tr>
                <th scope="row"><?php echo $row2['id']; ?></th>
                <td><?php echo $row2['product_name']; ?></td>
                <td><?php echo $row2['quantity']; ?></td>
                <td></td>
                <td><?php echo $row2['price']; ?></td>

              </tr>
              <?php } ?></table></td>
                <td><?php echo $row['quantity']; ?></td>
                <td><?php echo $row['price']; ?></td>

                  </tr>
                  <?php } ?>
                </tbody>
                <?php } ?>