how to insert multiple array to database using codeigniter

Question

I have posted values $a,$b,$c...are in array format model file i gave this.

 function insert_bank_data($da,$b,$c,$d,$e)
    {

        $data=array('date'=>$da,'des'=>$b,'amount'=>$c,'price'=>$d);
        $this->db->insert_batch('total_trans',$data);


}

I am getting an error like this.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22' at line 1

yes. these are arrays.when i print_r($a)..i got '30-Dec-2015','30-Dec-2015','29-Dec-2015','28-Dec-2015','................................... — manju
– manju, Commented Dec 31, 2015 at 9:32

Ann · Accepted Answer · 2015-12-31 09:43:19Z

1

You can use json_encode()

function insert_bank_data($da,$b,$c,$d,$e)
{

    $data=array('date'=>json_encode($da),'des'=>json_encode($b),'amount'=>json_encode($c),'price'=>json_encode($d));
    $this->db->insert_batch('total_trans',$data);

}

answered Dec 31, 2015 at 9:43

Ann

4711 gold badge9 silver badges23 bronze badges

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

Comments

splash58 · Accepted Answer · 2015-12-31 09:35:41Z

0

if arguments of the function are arrays of the same length you should write

function insert_bank_data($da,$b,$c,$d,$e)
{
  $data = array();
  for ($i-0; $i < count($da); $i++) {
    $data[] = array('date'=>$da[$i],'des'=>$b[$i],'amount'=>$c[$i],'price'=>$d[$i]);
  $this->db->insert_batch('total_trans',$data);
}

answered Dec 31, 2015 at 9:35

splash58

26.2k3 gold badges25 silver badges35 bronze badges

Comments

Arvind Jaiswal · Accepted Answer · 2015-12-31 10:31:54Z

0

You can use this also...

function insert_bank_data($da,$b,$c,$d,$e)
{

    for ($i=0; $i < count($da); $i++) {
        $data= array('date'=>$da[$i],'des'=>$b[$i],'amount'=>$c[$i],'price'=>$d[$i]);
        $this->db->insert('total_trans',$data);
    }
}

answered Dec 31, 2015 at 10:31

Arvind Jaiswal

4425 silver badges14 bronze badges

Collectives™ on Stack Overflow

how to insert multiple array to database using codeigniter

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related