How to insert an input with different values in to the mysql database using Codeigniter?

Question

I have got a form with some inputs like:

<form action="http://site.com" method="post" accept-charset="utf-8">
<input type="text" name="image_Title" value="Image" />
<input type="text" name="image_Basename" value="0000001" />
<input type="text" name="image_basename" value="0000002" />
<input type="text" name="image_basename" value="0000003" />
</form>

How can I insert each image_Id with the same image_Title to one row using Codeigniter?! I used foreach, but I couldn't make it work?!

for example:

table-row-name:image_Title              table-row-name:image_Basename
       'Image'                                '00000001'
       'Image'                                '00000002'
       'Image'                                '00000003'
       'Image2'                               '00000258'
       'Image2'                               '00000102'

How can I do that ?!

This is my php code ( of cource in Codeigniter):

foreach($_POST['image_Basename'] as $image_Basename) 
{
    $image_Id = $this->gallery_model->add(array('image_Title' => $_POST['image_Title'], 'image_Basename' => $image_Basename)); 
}

My Model:

function add($options = array())
{

    $options = array(

    'image_Title' => $_Post['image_Title'],

    'image_Basename' => $image_Basename

    );

    $this->db->insert('mg_gallery', $options);

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

How are you inserting? What programming language are you using? — Bart Friederichs
– Bart Friederichs, Commented Aug 20, 2013 at 7:07
I'm using PHP. I will test your solution and will inform you :) — Afshin
– Afshin, Commented Aug 20, 2013 at 8:14

Bart Friederichs · Accepted Answer · 2013-08-20 10:06:49Z

1

If you are using PHP, add [] to the input names, and you'll receive an array of values.

In the HTML

<input type="text" name="image_Id[]" value="0000003" />

With MySQLi (no error checking, no connecting):

foreach ($_POST['image_Id'] as $id) {
    $stmt = $mysqli->prepare("INSERT INTO table (id) VALUES (?)");
    $stmt->bin_param("s", $id);
    $stmt->execute();
}

edited Aug 20, 2013 at 10:06

answered Aug 20, 2013 at 7:07

Bart Friederichs

33.8k16 gold badges112 silver badges219 bronze badges

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

4 Comments

Afshin Over a year ago

then, how can I insert them?!

Bart Friederichs Over a year ago

Show some code of what you have tried. Basically, you loop over the array you receive from $_POST and insert the values.

Afshin Over a year ago

how should I insert name="name[]" in to the database in general?!

Bart Friederichs Over a year ago

@Afshin I updated my answer. I don't know CodeIgniter, so I cannot help you with that. This is how it works in plain PHP.

Collectives™ on Stack Overflow

How to insert an input with different values in to the mysql database using Codeigniter?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related