Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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>
Add Comment
Please, Sign In to add comment