rendered paste body<?phpif ( isset($_POST['add']) ): /* Lägg till presenten till databasen */ $id = $_POST['maker']; $name = $_POST['name']; $action = "INSERT INTO gift (id, name, maker) VALUES (null, '$name', {$id})"; $DB -> Action($action) or die("Kunde inte lägga till presenten."); ?><?php else: ?><form action="<?php print($_SERVER['PHP_SELF']); ?>?add=gifts" method="post"> <input type="hidden" name="add" value="true" /> <label>Produktnamn</label> <input type="text" name="name" /> <br /><br /> <label>Tillverkare</label> <select name="maker"> <?php /* Vem tillverkade presenten? */ /* Hämta en lista över tillgängliga tillverkare */ $makers_id = $DB -> Query("SELECT id FROM worker"); foreach ( $makers_id as $maker_id ) { $maker = $DB -> Query("SELECT surname, lastname FROM helper WHERE id = " . $maker_id['id']); $surname = $maker[0]['surname']; $lastname = $maker[0]['lastname']; print('<option value="' .$maker_id['id'] . '">' . $surname . " " . $lastname . "</option>"); } ?> </select> <br /><br /> <input type="submit" value="Lägg till" /></form><?php endif; ?>