首页 > 解决方案 > 在 Codeigniter 的一个视图中对两个表使用两个 Foreach

问题描述

我正在使用 Codeigniter,我正在创建一个函数,它使用取自两个 Foreach 函数的 2 个变量根据表中的值替换文本,以下是我编写的代码示例,但它似乎无法正常工作应该

表“Claim”和“Claim_process”结构

id_claim | artist_name | claim_date | claim_amount | status 

模型

//ADMIN_CLAIM

 function Tampil_claim_admin(){
  return $this->db->get('claim');
 }
  function Input_claim($data,$table){
  $this->db->insert($table,$data);
 }
 
 function edit_claim($where,$table){  
  return $this->db->get_where($table,$where);
 }

 function update_claim($where,$data,$table){
  $this->db->where($where);
  $this->db->update($table,$data);
 }

 function delete_claim($where,$table){
  $this->db->where($where);
  $this->db->delete($table);
 } 

  //ADMIN_CLAIM_PROCESS

 function Tampil_claim_admin_process(){
  return $this->db->get('claim_process');
 }
  function Input_claim_process($data,$table){
  $this->db->insert($table,$data);
 }
 
 function edit_claim_process($where,$table){  
  return $this->db->get_where($table,$where);
 }

 function update_claim_process($where,$data,$table){
  $this->db->where($where);
  $this->db->update($table,$data);
 }

 function delete_claim_process($where,$table){
  $this->db->where($where);
  $this->db->delete($table);
 } 

控制器

function index(){
$data['claim'] = $this->m_admin_data->Tampil_claim_admin()->result();
$data['claim_process'] = $this->m_admin_data->Tampil_claim_admin_process()->result();
$this->load->view('admin/v_admin_claim',$data);
}

看法

<tr>
<td>MSC-CLAIM- <?php foreach ($claim as $data):
endforeach;

foreach ($claim_process as $data):
endforeach;

echo $data->id_claim; ?></td>
<td><?php echo $data->artist_name; ?></td>

<td><?php echo date('d-m-Y', strtotime($data->claim_date)); ?></td>  
                                                 

<td>$ <?php echo $data->claim_amount; ?></td>  


<td><?php if ($data->status = 'On Process') { ?>
<?php echo anchor('Admin_claim/edit_claim_process/' . $data->id_claim, 'Process'); ?>  
<?php else { ?>

<span class="label label-primary"> <?php echo "Sudah di Selesai"; ?> </span>

<?php } ?></td>
                                                

标签: phpmysqlcodeignitercodeigniter-3

解决方案


推荐阅读