class model_trans_gc extends CI_Model{
function trans_gc_add()
{
$add=array(
'trans_gc_date' => $this->input->post('trans_gc_date'),
'trans_gc_no' => $this->input->post('trans_gc_no'),
'trans_gc_consname' => $this->input->post('trans_gc_consname'),
'trans_gc_consbank' => $this->input->post('trans_gc_consbank'),
'trans_gc_consname_add' => $this->input->post('trans_gc_consname_add'),
'trans_gc_consbank_add' => $this->input->post('trans_gc_consbank_add'),
'trans_gc_comp' => $this->input->post('trans_gc_comp'),
'trans_gc_pol' => $this->input->post('trans_gc_pol'),
'trans_gc_amt' => $this->input->post('trans_gc_amt'),
'trans_gc_insdate' => $this->input->post('trans_gc_insdate'),
'trans_gc_risk' => $this->input->post('trans_gc_risk'),
'trans_gc_from' => $this->input->post('trans_gc_from'),
'trans_gc_to' => $this->input->post('trans_gc_to'),
'trans_gc_packno' => $this->input->post('trans_gc_packno'),
'trans_gc_packdesc' => $this->input->post('trans_gc_packdesc'),
'trans_gc_actweight' => $this->input->post('trans_gc_actweight'),
'trans_gc_charweight' => $this->input->post('trans_gc_charweight'),
'trans_gc_method_pack' => $this->input->post('trans_gc_method_pack'),
'trans_gc_frt' => $this->input->post('trans_gc_frt'),
'trans_gc_hamali' => $this->input->post('trans_gc_hamali'),
'trans_gc_sr' => $this->input->post('trans_gc_sr'),
'trans_gc_aoc' => $this->input->post('trans_gc_aoc'),
'trans_gc_doorcln' => $this->input->post('trans_gc_doorcln'),
'trans_gc_doordel' => $this->input->post('trans_gc_doordel'),
'trans_gc_riskch' => $this->input->post('trans_gc_riskch'),
'trans_gc_dem' => $this->input->post('trans_gc_dem'),
'trans_gc_gc' => $this->input->post('trans_gc_gc'),
'trans_gc_total' => $this->input->post('trans_gc_total'),
'trans_gc_paymode' => $this->input->post('trans_gc_paymode'),
'trans_gc_crno' => $this->input->post('trans_gc_crno'),
'status' => '1'
);
$this->db->insert('trans_gc_add',$add);
$query=$this->db->get();
return $query->result();
}
}
Database Error Occurred
Error Number: 1096
No tables used
SELECT *
Filename: C:\xampp\htdocs\speed\system\database\DB_driver.php
Line Number: 330
please help me to resolve this problem
Remove those lines:
$query=$this->db->get();
return $query->result();
You are inserting into the db, then you are running empty query with get()
If you want to return if the data was successfully inserted or not, then do this:
return $this->db->insert('trans_gc_add',$add);
If you want to return the inserted data:
return $add;
http://ellislab.com/codeigniter/user-guide/database/active_record.html#insert