How to insert dynamic input values into the database using codeigniter?

Question

I have dynamic input data and i want to store Item name(Refer image:1)

data into the database in the same column like given in the database image (Refer image:2).

How do i do that in codeigniter?

I want to store dynamic input data of item name like given in the item_name column.

<?php 
 Class my_controller extends CI_controller{         
   public function my_method(){
    $data = array(
    'total_price' => $this->input->post('total_price'), //Total price of all item
    'item_name' => $this->input->post('item_name') //Dynamic input value of item name
);
$result = $this->my_model->inser_item($data);
}
 }
?>

<div>
<form action="<?php echo base_url(); ?>my_controller/my_method" method="post">
<input type="text" name="item_name[]" id="item_name">
<input type="text" name="total_price" id="total_price">

<button type="submit" name="submit">Submit</button>
</form>
</div>

Thanks in advance.

Need a little more clarity on what you are trying to achieve. — abhinav
– abhinav, Commented Jan 19, 2018 at 6:07
Thanks both for the reply..I have dynamic input for item name and a input for total price ..i want to store the data of item name in a same column..like in the image "Database" item_name column. check the image you'll understand.. @abhinav — M N
– M N, Commented Jan 19, 2018 at 6:14
Your code and your images look quite different. In the image, you are having multiple inputs while in the code it looks like you are having just one input. — abhinav
– abhinav, Commented Jan 22, 2018 at 8:35

Hasta Dhana · Accepted Answer · 2018-01-20 17:13:21Z

1

I don't know if I get it correctly, if you want to insert the item_name values into a single table column, you could implode() it :

...
$data = array(
    'total_price' => $this->input->post('total_price'), //Total price of all item
    'item_name' => implode(',', $this->input->post('item_name')) //Dynamic input value of item name
);
...

answered Jan 20, 2018 at 17:13

Hasta Dhana

4,6947 gold badges21 silver badges28 bronze badges

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

1 Comment

M N Over a year ago

thanks for the answer Exactly what i was looking for.. @Hasta Dhana. I solved it already

Collectives™ on Stack Overflow

How to insert dynamic input values into the database using codeigniter?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related