4 replies to this topic

[Ahmed Adebiyi Oladapo]

I have 2 tables i.e Parent and Child. In Parent Table I have Primary Key which is also a Foreign Key in the Child Table.

How can i add new record(s) into the Child table so that the parent ID (Foreign Key) column is automatically populated and linked to a specific parent in the parent table.

 

[Athar]

Use Triggers

[hurtz]

@athar - can you please give an example on how to do this in CI?

[Athar]

What you want is not a difficult at all if you study grocery crud documents. Lets take the same Parent/Child example. Create a controller by the name of Family as follows.

public function Family()
 {
  $crud = new grocery_CRUD();
  $crud->set_table('child');
  $crud->columns('ID_child','ID_Parent','Child_Name');
  $crud->set_relation('ID_Parent','Parent','Parent_Name');

  $crud->set_subject('List of Children and their Parents');

  $output = $crud->render();
  $this->_example_output($output);
 }

[hurtz]

sorry my mistake   my mind was floating when i wrote this question, i was thinking of a different scenario. hope didn't bother you much.