使用' foreach '从数组插入多个项目到数据库


Inserting several items from array to database with `foreach`

我想从一个数组插入几个项目到数据库与foreach。我得到一个错误Message: Undefined offset。谁能告诉我是什么引起的吗?

错误:

A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 0
Line Number: 127
A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 0
Line Number: 128
A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 0
Line Number: 129
php:

<?php
$guide_input = $this->input->post('guide');
$airline_input = $this->input->post('airline');
$name_r_input = $this->input->post('name_r');
$units_input = $this->input->post('units');
$price_change_input = $this->input->post('price_change');
$guide = array();
$airline = array();
$date_go = array();
$date_back = array();
$residence = array();
foreach ($guide_input as $idx => $name) {
    $guide[] = array(
        'name_guide' => $guide_input[$idx], //Line Number: 121
    );
    $airline[] = array(
        'name_airline' => $airline_input[$idx], //Line Number: 124
    );
    $residence[] = array(
        'name_r' => $name_r_input[$idx], //Line Number: 127
        'units' => $units_input[$idx], //Line Number: 128
        'price_change' => $price_change_input[$idx], //Line Number: 128
    );
};
$data = array(
    'json1' => json_encode($residence),
    'json2' => json_encode($airline),
    'json3' => json_encode($guide),
);
$this->db->insert(tableName, $data);

上面的代码假设所有的输入数组,如$airline_input, $date_go_input等等。将具有与$guide_input相同数量的元素。我猜他们不会。

为了使代码正确无误地运行,您应该检查:

count($guide_input) == count($airline_input)
&& count($guide_input) == count($date_go_input)
// ... and so on... //

我认为您应该检查guide_input, airline_input等。每个数组都有相同的键?