Welcome Guest, Not a member yet? Register   Sign In
insert_batch() not working completely
#1

I have two array, one with same keys and second array with different different keys. insert_batch function working fine when keys of array is the same, but not working fine when keys are different. Please check below

1. Array with same keys (insert_batch() working fine)


Code:
Array
(

[0] => Array
   (
       [trainer_id] => 2
       [plan_id] => 2
       [week] => week1
       [mon] => {"time":"1:00 AM","item":"a","description":"a"}
       [created_at] => 2017-04-11 13:27:30
       [updated_at] => 2017-04-11 13:27:30
   )

[1] => Array
   (
       [trainer_id] => 2
       [plan_id] => 2
       [week] => week2
       [mon] => {"time":"1:00 AM","item":"b","description":"b"}
       [created_at] => 2017-04-11 13:27:30
       [updated_at] => 2017-04-11 13:27:30
   )

[2] => Array
   (
       [trainer_id] => 2
       [plan_id] => 2
       [week] => week3
       [mon] => {"time":"1:00 AM","item":"c","description":"c"}
       [created_at] => 2017-04-11 13:27:30
       [updated_at] => 2017-04-11 13:27:30
   )

[3] => Array
   (
       [trainer_id] => 2
       [plan_id] => 2
       [week] => week4
       [mon] => {"time":"1:00 AM","item":"d","description":"d"}
       [created_at] => 2017-04-11 13:27:30
       [updated_at] => 2017-04-11 13:27:30
   )
)
   

All keys of inner array are same in above array of array and insert_batch() is working fine for above array.

2. Array with different-different keys(insert_batch() is not working fine)

Code:
Array
(

[0] => Array
   (
       [trainer_id] => 2
       [plan_id] => 2
       [week] => week1
       [mon] => {"time":"1:00 AM","item":"a","description":"a"}
       [created_at] => 2017-04-11 13:17:27
       [updated_at] => 2017-04-11 13:17:27
   )

[1] => Array
   (
       [trainer_id] => 2
       [plan_id] => 2
       [week] => week2
       [tue] => {"time":"1:00 AM","item":"b","description":"b"}
       [created_at] => 2017-04-11 13:17:27
       [updated_at] => 2017-04-11 13:17:27
   )

[2] => Array
   (
       [trainer_id] => 2
       [plan_id] => 2
       [week] => week3
       [wed] => {"time":"1:00 AM","item":"d","description":"d"}
       [created_at] => 2017-04-11 13:17:27
       [updated_at] => 2017-04-11 13:17:27
   )

[3] => Array
   (
       [trainer_id] => 2
       [plan_id] => 2
       [week] => week4
       [thur] => {"time":"1:00 AM","item":"d","description":"d"}
       [created_at] => 2017-04-11 13:17:27
       [updated_at] => 2017-04-11 13:17:27
   )
)


Please check the just above array carefully because some keys are different in this array and insert_batch() is not working for this array.

Error shows like below for second array 

[Image: 4499ee4a-1f6d-11e7-8650-1ac0a6f14a0f.png]

DB TABLE Structure is given below

[Image: fa9448ce-1ed9-11e7-8c4c-fd3f0d74202c.png]


Your quick response to this will be highly appreciated.

Thanks.
Reply


Messages In This Thread
insert_batch() not working completely - by krishnadeveloper - 04-11-2017, 10:22 PM



Theme © iAndrew 2016 - Forum software by © MyBB