insert data into 2 table

In order to insert the primary key of table diskon into table diskon_tunai, codeIgniter has built in helper functions to help with this task.

PHP Code:

//prepare data for table diskon    
$data = array(
  'content' => 'My content',
);
//insert into table diskon
$this->db->insert('diskon',$data);

//prepare data for table diskon_tunai
$data = array(
  'id_diskon' => $this->db->insert_id(),
);
//insert into table diskon_tunai
$this->db->insert('diskon_tunai',$data);