How to batch insert rows from a form submission with CodeIgniter's query builder

Question

I just wanted some help figuring out how I would insert data that was coming out of a multiple select box, being put into a variable and then into a database.

My database table is structured like this - Table: prd_attr

ID | Product_ID | name | value
-------------------------------
1  | 3          | size | large
2  | 3          | size | medium

So say I have a multiple select box with the name sizes[], and the admin selects 2 sizes for a product to enter into the database. I can get these values in the controller and put them into a variable:

$sizes = $_GET['sizes'];

and pass that variable to the model. Once its there, I can insert the data as a MySQL query like this:

foreach ($sizes as $s)
{
    $query = mysql_query("insert into prd_attr ('name', 'value') VALUES ('size','$s')");
}

But I've learned that mysql_* is deprecated, and since I'm using a framework which provides Active Records I'd like to make use of that. I know the basics of Active Record, but since this is a foreach loop over a variable which can hold any number of values, I don't know how to include a foreach statement with Active Records.

Could someone please explain?

The mysql_* functions are deprecated. Use PDO or MySQLi! php.net/manual/en/mysqlinfo.api.choosing.php — Jordi Kroon
– Jordi Kroon, Commented Feb 13, 2013 at 14:09

Code Prank · Accepted Answer · 2013-02-13 15:39:07Z

2

You can also use batch insert in codeigniter:

Try this:

function insert_sizes()
{
    $sizes  =   $this->input->get('sizes');
    foreach ($sizes as $s)
    {
        $data[] = array(
          'name' => 'size',
          'value' => $s
        );
    }
    $this->db->insert_batch('prd_attr',$data);
}

For more details:
http://ellislab.com/codeigniter/user-guide/database/active_record.html

answered Feb 13, 2013 at 15:39

Code Prank

4,2706 gold badges35 silver badges48 bronze badges

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

1 Comment

a7omiton Over a year ago

I was looking at insert_batch! but was confused as the documentation showed that it was an array with arrays inside. I need to learn to take a hint! Thanks

Muhammad Raheel · Accepted Answer · 2013-02-13 14:07:29Z

1

You can use this in Model of Codeigniter. Here is a method

function insert_sizes()
{
    $sizes  =   $this->input->get('sizes');
    $data['name']   =   'size';
    foreach ($sizes as $s)
    {
        $data['value']  =   $s;
        $this->db->insert('prd_attr',$data);
    }
}

edited Feb 13, 2013 at 14:07

answered Feb 13, 2013 at 14:02

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

4 Comments

a7omiton Over a year ago

Is $data['size'] corresponding to the column name in my database? In that case would it need to be $data['name'] = 'size'; ?

Muhammad Raheel Over a year ago

Yes you are right. Sorry i mistyped it should be $data['name'] = 'size';

a7omiton Over a year ago

Thank you, also just wondering does it conform to MVC that you are receiving the input from the view directly in the model? I was told views and models can't directly interact

Muhammad Raheel Over a year ago

yes i am doing same if it is not working for you than get it in Controller and pass to model method

Collectives™ on Stack Overflow

How to batch insert rows from a form submission with CodeIgniter's query builder

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related