我想询问我的程序。我想编辑,但无法在jurnal表中编辑,而在bahan_baku表中成功编辑。请救救我。我有两张桌子。
bahan_baku表id_bahanbakuketerangan_bbtanggal_bbjumlah_bbharga_bb
表陪审员id_jurnalid_coa唐格尔debetkredit
这是我的型号->m_bahanbaku.php
function m_edit($data_bb){
$this->db->where($data_bb);
$edit_bb = $this->db->get('bahan_baku');
return $edit_bb->result();
$this->db->where($data_jurnal);
$edit_jurnal = $this->db->get('jurnal');
return $edit_jurnal->result();
}
function m_update($data_bb, $id_bahanbaku,$data_jurnal, $id_coa){
$this->db->where('id_bahanbaku', $id_bahanbaku); //untuk tabel bahan_baku
$this->db->update('bahan_baku', $data_bb);
$this->db->where('id_jurnal', $id_jurnal); //dari tabel jurnal
$this->db->update('jurnal', $data_jurnal);
}}
这是我的控制器->bahanbaku.php
function edit($id_bahanbaku){
$data_bb=array(
'id_bahanbaku'=>$id_bahanbaku
);
$data_jurnal=array(
'id_jurnal'=>$id_bahanbaku
);
$data_bb['data_edit']=$this->m_bahanbaku->m_edit($data_bb, $data_jurnal);
$this->load->view('keuangan/v_edit_bb',$data_bb, $data_jurnal);
}
function update(){
$id_bahanbaku = $this->input->post('id_bahanbaku');
$data_bb=array(
'keterangan_bb' => $this->input->post('keterangan_bb'),
'tanggal_bb' => $this->input->post('tanggal_bb'),
'jumlah_bb' => $this->input->post('jumlah_bb'),
'harga_bb' => $this->input->post('harga_bb')
);
$id_jurnal = $this->input->post('id_jurnal');
$data_jurnal=array(
'tanggal' => $this->input->post('tanggal_bb'),
'debet'=>$this->input->post('harga_bb'),
'kredit'=>$this->input->post('harga_bb')
);
$this->m_bahanbaku->m_update($data_bb, $id_bahanbaku, $data_jurnal, $id_jurnal);
redirect(base_url().'keuangan/bahanbaku/lihat');
}
}
> $this->db->where('id_jurnal', $id_jurnal);
用$id_coa
替换$id_jurnal
查看您的参数名称:--
function m_update($data_bb, $id_bahanbaku,$data_jurnal, `$id_coa`)
function m_update($data_bb, $id_bahanbaku,$data_jurnal, $id_coa){
$this->db->where('id_bahanbaku', $id_bahanbaku); //untuk tabel bahan_baku
$this->db->update('bahan_baku', $data_bb);
$this->db->where('id_jurnal', $id_coa); //dari tabel jurnal
$this->db->update('jurnal', $data_jurnal);
}
}
检查我的代码并将其与您的代码进行比较。我希望这将解决您的问题。
问候