how to Insert Multiple data with insert_batch in codeigneitor

Question

i want to insert records of fifty persons to the database at one time(this can be increase).when user click the save button data should be save at the database.what is the best way to do it?

Here is my controller

function month_end_data()
    {
$data_save = array(
                    'employee_id' => $emp,
                    "annual" => $annual,
                    "casual" => $casual
);
                $id = $this->monthend_mod->savemonthenddata($data_save);
                echo json_encode(array("status" => TRUE, "id" => $id));
}

Model

class monthend_mod extends CI_Model
{
    public function savemonthenddata($data_save = array())
    {
        if ($this->db->insert_batch('pay_monthend', $data_save)) {
            return true;
        } else {
            return false;
        }
    }
}

view

<button onclick="month_end_data()" class="btn btn-danger">Save</button>

stackoverflow.com/questions/37940244/…

Divyesh Patoriya
– Divyesh Patoriya

2016-06-21 12:11:52 +00:00
Commented Jun 21, 2016 at 12:11 — Divyesh Patoriya
– Divyesh Patoriya, Commented Jun 21, 2016 at 12:11

M. Eriksson · Accepted Answer · 2016-06-21 12:12:35Z

1

Try to send in a multidimensional array:

$data = array(
    array(
        'employee_id' => 'xx',
        //... more fields
    ),
    array(
        'employee_id' => 'yy',
        //... more fields
    ),
    array( 
        //... and so on
    ),
);

...and then send that to your savemonthenddata()-method.

answered Jun 21, 2016 at 12:12

M. Eriksson

13.7k4 gold badges31 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

how to Insert Multiple data with insert_batch in codeigneitor

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related