|
<?php echo '<?xml version="1.0" encoding="UTF-8" ?>' ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Testskjema</title>
<link rel="stylesheet" type="text/css" href="/css/b.css" media="screen" >
</head>
<body>
<form method="post" action="http://servlets.no/php/b1.php">
<span class="tekstAdvarsel">(demo)</span><br \>
<span class="tekstOverskrift">Testskjema (XHML / PHP): SQL-form</span>
<p>
<table border="0" cellspacing="0" cellpadding="2" >
<tr>
<td class="feltLederV">Vare</td>
<td class="feltLederH">Antall</td>
<td></td>
<?php
$db=mysql_connect("db8.registrar.no","servl_2","passord") or die("FEIL: Ikke forbindelse til MySQL");
mysql_select_db("servl_2") or die("FEIL: Ikke forbindelse til database");
if ($_POST["aksjon"] == "Lagre"){
$vare=$_POST["vare"];
$antall=$_POST["antall"];
$query="INSERT INTO Ordrer (Vare,Antall) VALUES ('$vare', $antall)";
$result=mysql_query($query) or die("FEIL: Query1");
}
if ($_POST["aksjon"] == "Slett alle varer"){
$query="DELETE FROM Ordrer";
$result=mysql_query($query) or die("FEIL: Query2");
}
$query="SELECT vare, antall FROM Ordrer";
$result=mysql_query($query) or die("FEIL: Query3");
while ($rad=mysql_fetch_array($result, MYSQL_ASSOC)){
printf ("<tr><td class=feltVerdiV>%s</td><td class=feltVerdiH>%d</td><td></td>", $rad['vare'], $rad['antall'] );
}
mysql_free_result($result);
mysql_close($db);
?>
</td>
<tr>
<td class="feltV"><input type="text" size="20" name="vare" \></td>
<td class="feltH"><input type="text" size="5" name="antall" \></td>
<td class="feltV"><input type="submit" value="Lagre" name="aksjon" \></td>
</table>
</p>
<p>
<input type="submit" value="Slett alle varer" name="aksjon" \>
</p>
<p>
<span class="tekstAdvarsel">(demo)</span>
</p>
</form>
</body>
</html>
|