insert array data into two table using CodeIgniter

Question

I have a registration form and will inserting data inputed into two different table using registration function. This is the table structure:

user

user_id(int)
user_email(varchar(64))
user_name(varchar(64))
user_pass(varchar(64))

profiles

prof_id(int)
user_id(int)
first_name(varchar(64))
last_name(varchar(64))
...(other field)

I put the variables into two different array ($data1 & $data2) here is my controller:

function add_account() {
    $this->load->model('m_signup');
    // get form variable
    $first_name = $this->input->post('first_name');
    $last_name = $this->input->post('last_name');
    $user_email = $this->input->post('user_email');
    $user_name = $this->input->post('user_name');
    $user_pass = $this->input->post('user_pass');


    $data1 = array($user_name, $user_email, $user_pass);
    $data2 = array($first_name, $last_name);

    $this->m_signup->add_account($data1, $data2);

    redirect('login');
}

and the model was like this:

function add_account($data1, $data2) {
    $this->db->trans_start();

    $sql1 = "INSERT INTO users(user_name, user_email, user_pass) 
            VALUES (?, ?, ?)";

    $this->db->query($sql1, $data1); 
    $id_user = $this->db->insert_id(); 

    $sql2 = "INSERT INTO profiles(user_id, first_name, last_name) 
            VALUES ($id_user, ?, ?)"; 
    $this->db->query($sql2, $data2);

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

    $this->db->trans_complete(); 

}

When I submit the registration, its work in table users, but the table profiles still going empty. Please help me correct my add_account function above.

Kumar V · Accepted Answer · 2014-01-12 15:37:20Z

1

Exchange the lines: Line $this->db->trans_complete(); is not reachable.

You are returning id before committing the transaction.

 $this->db->trans_complete(); 

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

edited Jan 12, 2014 at 15:37

answered Jan 12, 2014 at 15:25

Kumar V

8,8289 gold badges44 silver badges60 bronze badges

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

4 Comments

user3187482 Over a year ago

thanks kumar, could you give me a guidance how to join both table using user_id as foreign key

Kumar V Over a year ago

Are asking for getting record from two table? Or do you want to create foreign key?

user3187482 Over a year ago

I wanna create foreign key in users table so I can do CRUD operations in my models.

Kumar V Over a year ago

refer this: stackoverflow.com/questions/6977086/…

Ganpat Thakor · Accepted Answer · 2021-09-13 06:21:31Z

0

in controller

function add_account() {
    $this->load->model('m_signup');
    // get form variable


    $first_name = $this->input->post('first_name');
    $last_name = $this->input->post('last_name');
    $user_email = $this->input->post('user_email');
    $user_name = $this->input->post('user_name');
    $user_pass = $this->input->post('user_pass');


    $data1 = array($user_name, $user_email, $user_pass);

    

    $data1_id = $this->m_signup->add_account($data1);


    $data2 = array($data1_id,$first_name, $last_name,);

    $data_id = $this->m_signup->add_account($data2,$data1_id);

    redirect('login');
}

answered Sep 13, 2021 at 6:21

Ganpat Thakor

634 bronze badges

Comments

Ganpat Thakor · Accepted Answer · 2021-09-13 06:24:51Z

0

in model

function add_account($data1 = '', $data2 = '' , $id = '') {
    $this->db->trans_start();

    if(empty($id)){
    $sql1 = "INSERT INTO users(user_name, user_email, user_pass) 
            VALUES (?, ?, ?)";

    $this->db->query($sql1, $data1); 
    $id_user = $this->db->insert_id(); 

    }else{
    $sql2 = "INSERT INTO profiles(user_id, first_name, last_name) 
            VALUES (?, ?, ?)"; 
    $this->db->query($sql2, $data2);
    }
    return $this->db->insert_id(); 

    $this->db->trans_complete(); 

    }

answered Sep 13, 2021 at 6:24

Ganpat Thakor

634 bronze badges

Collectives™ on Stack Overflow

insert array data into two table using CodeIgniter

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related