Попытка транспонировать, затем пакетное представление пользовательского представления: «Неизвестный столбец« массив »в« ⇐ Php

[Anonymous]

Я получаю ошибки с помощью codeigniter insert_batch () метод:

Неизвестный столбец «Массив» в «Список поля»
< /blockquote>
и < /p>

массив в преобразование строки < /p>
< /blockquote >

view < /strong> < /p>

Код: Выделить всё

... and so forth.

контроллер [/b]

Код: Выделить всё

public function addstatistics()
{
$i = 0;
foreach ($_POST['companionship_id'] as $companionship_id):
$value1[$i++] = array(
'companionship_id'=>    $companionship_id
);
endforeach;

foreach($_POST['zone_id'] as $zone_id):
$value2[$i++] = array(
'zone_id'=> $zone_id
);
endforeach;

foreach($_POST['district_id'] as $district_id):
$value3[$i++] = array(
'district_id'=> $district_id
);
endforeach;

foreach($_POST['area_id'] as $area_id):
$value4[$i++] = array(
'area_id'=> $area_id
);
endforeach;

foreach($_POST['baptism'] as $baptism):
$value5[$i++] = array(
'baptism'=> $baptism
);
endforeach;

foreach($_POST['confirm'] as $confirm):
$value6[$i++] = array(
'confirm'=> $confirm
);
endforeach;

foreach($_POST['ibd'] as $ibd):
$value7[$i++] = array(
'ibd'=> $ibd
);
endforeach;

foreach($_POST['iasm'] as $iasm):
$value8[$i++] = array(
'iasm'=>$iasm
);
endforeach;

foreach($_POST['ni'] as $ni):
$value9[$i++] = array(
'ni'=>$ni
);
endforeach;

foreach($_POST['ph'] as $ph):
$value10[$i++] = array(
'ph'=>$ph
);
endforeach;

foreach($_POST['wh'] as $wh):
$value11[$i++] = array(
'wh'=>$wh
);
endforeach;

$this->my_model->addstatistics($value1,$value2,$value3,$value4, $value5,$value6,$value7,$value8,$value9,$value10,$value11);
}

model

Код: Выделить всё

addstatistics($value1, $value2, $value3, $value4, $value5, $value6, $value7, $value8, $value9, $value10, $value11)
{
$data = array(
'companionship_id'  => $value1,
'zone_id'           => $value2,
'district_id'       => $value3,
'area_id'           => $value4,
'baptism'           => $value5,
'confirm'           => $value6,
'ibd'               => $value7,
'iasm'              => $value8,
'ni'                => $value9,
'ph'                => $value10,
'wh'                => $value11

);

$row = array();
$columns = array();
for($x=0; $x $value1,
'zone_id'=> $value2,
'district_id'=> $value3,
'area_id'=> $value4,
'baptism'=> $value5,
'confirm'=> $value6,
'ibd'=> $value7,
'iasm'=> $value8,
'ni'=> $value9,
'ph'=> $value10,
'wh'=> $value11,
'year'=> date('Y'),
'month'=> date('M'),
'week' => weekdate(),
'created_by'=> $this->session->userdata('login_id')

);
array_push($columns, $row);
$rows = array();
}
//printA($columns);

$query= $this->db->insert_batch('monthly_statistics', $columns);
}

Как я могу решить эту проблему?

Подробнее здесь: https://stackoverflow.com/questions/487 ... own-column