<?php
require("mysql_connect.php");
//include("beveiliging.php");
date_default_timezone_set("Europe/Amsterdam");
if(isset( $_POST['submit']))
{
 foreach($_POST['prijs'] as $key => $value)
 {
    $query = "update `opdrachten` set `prijs` = '".$value."'";
    echo $key." | ".$value."<br />";
 }
}

$query = "select * from `opdrachten` order by `datum_oplevering`";

$result = mysqli_query($db_connection,$query);
echo "  <form action='index.php?content=opdrachten' method='post'>
        <table>
        <th>
            Opdracht Nummer:
        </th>
            <th>
            Klant Nummer:
        </th>
            <th>
            Omschrijving
        </th>
            <th>
            Kleur
        </th>
            <th>
            Aantal Foto's
        </th>
            <th>
            Maat
        </th>
            <th>
            Datum Oplevering
        </th>
        <th>
            Datum Plaatsing
        </th>
            <th>
            Prijs
        </th>;
                    <th>
            Bevestigt
        </th>
        <th>
            Betaald
        </th>";
        while ($row = mysqli_fetch_array($result))
        {
            echo "<tr>
                    <td>".$row['id']."</td>
                    <td>".$row['user_id']."</td>
                    <td>".$row['omschrijven_opdracht']."</td>
                    <td>".$row['kleur']."</td>
                    <td>".$row['aantal_fotos']."</td>
                    <td>".$row['maten']."</td>
                    <td>".$row['datum_oplevering']."</td>
                    <td>";
                        $date = new DateTime($row["datum_plaatsing"]);

                    echo $date->format("d-m-Y")."</td>
                    <td><input type='text' name='prijs' /></td>
                    <td>".$row['bevestigd']."</td>
                    <td>".$row['betaald']."</td>
                 </tr>

                ";
        }
?>
<input type='submit' name='submit' value='Wijzigen' />
</from>