Indkøbs faktura liste!
Jeg er igang med at lave en indkøbs / faktura liste til min hjemmeside men har et problem med at få det lavet så jeg kan lege med flere produkter af gangen! håber i kan hjæpe!index.php- --------------------------------------------------
<?
session_start();
include("func.php");
DB::Conn("open");
?>
<!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>Untitled Document</title>
<style type="text/css">
<!--
.style1 {color: #FF0000}
.style2 {
font-size: 36px;
font-weight: bold;
font-style: italic;
}
-->
</style>
</head>
<body>
<center>
<form action="faktura.php" method="post">
<?
$SQL = "SELECT * FROM vareliste ORDER BY `id` DESC";
$loadin = mysql_query($SQL) or die("There is an Error in the database");
while ($Get = mysql_fetch_object($loadin)){
?>
<table width="800px" style="border:2px black solid;" bgcolor="#CCCCCC" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="center" colspan="4" style="border-bottom:1px black solid;">
<span class="style2">Indkøbs Liste </span></td>
</tr>
<tr>
<td width="675px" align="left" style="border-right:1px black solid;border-bottom:1px black solid;">
Navn.
</td>
<td width="25px" align="center" style="border-right:1px black solid;border-bottom:1px black solid;">
Nr.
</td>
<td width="75px" align="center" style="border-bottom:1px black solid;">
Pris
</td>
<td align="right" width="25px" style="border-bottom:1px black solid;">
</td>
</tr><!-- oversigt -->
<tr>
<td align="left" style="border-right:1px black solid;border-bottom:1px black dotted;">
<input onmouseover="show('images.JPG')" name="navn" value="<?=nl2br($Get->navn)?>" type="text" style="width:670px;border:0px black solid;background-color:#CCCCCC;">
</td>
<td align="center" style="border-right:1px black solid;border-bottom:1px black dotted;">
<input name="nr" value="<?=nl2br($Get->katalog_nr)?>" type="text" style="width:20px;border:0px black solid;background-color:#CCCCCC;">
</td>
<td align="center" style="border-bottom:1px black dotted;">
<input name="pris" value="<?=nl2br($Get->umoms)?>" type="hidden">
<input name="mmoms" value="<?=nl2br($Get->mmoms)?>" type="text" style="width:35px;border:0px black solid;background-color:#CCCCCC;"> kr
</td>
<td align="right">
<input name="antal" type="text" style="width:25px;" maxlength="2" />
</td>
</tr>
<tr>
<td colspan="4" align="center" style="border-top:1px black solid;">
<input type="submit" name="submit" value="Næste >" />
</td>
</tr>
</table>
<? }?>
</form>
</center>
</body>
</html>
Faktura.php -------------------------------------------------
<?
session_start();
include("func.php");
DB::Conn("open");
?>
<!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>Untitled Document</title>
<style type="text/css">
<!--
.style3 {font-family: Verdana, Arial, Helvetica, sans-serif}
.style5 {font-size: 24px}
-->
</style>
</head>
<body>
<center>
<div class="style3" style="width:700px;border:1px black solid;">
<p align="right"><span class="style5"><strong>Kvittering/Faktura</strong></strong></span></p>
<table border="0" style="border:1px gray solid;" cellspacing="0" cellpadding="0">
<tr>
<td width="385" valign="top" style="border-right:1px gray solid;"> Kunde:</td>
<td width="302" valign="top">Fakturabeløbet er/bedes betalt til:
<p> </p>
<p> </p>
<p> </p>
<p> </p></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p>
<strong>Dato:</strong> <? echo date("d-m-Y");?><br>
<strong>Faktura#:</strong> 1 <br>
<strong>Periode:</strong> <? echo date("F");?></p>
<table border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="223" valign="top" bgcolor="#CCCCCC"><strong>Produkt</strong></td>
<td width="164" valign="top" bgcolor="#CCCCCC"><strong>Antal</strong></td>
<td width="164" valign="top" bgcolor="#CCCCCC"><strong>Pris ialt DKK</strong></td>
</tr>
<tr>
<td width="223" valign="top"><? echo $_POST['navn'] ?></td>
<td width="164" valign="top"><? echo $_POST['antal'] ?></td>
<td width="164" valign="top"><? echo $_POST['pris'] ?></td>
</tr>
<tr>
<td width="223" valign="top" bgcolor="#CCCCCC"><p><strong>Pris eksl. Moms</strong></p></td>
<td width="164" valign="top" bgcolor="#CCCCCC"><p><strong> </strong></p></td>
<?
$antal = $_POST['antal'];
$pris = $_POST['pris'];
$total = $antal * $pris;
?>
<td width="164" valign="top" bgcolor="#CCCCCC"><p align="right"><strong><? echo $total ?></strong></p></td>
</tr>
<tr>
<td width="223" valign="top" bgcolor="#CCCCCC"><p><strong>Moms 25% </strong></p></td>
<td width="164" valign="top" bgcolor="#CCCCCC"><p><strong> </strong></p></td>
<? $moms = $total / "4"?>
<td width="164" valign="top" bgcolor="#CCCCCC"><p align="right"><strong><? echo $moms ?></strong></p></td>
</tr>
<tr>
<td width="223" valign="top" bgcolor="#CCCCCC"><p><strong>Pris ialt </strong></p></td>
<td width="164" valign="top" bgcolor="#CCCCCC"><p><strong> </strong></p></td>
<td width="164" valign="top" bgcolor="#CCCCCC"><p align="right"><strong><? echo $moms + $total ?></strong></p></td>
</tr>
</table>
<p>Krukke-Huset v/Yvonne Schjøtt Hansen, Håndværkervænget 4B, Tved, 5700 Svendborg - tlf. 6222 1212 - cvr. nr. 25 63 94 80</p>
</div>
</center>
</body>
</html>
