<?php
if($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['editmenu'])){
    $count = count($_POST['id']);
    for($i=0;$i<$count;$i++){
        $error = '';
        if(empty($_POST['id']) OR empty($_POST['name']) OR empty($_POST['path'])){
            $error = '<font style="color: red;"><b><p>Er zijn lege velden aangetroffen.</p></b></font>';
        }
        else{
            mysql_query("UPDATE et_menu_". mysql_real_escape_string($_GET['lang']) ."
                            SET
                                name = '". mysql_real_escape_string($_POST['name'][$i]) ."',
                                path = '". mysql_real_escape_string($_POST['path'][$i]) ."'
                            WHERE id = '". mysql_real_escape_string($_POST['id'][$i]) ."'
                        ")or die(mysql_error());
            $error = '<p><b><font style="color: green;">Het menu is aangepast.</font></b></p>';
        }
    }
}
if(!empty($error)){
    echo $error;
}
?>
<p>Alle menu's / items staan hier.</p>
<form method="post" action="">
    <table>
        <tr>
            <td>Naam</td>
            <td>Link</td>
        </tr>
    <?php
        $query = mysql_query("SELECT * FROM et_menu_". mysql_real_escape_string($_GET['lang']) ." ORDER BY id ASC");
        while($row = mysql_fetch_assoc($query)){
            echo'
                <tr>
                    <td><input type="text" name="name[]" value="'. $row['name'] .'" /></td>
                    <td><input type="text" name="path[]" value="'. $row['path'] .'" /></td>
                </tr>
                ';
        }
    ?>
    <tr>
        <td colspan="2"><input type="submit" name="editmenu" value="Bewerk menu" /></td>
    </tr>
    </table>
</form>