Overføre data fra checkbox/radiobutton til DB?? og udtræk i form?
Hej, kan ikke få overført mine values fra checkbox og radiobuttons til databasen?Skal også kunne trække data fra DB ud i en form med hjælp af et søgefelt?
jeg bruger sql og ibacces..
smider lige kode ind:
<?php
ini_set("include_path", "c:/localhost/connect.php");
$title = "Opret CV:";
printf("<head><title>%s</title>\n", $title);
?>
<script type='type/javascript'>
function validerData() {
// ...
// ...
return true
}
</script>
<?php
print("</head>");
print("<body>");
printf("<h1>%s</h1>\n", $title);
?>
<form id="kontakt" action="opretpersoner.php" method="post" onsubmit='return validerData();'>
<table>
<tr>
<td>Navn <span class="obligatorisk">*</span></td>
<td><input type="text" name="navn"/></td>
</tr>
<tr>
<td>By <span class="obligatorisk">*</span></td>
<td><input type="text" name="byen"/></td>
</tr>
<tr>
<td>Postnr. <span class="obligatorisk">*</span></td>
<td><input type="text" name="postnr"/></td>
</tr>
<tr>
<td>Fødselsdato <span class="obligatorisk">*</span></td>
<td><input type="text" name="foedseldato"/></td>
</tr>
<tr>
<td>E-mail <span class="obligatorisk">*</span></td>
<td><input type="text" name="email"/></td>
</tr>
<tr>
<td>Telefonnummer</td>
<td><input type="text" name="telefon"/></td>
</tr>
<tr>
<td>Arbejdsområde:</td>
</tr>
<tr>
<td>
<input type="checkbox" name="arbejdsomraade[]" value="lyd" id="lyd" />
<label for="lyd">Lyd</label for>
</td>
<td>
<input type="radio" name="erfaring[]" id="uerfaren" value="uerfaren" />
<label for="uerfaren">Uerfaren</label for>
</td>
<td>
<input type="radio" name="erfaring[]" id="erfaren" value="erfaren" />
<label for="erfaren">Erfaren </label for>
</td>
</tr>
<tr>
<td>
<input type="checkbox" name="arbejdsomraade[]" value="lys" id="lys" />
<label for="lys">Lys</label for>
</td>
<td> <label for="uerfaren">
<input type="radio" name="erfaring[]" id="radio" value="uerfaren" />
Uerfaren</label for> </td>
<td>
<input type="radio" name="erfaring[]" id="erfaren" value="erfaren" />
<label for="erfaren">Erfaren </label for>
</td>
</tr>
<tr>
<td>
<input type="checkbox" name="arbejdsomraade[]" value="fotograf" id="fotograf" />
<label for="fotograf">Fotograf</label for>
<td>
<input type="radio" name="erfaring3" id="uerfaren" value="uerfaren" />
<label for="uerfaren">Uerfaren</label for>
<td>
<input type="radio" name="erfaring3" id="erfaren" value="erfaren" />
<label for="erfaren">Erfaren </label for>
</td>
</tr>
<tr>
<td>
<input type="checkbox" name="arbejdsomraade[]" value="runner" id="runner" />
<label for="runner">Runner</label for>
<td>
<input type="radio" name="erfaring4" id="uerfaren" value="uerfaren" />
<label for="uerfaren">Uerfaren</label for>
</td>
<td>
<input type="radio" name="erfaring4" id="erfaren" value="erfaren" />
<label for="erfaren">Erfaren</label for>
</td>
</tr>
<tr>
<td>
<input type="checkbox" name="arbejdsomraade[]" value="scenograf" id="scenograf" />
<label for="scenograf">Scenograf</label for>
</td>
<td>
<input type="radio" name="erfaring5" id="uerfaren" value="uerfaren" />
<label for="uerfaren">Uerfaren</label for>
<td>
<input type="radio" name="erfaring5" id="erfaren" value="erfaren" />
<label for="erfaren">Erfaren </label for>
</td>
</tr>
<tr>
<td>
<input type="checkbox" name="arbejdsomraade[]" value="makeup" id="make up / stylist" />
<label for="make up / stylist">Make up / Stylist</label for>
</td>
<td>
<input type="radio" name="erfaring6" id="uerfaren" value="uerfaren" />
<label for="uerfaren">Uerfaren</label for>
</td>
<td>
<input type="radio" name="erfaring6" id="erfaren" value="erfaren" />
<label for="erfaren">Erfaren </label for>
</td>
</tr>
<tr>
<td>
<input type="checkbox" name="arbejdsomraade[]" value="editor" id="editor / klipper" />
<label for="editor / klipper">Editor / klipper</label for>
</td>
<td>
<input type="radio" name="erfaring7" id="uerfaren" value="uerfaren" />
<label for="uerfaren">Uerfaren</label for>
<td>
<input type="radio" name="erfaring7" id="erfaren" value="erfaren" />
<label for="erfaren">Erfaren </label for>
</td>
</tr>
<tr>
<td>
<input type="checkbox" name="arbejdsomraade[]" value="manuskript" id="manuscript / forfatter" />
<label for="manuscript / forfatter">Manuscript / Forfatter</label for>
</td>
<td>
<input type="radio" name="erfaring8" id="uerfaren" value="uerfaren" />
<label for="uerfaren">Uerfaren</label for>
</td>
<td>
<input type="radio" name="erfaring8" id="erfaren" value="erfaren" />
<label for="erfaren">Erfaren </label for>
</td>
</tr>
<tr>
<td>
<input type="checkbox" name="arbejdsomraade[]" value="produktionsassistent" id="produktionsassistent" />
<label for="produktionsassistent">Produktionsassistent</label for>
</td>
<td>
<input type="radio" name="erfaring9" id="uerfaren" value="uerfaren" />
<label for="uerfaren">Uerfaren</label for>
</td>
<td>
<input type="radio" name="erfaring9" id="erfaren" value="erfaren" />
<label for="erfaren">Erfaren </label for>
</td>
</tr>
<tr>
<td>
<input type="checkbox" name="arbejdsomraade[]" value="andet" id="andet" />
<label for="andet">Andet, beskriv nedenfor</label for>
</td>
</tr>
<tr>
<td>Uddannelse/Beskrivelse:</td>
<td colspan="3"><textarea name="beskrivelse" rows="4" cols="50"></textarea></td>
</tr>
<tr>
<td> <input type='hidden' name='funktion' value='ins' /> <input type='submit' name='knap' value='Opret' />
</td>
</tr>
</table>
</form>
<p>
<small>Felter markeret med <span class="obligatorisk">*</span> skal udfyldes.</small>
</p>
</body>
</html>