将数据插入codeigniter中的不同表

Question

So I have 2 tables.

Table 1: (person_identity)

Id_person(PK), name, address, telp

Table 2: (Student)

Id_person(FK), no_student (PK), status, parent

How to input data to name, address, no_student, parent and status at the same time with the same Id_person but at 2 different table?

Answer 1

You can do like this

$dataPersonIdentity = ['name' => 'Abc', 'address' => 'This is address', 'telp' => 'this is telp'];
$this->db->insert('person_identity',$dataPersonIdentity);
$personIdentityId = $this->db->insert_id();

$dataStudent = ['Id_person' => $personIdentityId, 'no_student' => 8, 'status' => 1, 'parent' => 1];