How to insert arrays into MySQL using Codeigniter?

Question

Regarding my project I want insert per employee{employee_no} many descriptions with voucher_no and amount, and many support document, so I have created my view page for descriptions and support document add multiple fields.

So I can add many fields as many as I want but I want to insert those data into my database normally when I insert data without descriptions and support documents.

It works perfectly but my requirement is to make this code to insert multiple descriptions and support documents.

this is my View page : fields to descriptions and support documents

<div class="form-group">
        <div class="row colbox">
        <div class="col-sm-offset-2 col-lg-8 col-sm-8 text-left">Description</div>

        <div class="field_wrapper">
            <input type="textarea" name="descrip[]" value="" size="35px" /><input type="text" name="voucher_no[]" value="" size="7px"/><input type="text" name="price[]" value=""size="7px"/>
            <a href="javascript:void(0);" class="add_button" title="Add field"><img src="<?php echo base_url('images/add-icon.png'); ?>"/></a>
        </div></div></div>

        <div class="form-group">
        <div class="row colbox">
        <div class="col-sm-offset-2 col-lg-8 col-sm-8 text-left">SUPPORT DOCUMENT</div><br />

        <div class="field_upload">
            <input type="file" name="field_upload[]" value="" size="35px" />
            <a href="javascript:void(0);" class="add_butt" title="Add field">
            <img src="<?php echo base_url('images/add-icon.png'); ?>"/></a>
        </div></div></div>

my controller :

  function index()
    {
        //fetch data from department and designation tables
        $data['department'] = $this->employee_model->get_department();
        $data['designation'] = $this->employee_model->get_designation();
        //$data['descrip'] = $this->employee_model->insert_descriptions();

        //set validation rules
        $this->form_validation->set_rules('employeeno', 'Employee No', 'trim|required|numeric');
        $this->form_validation->set_rules('employeename', 'Employee Name', 'trim|required|callback_alpha_only_space');
        $this->form_validation->set_rules('department', 'Department', 'callback_combo_check');
        $this->form_validation->set_rules('designation', 'Designation', 'callback_combo_check');
        $this->form_validation->set_rules('hireddate', 'Hired Date');
        $this->form_validation->set_rules('salary', 'Salary', 'required|numeric');

        $this->form_validation->set_rules('document', 'Document', 'trim');
        $this->form_validation->set_rules('descrip', 'Description', 'trim');

        if ($this->form_validation->run() == FALSE)
        {
            //fail validation
            $this->load->view('employee_view', $data);
        }
        else
        {    
            //pass validation
            $data = array(
                'employee_no' => $this->input->post('employeeno'),
                'employee_name' => $this->input->post('employeename'),
                'department_id' => $this->input->post('department'),
                'designation_id' => $this->input->post('designation'),
                'hired_date' => @date('Y-m-d', @strtotime($this->input->post('hireddate'))),
                'salary' => $this->input->post('salary'),
                'description' => $this->input->post('descrip'),
'document' => $this->input->post('filed_upload'),

            );

            //insert the form data into database
            $this->db->insert('tbl_employee', $data);

I know I want to use foreach loop for descriptons and support documents but I don't know how to use it

What you want enter description into multiple column with same data??? — Saty
– Saty, Commented Aug 4, 2015 at 8:15
@my concept is per employee many description so its not static its dynamic so i want insert descrtptions same employeeno — Hamelraj
– Hamelraj, Commented Aug 4, 2015 at 8:40
Why not you create a new table for description and there mapping of description and employee in other table. — Saty
– Saty, Commented Aug 4, 2015 at 8:43

Nithin Krishnan P · Accepted Answer · 2015-07-03 07:22:04Z

1

You can use insert_batch For Eg:

$data = array(
   array(
      'title' => 'My title' ,
      'name' => 'My Name' ,
      'date' => 'My date'
   ),
   array(
      'title' => 'Another title' ,
      'name' => 'Another Name' ,
      'date' => 'Another date'
   )
);

$this->db->insert_batch('mytable', $data); 

// Produces: INSERT INTO mytable (title, name, date) VALUES ('My title', 'My name', 'My date'), ('Another title', 'Another name', 'Another date')

answered Jul 3, 2015 at 7:22

Nithin Krishnan P

7581 gold badge6 silver badges14 bronze badges

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

Comments

Harish Lalwani · Accepted Answer · 2015-07-03 08:55:21Z

1

you have three solutions for your problem.

This will generate a redundant data but its the straight solution, I will not prefer that.

loop around your insert array on the basis of description and document array.(these both will be posted as array) and then use this for batch insert

$this->db->insert_batch();

You can use implode and convert these arrays in comma separated values and insert them employee table. I will not prefer this too.
The third the best. Make two other tables description and documents (To store multiple description related data and document for inserting multiple documents) these both will contain foreign key for employee table. One employee entry and other description and document entries. This link may help you with queries.

http://www.codeigniter.com/userguide2/database/active_record.html#update

edited Jul 3, 2015 at 8:55

user4419336

answered Jul 3, 2015 at 7:24

Harish Lalwani

7845 silver badges20 bronze badges

2 Comments

Hamelraj Over a year ago

your first idea not posible and if u implement my contoller for your 2nd

Harish Lalwani Over a year ago

please if you can give table structure it will be more helpful, I still prefer the third.

NealH · Accepted Answer · 2015-07-03 09:21:35Z

1

You could get a count of the records, then use a for loop to create the data array to insert into the database.

$records = count($_POST['employee_no'];

for($i=0; $i<$records; $i++) {
    $data = array(
        'employee_no' => $_POST['employeeno'][$i],
        'employee_name' => $_POST['employeename'][$i]
        ..etc
    );

    $this->db->insert('tbl_employee', $data);
}

answered Jul 3, 2015 at 9:21

NealH

212 bronze badges

Collectives™ on Stack Overflow

How to insert arrays into MySQL using Codeigniter?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related