mysql - 遍历一组请求数据并将每组保存到数据库 laravel

Question

我有这个 var_dump 结果

'children' => 
    array (size=2)
        0 => string 'children on row 1' (length=17)
        1 => string 'children on row 2' (length=17)
'type_of_delivery' => 
    array (size=2)
        0 => string 'type of delivery on row 1' (length=25)
        1 => string 'type of delivery on row 2' (length=25)
'date' => 
    array (size=2)
        0 => string 'Oct 11, 2015' (length=12)
        1 => string 'Oct 11, 2015' (length=12)

来 self 的输入

<table>
    <thead>
        <tr>
            <th>Children</th>
            <th>Type of Delivery</th>
            <th>Date</th>
        <tr>
    <thead>
    <tbody>
        <tr>
            <td><input type="text" name="children[]" /></td>
            <td><input type="text" name="type_of_delivery[]" /></td>
            <td><input type="text" name="date[]" /></td>
        </tr>
        <tr>
            <td><input type="text" name="children[]" /></td>
            <td><input type="text" name="type_of_delivery[]" /></td>
            <td><input type="text" name="date[]" /></td>
        </tr>
    </tbody>
</table>

我为这些请求数据设置了“children”、“type_of_delivery”、“date”列。我想像每组一样保存它，例如children 数组 0 + type_of_delivery 数组 0 + array 0 date 等等。

假设我已经成功保存了这些数据，它应该是这样的。

--------------------------------------------------------------
     children     |    type of delivery       |  date
--------------------------------------------------------------
children on row 1 | type of delivery on row 1 | Oct 11, 2015
children on row 2 | type of delivery on row 2 | Oct 11, 2015

请问有什么想法、线索、帮助吗？

Answer 1

如果您的数组保持相同的格式，您可以执行以下操作:-

$children = $arr['children'];

for (i=0; i < count($children); i++)
{
    $update = [
        'children' => $children[$i],
        'type_of_delivery' => $arr['type_of_delivery'][$i], 
        'date' => $arr['date'][$i],  
    ];

    Your\Model\To\Insert::create($update);
} 

只有当您在 children、delivery 和 date 上有相同的结果时，这才有效