php - 将数组值插入到php中的单个数组中

Question

我需要将数组值插入到数组中。但是我的代码仅适用于单个值而不是数组。需要使用多个选择框动态添加值。可能吗？

 <select id="dates-field2" class="multiselect-ui form-control" name="RepairType[]" multiple="multiple"> </select>



    $ProductId=$_REQUEST["ProductId"];
    $Qty=$_REQUEST["Qty"];
    $ProdSrlNo=$_REQUEST["ProdSrlNo"];
    $Purpose=$_REQUEST["Purpose"];
    $RepairType=implode(",", $_REQUEST["RepairType"]);
    $Status='Act';          

    $items = array();

    $size = count($ProductId);

    for($i = 0 ; $i < $size ; $i++){
        // Check for part id
        $items[] = array(
            "ProductId"    => $ProductId[$i],
            "Qty"       => $Qty[$i],
            "ProdSrlNo"     => $ProdSrlNo[$i], 
            "Purpose"    => $Purpose[$i],
             "RepairType"       => $RepairType[$i],
             "Status"       => $Status,
        );
    }

    if (!empty($items)) {
        $values = array();
        foreach($items as $item){
            $values[] = "( '{$item['ProductId']}', '{$item['Qty']}', '{$item['ProdSrlNo']}', '{$item['Purpose']}', '{$item['RepairType']}', '{$item['Status']}')";
        }
        $values = implode(", ", $values);
        $sql = "INSERT INTO `product` (`ProductId`,  `Qty`, `ProdSrlNo`, `Purpose`, `RepairType`, `Status`) VALUES  {$values} ";
    }

标签： phpmysqlarrays