Hjælp til select box og mysql?
Hej alle sammen, undskyld den lange kode jeg poster nu, men jeg skal skrive det så i kan se koden:<?php
if(isset($_POST['submit'])) {
include 'db.php';
if (isset($_FILES['upfile'])) {
$filetyper = array("image/gif", "text/html", "text/plain", "image/jpeg", "image/pjpeg", "image/png", "application/x-zip-compressed", "application/octet-stream");
if (isset($_FILES['upfile']['name']) && $_FILES['upfile']['name'] == "") {
echo"Ingen fil valgt! <a href=\"#\">tilbage</a>";
} elseif (!in_array($_FILES['upfile']['type'], $filetyper)) {
echo "Ikke tilladt til upload! <a href=\"#.php\">tilbage</a>";
}
if (isset($_FILES['upfile']['name']) && $_FILES['upfile']['name'] !="") {
if(is_uploaded_file($_FILES['upfile']['tmp_name'])) {
$uldir = '../pics/vrag/';
$ulfile = $uldir.basename($_FILES['upfile']['name']);
move_uploaded_file($_FILES['upfile']['tmp_name'], $ulfile);
}
}
}
$model = $_POST['model'];
$regis = $_POST['regis'];
$dore = $_POST['dore'];
$pris = $_POST['pris'];
$upfile = $_POST['upfile'];
$upfile = "xxxx" . $_FILES['upfile']['name'];
mysql_query("INSERT INTO bixen_vrag (model, regis, dore, pris, upfile) VALUES ('$model', '$regis', '$dore', '$pris', '$upfile')") or die(mysql_error());
echo "<div align=\"center\" class=\"tekst_linkThin\">Bilen blev oprettet</div>";
?>
<?php
if(isset($_POST['submit'])) {
include 'db.php';
if (isset($_FILES['upfile'])) {
$filetyper = array("image/gif", "text/html", "text/plain", "image/jpeg", "image/pjpeg", "image/png", "application/x-zip-compressed", "application/octet-stream");
if (isset($_FILES['upfile']['name']) && $_FILES['upfile']['name'] == "") {
echo"Ingen fil valgt! <a href=\"#\">tilbage</a>";
} elseif (!in_array($_FILES['upfile']['type'], $filetyper)) {
echo "Ikke tilladt til upload! <a href=\"#.php\">tilbage</a>";
}
if (isset($_FILES['upfile']['name']) && $_FILES['upfile']['name'] !="") {
if(is_uploaded_file($_FILES['upfile']['tmp_name'])) {
$uldir = '../pics/personbil/';
$ulfile = $uldir.basename($_FILES['upfile']['name']);
move_uploaded_file($_FILES['upfile']['tmp_name'], $ulfile);
}
}
}
$model = $_POST['model'];
$regis = $_POST['regis'];
$dore = $_POST['dore'];
$pris = $_POST['pris'];
$upfile = $_POST['upfile'];
$upfile = "xxxx" . $_FILES['upfile']['name'];
mysql_query("INSERT INTO bixen_personbil (model, regis, dore, pris, upfile) VALUES ('$model', '$regis', '$dore', '$pris', '$upfile')") or die(mysql_error());
echo "<div align=\"center\" class=\"tekst_linkThin\">Bilen blev oprettet</div>";
?>
<?php
if(isset($_POST['submit'])) {
include 'db.php';
if (isset($_FILES['upfile'])) {
$filetyper = array("image/gif", "text/html", "text/plain", "image/jpeg", "image/pjpeg", "image/png", "application/x-zip-compressed", "application/octet-stream");
if (isset($_FILES['upfile']['name']) && $_FILES['upfile']['name'] == "") {
echo"Ingen fil valgt! <a href=\"#\">tilbage</a>";
} elseif (!in_array($_FILES['upfile']['type'], $filetyper)) {
echo "Ikke tilladt til upload! <a href=\"#.php\">tilbage</a>";
}
if (isset($_FILES['upfile']['name']) && $_FILES['upfile']['name'] !="") {
if(is_uploaded_file($_FILES['upfile']['tmp_name'])) {
$uldir = '../pics/lastvogn/';
$ulfile = $uldir.basename($_FILES['upfile']['name']);
move_uploaded_file($_FILES['upfile']['tmp_name'], $ulfile);
}
}
}
$model = $_POST['model'];
$regis = $_POST['regis'];
$dore = $_POST['dore'];
$pris = $_POST['pris'];
$upfile = $_POST['upfile'];
$upfile = "xxx" . $_FILES['upfile']['name'];
mysql_query("INSERT INTO bixen_lastvogn (model, regis, dore, pris, upfile) VALUES ('$model', '$regis', '$dore', '$pris', '$upfile')") or die(mysql_error());
echo "<div align=\"center\" class=\"tekst_linkThin\">Bilen blev oprettet</div>";
?>
<div align="center">
<form action="tilbil.php" method="post" enctype="multipart/form-data">
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<table width="348" height="141" border="0" align="center" cellpadding="0" cellspacing="0" class="tekst_normal">
<tr>
<td width="137"><strong>Opret bil i : </strong></td>
<td width="175"><select size="1" name="koll">
<option value="#" selected>Vælge</option>
<option value="1" >Vrag</option>
<option value="2" >Personbiler</option>
<option value="3" >Last- & Varevogne</option>
</select></td>
</tr>
<tr>
<td><b>Mærke & Model:</b></td>
<td><input name="model" type="text" class="box" id="model" size="16"></td>
</tr>
<tr>
<td><b>Første registrering:</b></td>
<td><input name="regis" type="text" class="box" id="regis" size="16"></td>
</tr>
<tr>
<td><strong>Antal døre :</strong></td>
<td><input name="dore" type="text" class="box" id="msn2" size="4" maxlength="2"></td>
</tr>
<tr>
<td><b>Pris :</b></td>
<td><input name="pris" type="text" class="box" id="pris" size="16"></td>
</tr>
<tr>
<td><strong>Billede :</strong></td>
<td><input name="upfile" type="file" class="box" id="upfile" size="16"></td>
</tr>
</table>
<input name="id" type="hidden" value="<? echo $_GET[id]; ?>">
<input name="submit" type="submit" class="submit" value="Opret bil">
</form>
Det mit problem er, at jeg skal have mit script til at gå ind og tjekke efter hvad for en af tingene jeg har valgt i min select. Alt efter om det er vrag, personbil eller lastvogn så skal den køre en af de bestemte mysql connections jeg har lavet foroven..
Håber i kan hjælpe mig det det, ellers så skriv hvis der er spørgsmål :)
Mvh
