在這里你可以查看輸出
這是我的控制器：-
public function order_info()
{
$this->load->model('customize_model');
$data['user'] = $this->customize_model->order_info();
$data['product']=$this->customize_model->order_info();
$data['sale'] = $this->customize_model->order_info();
$this->load->view('custom/order',$data);
}
這是我的模態：-
public function order_info()
{
$query = $this->db->query("SELECT *
FROM user
JOIN product
ON user.user_id = product.product_id
JOIN sale
ON user.user_id = sale.buyer
ORDER BY user_id DESC LIMIT 100;");
return $query;
}
這是視圖：-
<?php foreach($sale->result() as $row)
{
$order_id = $row->sale_id;
$grand_total = $row->grand_total;
$status = $row->status;
?>
<tr>
<td><?php echo $order_id;?></td>
<td><?php echo $username;?></td>
<td><?php echo $productname?></td>
<td><?php echo $grand_total;?></td>
<td><?php echo $status;?></td>
</tr>
<?php
foreach($user->result() as $row1)
{
$username = $row1->username;
foreach($product->result() as $row2)
{
$productname = $row2->title;
}
}
}
?>
在我看來，我被困在單個表中顯示記錄。問題就在眼前。foreach 回圈在這種格式下不起作用，我應該用它來解決它。
uj5u.com熱心網友回復：
嘗試在您的視圖中執行此操作：-
<?php foreach($sale->result() as $row)
{
$order_id = $row->sale_id;
$grand_total = $row->grand_total;
$status = $row->status;
?>
<tr>
<td><?php echo $order_id;?></td>
<td><?php echo $row->username; ?></td>
<td><?php echo $row->title; ?></td>
<td><?php echo $grand_total;?></td>
<td><?php echo $status;?></td>
</tr>
<?php
}
?> 轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/416835.html
標籤：
上一篇：將三個SQL查詢合二為一
下一篇：語法錯誤，意外'='，期待')'