Inserting data into multiple tables with foreign key using CodeIgniter framework

Question

here's my controller

function c_submit(){
    $data = array(
        'no_form' => $this->input->post('noform'),
        'kode_bps' => $this->input->post('kodebps'),
        'no_obs' => $this->input->post('noobs'),
        'no_koor' => $this->input->post('nokoor'),
        'tanaman_u' => $this->input->post('tutama'),
        't_tanah' => $this->input->post('ttanah'),
        'catatan' => $this->input->post('cat')
    );

    $datakoor = array(
        'no_koor' => $this->input->post('nokoor'),
        'utm_y' => $this->input->post('y'),
        'utm_x' => $this->input->post('x'),
        'latit' => $this->input->post('deg')." ".
                    $this->input->post('min')." ".
                    $this->input->post('sec'),
        'longi' => $this->input->post('deg2')." ".
                    $this->input->post('min2')." ".
                    $this->input->post('sec2')
    );

    $no_obs = $this->session->userdata('no_obs');
    $this->m_input->m_submit($data, $datakoor);
    redirect(base_url("c_input"));
}

and the model

function m_submit($data, $datakoor) {

    $this->db->trans_start();

    $this->db->insert('koor_pen', $datakoor); 
    $no_koor = $this->db->insert_id(); 

    $this->db->where('no_koor',$no_koor);
    $this->db->insert('input_pen', $data);

    $this->db->trans_complete(); 

    return $this->db->insert_id(); 

}

when I run the code, it shows an error like this

Please check value you are adding in child table that exist in your master table. — Pankaj Sharma
– Pankaj Sharma, Commented Jun 15, 2017 at 7:02
What if the two tables is inputted in the same time in one form? @PankajSharma — Kiki
– Kiki, Commented Jun 15, 2017 at 7:13
@Kiki plz first check in koor_pen table record is inserted or not. — Pankaj Sharma
– Pankaj Sharma, Commented Jun 15, 2017 at 7:30

B. Desai · Accepted Answer · 2017-06-15 07:25:53Z

2

Your value is getting null. You have to pass $no_koor in $data so that value can be replaced. Try this:

function m_submit($data, $datakoor) {

    $this->db->trans_start();

    $this->db->insert('koor_pen', $datakoor); 
    $no_koor = $this->db->insert_id(); 

    //$this->db->where('no_koor',$no_koor);
    $data['no_koor'] = $no_koor;
    $this->db->insert('input_pen', $data);

    $this->db->trans_complete(); 

    return $this->db->insert_id(); 

}

answered Jun 15, 2017 at 7:25

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pankaj Sharma · Accepted Answer · 2017-06-15 07:07:34Z

1

Problem is here no_koor (foreign) this is you foreign key and in your query no_koor this field is getting "" in your query as you send in image. so please check your query first.

answered Jun 15, 2017 at 7:07

Pankaj Sharma

2365 silver badges20 bronze badges

Comments

Mayank Pandeyz · Accepted Answer · 2017-06-15 07:02:52Z

0

The error is related to foreign key constraint as shown in your image. The rule is, you can only add or update a value in child table which are already present in parent table. So at the time of insertion make sure the value you are trying to insert in child table, already exist in parent table.

Sometimes the insertion sequence also matters, may be the value is their in the query, but you are running child table query first. So check the order also in that case.

answered Jun 15, 2017 at 7:02

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

5 Comments

Kiki Over a year ago

What if the two tables is inputted in the same time in one form?

Mayank Pandeyz Over a year ago

The sequence is like Add data in master first and then in child

Kiki Over a year ago

so it is possible or not when i inputted two table in the same time in one form?

Mayank Pandeyz Over a year ago

Yes, just follow the above sequence

Kiki Over a year ago

yes i did, but it doesn't work at all. can you help me by seeing my model?

Collectives™ on Stack Overflow

Inserting data into multiple tables with foreign key using CodeIgniter framework

3 Answers 3

Comments

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related