Jag håller på och fixar ett litet formulär, och vill kunna spara detta i en databas hur gör man ?
Jag har googlat lite men förstår inte riktigt hur man gör så hoppas på hjälp av er.
Mitt formulär ser ut som följande:
Kod: Markera allt
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Solar Disclaim</title>
</head>
<body>
<?php
function validate_form(){
if (empty($_POST['datum'])) {
$errors[] = 'Du måste fylla i ett datum.';
}
if (empty($_POST['ordernr'])) {
$errors[] = 'Du måste fylla i ett ordernummer.';
}
if (empty($_POST['transp'])) {
$errors[] = 'Du måste fylla i en transpotör.';
}
}
// Om man klickat på spara-knappen
if (isset($_POST['submit'])) {
validate_form();
}
?>
<form enctype="multipart/form-data" method="post" action="inmatning.php">
<table width="413" border="0">
<tr>
<td width="162" height="43">Datum *
<br />
<input type="text" name="datum" />
<br /></td>
<td width="160">Ordernummer*
<input type="text" name="ordernr" /> </td>
<td width="77">Ordertyp*<br />
<select name="lista" id="lista">
<option>D</option>
<option>I</option>
<option>R</option>
</select></td>
</tr>
</table>
<br />
<table width="400" border="0">
<tr>
<td width="161" height="43">Transpotör*<br />
<input type="text" name="transp" />
<br />
<br /></td>
<td width="229">Chaufför*<br />
<input type="text" name="chauff" /></td>
</tr>
</table>
<p>
<label></label>Kund *<br />
<label>
<input name="kund" type="text" accesskey="50" size="50" />
</label>
</p>
<p>Lev. Adress *<br />
<label>
<textarea name="levadr" cols="50" rows="3"></textarea>
</label>
</p>
<table width="304" border="0">
<tr>
<td width="203"><label>
Antal vitta kollin
<input name="kolli1" type="text" id="kolli1" size="5" />
</label></td>
<td width="91"> <label>
<select name="rull1">
<option>Saknas</option>
<option>Skadat</option>
<option>Övrigt</option>
</select>
</label></td>
</tr>
<tr>
<td><label>Antal gröna kollin
<input name="kolli2" type="text" id="kolli2" size="5" />
</label></td>
<td><label>
<select name="rull2">
<option>Saknas</option>
<option>Skadat</option>
<option>Övrigt</option>
</select>
</label></td>
</tr>
</table>
<p>Notering / Åtgärd:<br />
<label>
<textarea name="notering" cols="50" rows="4"></textarea>
</label>
</p>
<p>Rapport* </p>
<table width="400" border="0">
<tr>
<td width="125"><input type="checkbox" name="checkbox" value="checkbox" id="checkbox" />
Telefon</td>
<td width="265"><input type="text" name="textfield" id="textfield" /></td>
</tr>
<tr>
<td><input type="checkbox" name="checkbox2" value="checkbox" id="checkbox2" />
Fax </td>
<td><input type="text" name="textfield2" id="label" /></td>
</tr>
<tr>
<td><input type="checkbox" name="checkbox3" value="checkbox" id="checkbox3" />
E-mail </td>
<td><input name="textfield3" type="text" id="label2" size="40" /></td>
</tr>
<tr>
<td><input type="checkbox" name="checkbox4" value="checkbox" id="checkbox4" />
Filial</td>
<td><input name="textfield4" type="text" id="label3" size="40" /></td>
</tr>
</table>
<p>
<label></label>
Anteckningar:<br />
<label>
<textarea name="anteck" cols="50" rows="8"></textarea>
</label>
</p>
<p><input type="hidden" name="MAX_FILE_SIZE" value="800000" />
Bild: <input name="file" type="file" />
</p>
<p>
<label>
<input name="submit" type="submit" id="Spara" value="Spara" />
</label>
<label>
<input type="reset" name="Reset" value="Ta bort" />
</label>
</p>
<p> </p>
</form>
</body>
</html>
Kod: Markera allt
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Solar Disclaim</title>
</head>
<body>
<?php
echo "Datum: " . $_POST['datum'] . "<br>";
echo "Transpotör: " . $_POST['transp'] . "<br>";
echo "Ordernummer: " . $_POST['ordernr'] . "<br>";
echo "Lista: " . $_POST['lista'] . "<br>";
echo "Chaufför: " . $_POST['chauff'] . "<br>";
echo "Kund: " . $_POST['kund'] . "<br>";
echo "Leveransadress: " . $_POST['levadr'] . "<br>";
echo "Totalt antal avvikelser " . $_POST['kolli'] . "<br>";
echo "Antal vita kollin: " . $_POST['kolli1'] . " " . $_POST['rull1'] . "<br>";
echo "Antal gröna kollin: " . $_POST['kolli2'] . " " . $_POST['rull2'] . "<br>";
echo "Notering: " . $_POST['notering'] . "<br>";
echo "Rapport: " . $_POST['rull3'] . " " . $_POST['rapport'] . "<br>";
echo "Anteckningar " . $_POST['anteck'] . "<br>";
$path= "uploads/".$HTTP_POST_FILES['file']['name'];
if($file !=none)
{
if(copy($HTTP_POST_FILES['file']['tmp_name'], $path))
{
echo "Bilden har laddats upp.<BR/>";
echo "<img src=\"$path\" width=\"600\" height=\"800\">";
}
else
{
echo "Fel vid uppladdning!";
}
}
?>
</body>
</html>
