<html>
<head>
<title><--Add Product--></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#f2f2f2" text="#666666" link="#666666" vlink="#666666" alink="#666666" leftmargin="2" topmargin="2" marginwidth="0" marginheight="0">
<?
if (isset($_POST["add"]))
{
$productNr=$_POST["productNr"];
$incMoms=$_POST["incMoms"];
$text = nl2br($_POST["text"]);
$exMoms=$_POST["exMoms"];
$host = "localhost"; //servernavnet
$user = ""; //brugernavnet
$pass = ""; //brugers kodeord
$dbase = "din_database"; //databasenavnet
$link = mysql_connect($host, $user, $pass) OR DIE ("Kunne ikke få forbindelse databasen!"); //opret forbindelse til serveren
mysql_select_db($dbase) or die("Kunne ikke finde databasen"); //vælg den rigtige database
$query = "INSERT INTO vare_katalog (nr, beskrivelse, prisx, prisinc) VALUES('$productNr', '$text', '$exMoms', '$incMoms')";
//echo $query;
mysql_query($query, $link) or die(mysql_error());
}
?>
Läg til produkt.
<form name="update" action="insert_into_veckans.php" method="post">
<table>
<tr>
<td>
Produktnummer:
</td>
<td>
<input type="text" name='productNr' size="20">
</td>
</tr>
<tr>
<td>
Text:
</td>
<td>
<textarea name='text' rows='4' columns='18'></textarea>
</td>
</tr>
<tr>
<td>
Inkl moms:
</td>
<td>
<input type="text" name='incMoms'size="20">
</td>
</tr>
<tr>
<td>
Eksl moms:
</td>
<td>
<input type="text" name='exMoms' size="20">
</td>
</tr>
<tr>
<td>
</td>
<td>
<input type="submit" name="add" value="Send" class="knapp">
</td>
</tr>
</table>
</form>
</body>
</html>
