Insert form inputs with the same input name into database rows using codeigniter

Question

I have a form with similar form input name which I would like to insert into different rows of database table. But when I submit form, the inputs with similar form input name don't get inserted.

Here is my view

<div class="row">

          <div class="col-xs-12">
            <div class="item-block">
              <div class="item-form">

                <button class="btn btn-danger btn-float btn-remove"><i class="ti-close"></i></button>

                <div class="row">
                  <div class="col-xs-12 col-sm-6">
                    <div class="form-group">
                      <input type="text" name="skills_name[]" class="form-control" placeholder="Skill name, e.g. HTML">
                    </div>
                  </div>

                  <div class="col-xs-12 col-sm-6">

                    <div class="form-group">
                      <div class="input-group">
                        <input type="text" name="skills_proficiency[]" class="form-control" placeholder="Skill proficiency, e.g. 90">
                        <span class="input-group-addon">%</span>
                      </div>
                    </div>

                  </div>
                </div>

              </div>
            </div>
          </div>

          <div class="col-xs-12 duplicateable-content">
            <div class="item-block">
              <div class="item-form">

                <button class="btn btn-danger btn-float btn-remove"><i class="ti-close"></i></button>

                <div class="row">
                  <div class="col-xs-12 col-sm-6">
                    <div class="form-group">
                      <input type="text" name="skills_name[]" class="form-control" placeholder="Skill name, e.g. HTML">
                    </div>
                  </div>

                  <div class="col-xs-12 col-sm-6">

                    <div class="form-group">
                      <div class="input-group">
                        <input type="text" name="skills_proficiency[]" class="form-control" placeholder="Skill proficiency, e.g. 90">
                        <span class="input-group-addon">%</span>
                      </div>
                    </div>

                  </div>
                </div>

              </div>
            </div>
          </div>

          <div class="col-xs-12 text-center">
            <br>
            <button class="btn btn-primary btn-duplicator">Add experience</button>
          </div>


        </div>

      </div>
    </section>
    <!-- END Skills -->

Controller:

function _get_skills_data(){

    $data4['skills_name'] = $this->input->post('skills_name', TRUE);
    $data4['skills_proficiency'] = $this->input->post('skills_proficiency', TRUE);
    $session_data = $this->session->userdata('logged_in');
    $data4['user_id'] = $session_data['user_id'];

    return $data4;

}

if ($this->form_validation->run($this) == FALSE)
            {
                    $this->add_resume();
            }
            else
            {

                    $data4 = $this->_get_skills_data();


                    $this->User_model->insert_resume('skills',$data4);

                    $this->session->set_flashdata('message', '<div class="alert alert-success">Resume Added</div>');


                    redirect('user/manage_resume', 'refresh');
            }

model:

function insert_resume($table, $data){

$query = $this->db->insert($table, $data);
return $this->db->insert_id();

}

Please what am i getting wrong,I have read some questions on this which isn't working for me. Thank you!

for firstly forget CI try to make the form like in core php and html then post the form, after that try in ci — san san
– san san, Commented Nov 7, 2016 at 12:13
In model write echo $this->db->last_query() before return . See what query is built. — Akshay
– Akshay, Commented Nov 7, 2016 at 12:13
The post skills_name[] is coming through as an array, you need to loop the array and build the insert script that way. At the moment I think you are trying to insert an array into the database. — Blinkydamo
– Blinkydamo, Commented Nov 7, 2016 at 12:14
Yes I am trying to insert an array into different database rows. I've tried looping through, and I get Array to string conversion error — Focus Ifeanyi
– Focus Ifeanyi, Commented Nov 7, 2016 at 12:23

Atural · Accepted Answer · 2016-11-07 12:46:10Z

2

Based on Blinkydamo's Comment you need to loop over your post data because you try to insert these as an array

try something like this:

function _get_skills_data()
{
    $arrData = array();
    $arrPostSkillsName = $this->input->post('skills_name', TRUE);
    $arrPostSkillsProficiency = $this->input->post('skills_proficiency', TRUE);
    $session_data = $this->session->userdata('logged_in');

    $count = count($arrPostSkillsName);

    for($i=0;$i<$count;$i++)
    {
        $arrItemData = array();
        $arrItemData['skills_name'] = $arrPostSkillsName[$i];
        $arrItemData['skills_proficiency'] = $arrPostSkillsProficiency[$i];
        $arrItemData['user_id'] = $session_data['user_id'];

        $arrData[] = $arrItemData;
    }

    return $arrData;
}

and your second controller function snippet

if ($this->form_validation->run($this) == FALSE)
{
    $this->add_resume();
}
else
{
    $arrData = $this->_get_skills_data();
    foreach($arrData AS $arrItemData)
    {
        $this->User_model->insert_resume('skills',$arrItemData);
    }
    $this->session->set_flashdata('message', '<div class="alert alert-success">Resume Added</div>');
    redirect('user/manage_resume', 'refresh');
}

answered Nov 7, 2016 at 12:46

Atural

5,4505 gold badges21 silver badges36 bronze badges

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

3 Comments

Focus Ifeanyi Over a year ago

But it adds one additional empty input into the database where could that be coming from

Atural Over a year ago

i've no idea - you've to print out the array - but i think the problem is, you leave the fields in your html form empty; maybe you do a check on the _get_skills_data function whether the data are set or not

Focus Ifeanyi Over a year ago

Thanks @sintakonte

Collectives™ on Stack Overflow

Insert form inputs with the same input name into database rows using codeigniter

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related