How to insert data to table using loop.?

Question

I want to insert data in database table using loop. For this I first need to get data of Account_id from user profile table. When user is registered with my website, his/her name table is create automatically, I am storing this table name in Account_id. that's why I must need this field.

First I get all registered users Account_id value. And then I am searching this table using for loop in model.

After I find this table, the row should be inserted, which is created dynamically like

$data = array(
    'Paper_Name' => $paper_name,
    'Paper_Type' => $paper_type,
    'paid_type' => $paid_type
);

Here is my model code.

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class create_main_table_model extends CI_Model {

    function login($data){

        $query = $this->db->insert('main_table', $data);    

        $update_userdata = $this->db->select('Account_id')->from('userprofile')->get();

                for($i =0; $i < $update_userdata->num_rows(); $i++){

                        $query = $this->db->insert($update_userdata[$i], $data);    

                }

        return ($this->db->affected_rows() > 0) ? true : false;
    }
}
?>

I want to Insert data to tables which is available in Account_id. If this is possible with other way then please tell me.

$this->db->insert ( $table, $data ); this is insert query in codeigniter — Hothi Jimit
– Hothi Jimit, Commented May 3, 2017 at 4:52
your almost right change this line $query = $this->db->insert($update_userdata[$i]->Account_id, $data); — JYoThI
– JYoThI, Commented May 3, 2017 at 4:55
you need to update the already existing row or you need new row ? — JYoThI
– JYoThI, Commented May 3, 2017 at 4:57

moje_mast_ram · Accepted Answer · 2017-05-03 05:19:44Z

3

This is perfect solution.

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class create_main_table_model extends CI_Model {

    function login($data){

        $pass_data = $data;
        $query = $this->db->insert('main_table', $data);    

        $update_userdata = $this->db->select('Account_id')->from('userprofile')->get();

                for($i =0; $i < $update_userdata->num_rows(); $i++){
                        $data1 = $update_userdata->result();
                        $query = $this->db->insert($data1[$i]->Account_id, $pass_data); 

                }

        return ($this->db->affected_rows() > 0) ? true : false;
    }
}
?>

answered May 3, 2017 at 5:19

moje_mast_ram

11413 bronze badges

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

Comments

Hothi Jimit · Accepted Answer · 2017-05-03 04:59:42Z

1

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class create_main_table_model extends CI_Model {

    function login($data){

        $query = $this->db->insert('main_table', $data);    

        $update_userdata = $this->db->select('Account_id')->from('userprofile')->get();

                for($i =0; $i < $update_userdata->num_rows(); $i++){

                $data['Account_id']=$update_userdata[$i]->Account_id;

                $query = $this->db->insert('table_name', $data);    

                }

        return ($this->db->affected_rows() > 0) ? true : false;
    }
}
?>

answered May 3, 2017 at 4:59

Hothi Jimit

3657 silver badges21 bronze badges

1 Comment

moje_mast_ram Over a year ago

I want to tell you again table name is Account_id. so use it as table name

JYoThI · Accepted Answer · 2017-05-03 05:26:45Z

1

Your almost right change this line to get the table name .

$update_userdata = $this->db->$update_userdata->result();
$query = $this->db->insert($update_userdata[$i]->Account_id, $data);

edited May 3, 2017 at 5:26

answered May 3, 2017 at 4:59

JYoThI

12.1k1 gold badge13 silver badges26 bronze badges

1 Comment

moje_mast_ram Over a year ago

I must get result before using this . like$this->db->$update_userdata->result();

Collectives™ on Stack Overflow

How to insert data to table using loop.?

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related