将多条记录插入数据库

我有一个表单，允许用户将多个数据插入数据库。我一直试图插入它们，但没有成功。

以下是表格

<tr>
<td>
    <select title = "Please choose" name="menutype[]">
        <option value="-1" >--Select--</option>
            <?php
            $query = "SELECT * FROM MenuType";
            $result = $mysqli->query($query);
            if  ($result==false) {
                    die( mysqli_error($mysqli));
            }
            while ($menutype = mysqli_fetch_array($result)) {
                ?>
                <option value="<?php echo $menutype['MenuTypeID'] ?>"><?php echo $menutype['MenuTypeName'] ?></option>
                <?php 
            }
            ?>
</select>
</td>
<td><input type="text" name="name[]" /></td>
<td><input type="file" name="picture[]" /></td>
<td><textarea rows="4" cols="40" name="description[]"></textarea></td>
<td><input type="text" name="price[]" value=""/></td>
<td>
    <select title="Please choose" name="status[]">
        <option value="-1" />--Select--</option>
        <option value="Available" />Available</option>
        <option value="Limited" />Limited</option>
    </select>
</td>
</tr>

下面是php代码

$name = $_POST['name'];
$description = $_POST['description'];
$price = $_POST['price'];
$status = $_POST['status'];
$menutypeid = $_POST['menutype'];
if(isset($_FILES['picture'])){
$name_array = $_FILES['picture']['name'];
$tmp_name_array = $_FILES['picture']['name'];
for($i = 0; $i < count($tmp_name_array); $i++){
    if(move_uploaded_file($tmp_name_array[$i], "images/menu/".$name_array[$i])){
        echo $name_array[$i]." upload is complete<br>";
    } else {
        echo "move_uploaded_file function failed for ".$name_array[$i]. "<br>";
    }
}
$imageup = $tmp_name_array; // save the whole url address of the uploaded file into variable
foreach ($name as $value){
$query = "INSERT INTO menu (MenuID, MenuName,  MenuPicture, MenuDescription, MenuPrice, MenuStatus, MenuTypeID) 
                VALUES ('', '$name', '$imageup', '$description', '$price', '$status', '$menutypeid' )";
    $mysqli->query($query) or die(mysqli_error($mysqli));
    //header('Location:view_menu_for_manager.php');}}
?>

我在上传多个文件/图像时也遇到了问题。帮助

编辑查询

foreach ($name as $value){
$query = "INSERT INTO menu (MenuName,  MenuPicture, MenuDescription, MenuPrice, MenuStatus, MenuTypeID) 
                VALUES ('$name', '$imageup', '$description', '$price', '$status', '$menutypeid' )";