Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(isset($_GET['id']))
- {
- if(isset($_GET['actie']))
- {
- if($_GET['actie'] == "mod")
- {
- //Connectie met database
- $con = mysqli_connect("localhost", "root", "", "drankendb");
- //Opbouwen query
- $query = "SELECT * FROM drank WHERE id = ".$_GET['id'];
- //Uitvoeren query
- $result = mysqli_query($con, $query);
- //Resultaat van de query opslaan in $rij
- $rij = mysqli_fetch_object($result);
- ?>
- <form method="POST">
- <table>
- <tr>
- <th>Dranknaam:</th>
- <td><input type="text" name="txtNaam" value="<?php echo $rij->naam; ?>"/></td>
- </tr>
- <tr>
- <th>Soort:</th>
- <td>
- <SELECT name="selSoort">
- <?php
- if($rij->soort == "bier") echo "<OPTION value='Bier' SELECTED>Bier</OPTION>";
- else "<OPTION value='Bier'>Bier</OPTION>";
- if($rij->soort == "Wijn") echo "<OPTION value='Wijn' SELECTED>Wijn</OPTION>";
- else "<OPTION value='Wijn'>Wijn</OPTION>";
- if($rij->soort == "Frisdrank") echo "<OPTION value='Frisdrank' SELECTED>Frisdrank</OPTION>";
- else "<OPTION value='Frisdrank'>Frisdrank</OPTION>";
- if($rij->soort == "Whiskey") echo "<OPTION value='Whiskey' SELECTED>Whiskey</OPTION>";
- else "<OPTION value='Whiskey'>Whiskey</OPTION>";
- ?>
- </SELECT>
- </td>
- </tr>
- <tr>
- <th>Aantal:</th>
- <td>
- <SELECT name ="selAantal">
- <?php
- for($i = 1; $i <= 20; $i++)
- {
- echo "<OPTION value='$i'>$i</OPTION>";
- }
- ?>
- </SELECT>
- </td>
- </tr>
- <tr>
- <th></th>
- <td><input type="submit" name="btnVerstuur" value="Verzend"/>
- </td>
- </tr>
- </table>
- <?php
- }
- }
- }
- if(isset($_POST['btnVerstuur']))
- {
- $naam = $_POST['txtNaam'];
- $soort = $_POST['selSoort'];
- $aantal = $_POST['selAantal'];
- $id = $_GET['id'];
- $query = "UPDATE drank SET naam = '$naam', soort = '$soort', aantal = $aantal WHERE id = $id";
- $con = mysqli_connect("localhost", "root", "", "drankendb");
- $isGelukt = mysqli_query($con, $query);
- if($isGelukt) Header("Location: Drank.php");
- else echo "update mislukt";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement