Spara data i excelfil — sida 2

22 svar · 3 162 visningar · startad av Pelletsteknik 22 okt. 2010 · sida 2 av 2

PelletsteknikMedlem sedan feb. 200844 inlägg

30 okt. 2010 19:53#21

order_postforskott.php


Här är filen med formulären.

#order_postforskott.php
<?php
// required variables
require("config.php");
 ?>

<html>

<head>

<title><?php echo $company_name ?> - Orderformul&auml;r</title>

<link rel="stylesheet" HREF="master_style.css">
<style type="text/css">
<!--
body {
scrollbar-face-color: #ffffff;
scrollbar-highlight-color: #ffffff;
scrollbar-shadow-color: #ffffff;
scrollbar-3dlight-color: #cccccc;
scrollbar-arrow-color: #000000;
scrollbar-track-color: #ffffff;
scrollbar-darkshadow-color: #cccccc;
}
-->
</style>
</head>

<BODY TEXT="#000000" BGCOLOR="#FFFFFF" LINK="#660101" VLINK="#660101" ALINK="#F70404">

<form onClick="Form_Validator(this)" onSubmit="return form_validator(this)" action="order_postforskott_final.php" method="post">

<SCRIPT language="JavaScript"><!-- //script hider
function form_validator(f) {
	var error="";
	if(f.fname.value=="") {
		error="Förnamn\n";
		setBorder(f.fname,1);
	} else {
		setBorder(f.fname,0);
	}
	if(f.lname.value=="") {
		error=error+"Efternamn\n";
		setBorder(f.lname,1);	
	} else {
		setBorder(f.lname,0);
	}
	if(f.street.value=="") {
		error=error+"Adress\n";
		setBorder(f.street,1);
	} else {
		setBorder(f.street,0);
	}
	if(f.postno.value=="") {
		error=error+"Postnummer\n";
		setBorder(f.postno,1);
	} else {
		setBorder(f.postno,0);
	}
	if(f.city.value=="") {
		error=error+"Postort\n";
		setBorder(f.city,1);
	} else {
		setBorder(f.city,0);
	}
	if(f.telno.value=="") {
		error=error+"Telefon\n";
		setBorder(f.telno,1);
	} else {
		setBorder(f.telno,0);
	}
	if(f.email.value=="") {
		error=error+"E-post adress\n";
		setBorder(f.email,1);
	} else {
		setBorder(f.email,0);
	}
	
	if(error) {
	alert('Nedanstående fält måste vara ifyllda \nför att du ska kunna skicka din order:\n\n'+error+"\n");
	return false;
	} else {
	return true;
	}
	
}

function setBorder(t,b) {
	if(b) {
		t.style.borderColor='#ce0000';
		t.style.borderStyle='solid';
		t.style.borderWidth='1px';
	} else {
		t.style.borderColor='';
		t.style.borderStyle='';
		t.style.borderWidth='';
	} 
}
// end script hiding --></SCRIPT>

<script LANGUAGE="JavaScript">

	function alterError(value) {
		if (value<=0.99) {
			newDollars = '0';
		} else {
			newDollars = parseInt(value);
		}
		newCent = parseInt((value+.0008 - newDollars)* 100);
		if (eval(newCent) <= 9) newCent='0'+newCent;
		newString = newDollars + '.' + newCent;
		return (newString);
	}

	// showItems in orderform

	function showItems() {
		index = document.cookie.indexOf("TheBasket");
		countbegin = (document.cookie.indexOf("=", index) + 1);
        	countend = document.cookie.indexOf(";", index);
        	if (countend == -1) {
            		countend = document.cookie.length;
        	}
		fulllist = document.cookie.substring(countbegin, countend);
		subtotal = 0;
		subweight = 0;
		document.writeln('<table cellpadding="2" cellspacing="1" border="0">');

		document.writeln('<TR><TD BGCOLOR="#E9AF03"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b><?php echo $txt_qty ?></b></FONT></TD><TD  BGCOLOR="#E9AF03"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b><?php echo $txt_code_no ?></b></FONT></TD><TD BGCOLOR="#E9AF03"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b><?php echo $txt_item ?></b></FONT></TD><TD BGCOLOR="#E9AF03"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b><?php echo $txt_price ?></b></FONT></TD><td BGCOLOR="#E9AF03"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b><?php echo $txt_sub_total ?></b></FONT></td></TR>');
		itemlist = 0;
		for (var i = 0; i <= fulllist.length; i++) {
			if (fulllist.substring(i,i+1) == '[') {
				thisitem = 1;
				itemstart = i+1;
			} else if (fulllist.substring(i,i+1) == ']') {
				itemend = i;
				thequantity = fulllist.substring(itemstart, itemend);
				itemtotal = 0;
				itemtotal = (eval(theprice*thequantity));
				temptotal = itemtotal * 100;
				subtotal = subtotal + itemtotal;
				weighttotal = 0;
				weighttotal = (eval(theweight*thequantity));
				subweight = subweight + weighttotal;
				itemlist=itemlist+1;
	
document.write('<tr><td align=middle BGCOLOR="#fffff6"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">'+thequantity+'</FONT></td>');
				document.writeln('<td BGCOLOR="#fffff6"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><a href=item_show.php?code_no='+thenumber+'>'+thenumber+'</A></FONT></td><td align=left BGCOLOR="#fffff6"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><a href=item_show.php?code_no='+thenumber+'>'+theitem+'</A></FONT></td><td align=right BGCOLOR="#fffff6"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">'+theprice+'</FONT></td><td align=right BGCOLOR="#fffff6"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">'+alterError(itemtotal)+'</FONT></td></tr>');
		  
                                document.writeln('<INPUT TYPE="hidden" NAME="quantity'+itemlist+'" VALUE="'+thequantity+'st" SIZE="40">');
			     document.writeln('<INPUT TYPE="hidden" NAME="item'+itemlist+'" VALUE=" '+theitem+'" SIZE="80">');
                                document.writeln('<INPUT TYPE="hidden" NAME="price'+itemlist+'" VALUE=" '+theprice+'" SIZE="40">');
                                document.writeln('<INPUT TYPE="hidden" NAME="totalcost'+itemlist+'" VALUE=" '+alterError(itemtotal)+'" SIZE="40">');
                                document.writeln('<INPUT TYPE="hidden" NAME="number'+itemlist+'" VALUE=" '+thenumber+'" SIZE="40">');
			} else if (fulllist.substring(i,i+1) == '|') {
				if (thisitem==1) theitem = fulllist.substring(itemstart, i);
				if (thisitem==2) theprice = fulllist.substring(itemstart, i);
				if (thisitem==3) thenumber = fulllist.substring(itemstart, i);
				if (thisitem==4) theweight = fulllist.substring(itemstart, i);
				thisitem++;
				itemstart=i+1;
			}
		}

	totprice = (Math.round(subtotal*100)/100);

// Fraktkostnad för postpaket enligt postens tabeller

		if(subweight<0.01)   {
		shipping=<?php echo $freight_postforskott ?>;
			}
		if(subweight>0.01)   {
		shipping=6.00+<?php echo $freight_postforskott ?>;
			}
		if(subweight>0.02)   {
		shipping=12.00+<?php echo $freight_postforskott ?>;
			}
		if(subweight>0.10)   {
		shipping=24.00+<?php echo $freight_postforskott ?>;
			}
		if(subweight>0.25)   {
		shipping=36.00+<?php echo $freight_postforskott ?>;
			}
		if(subweight>0.50)   {
		shipping=48.00+<?php echo $freight_postforskott ?>;
			}	
		if(subweight>1.00)   {
		shipping=72.00+<?php echo $freight_postforskott ?>;
			}
		if(subweight>2.00)   {
		shipping=150.00+<?php echo $freight_postforskott ?>;
			}
		if(subweight>3)   {
		shipping=175.00+<?php echo $freight_postforskott ?>;
			}
		if(subweight>5)   {
		shipping=225.00+<?php echo $freight_postforskott ?>;
			}
		if(subweight>10)   {
		shipping=275.00+<?php echo $freight_postforskott ?>;
			}
		if(subweight>15)   {
		shipping=320.00+<?php echo $freight_postforskott ?>;
			}

		totalcost = (totprice+shipping);
            	tax = (Math.round(totalcost*<?php echo $add_tax ?>)/100);

		document.writeln('<tr><td align=right BGCOLOR="#fffff6" colspan=4><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b>Totalt</b></FONT></td><td align=right BGCOLOR="#fffff6"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">'+alterError(totprice)+'</FONT></td></tr>');

		document.writeln('<tr><td align=right BGCOLOR="#fffff6" colspan=4><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b>Exp.avgift+Frakt</b></FONT></td><td align=right BGCOLOR="#fffff6"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">'+alterError(shipping)+'</FONT></td></tr>');

<?php
if( $add_tax  >"0") {
echo ("document.writeln('<tr><td align=right BGCOLOR=\"#fffff6\" colspan=4><font size=\"-2\" face=\"Verdana, Arial, Helvetica, sans-serif\"><b>Moms</b></FONT></td><td align=right BGCOLOR=\"#fffff6\"><font size=\"-2\" face=\"Verdana, Arial, Helvetica, sans-serif\">'+alterError(tax)+'</FONT></td></tr>');") ;
}
?>

		document.writeln('<tr><td align=right BGCOLOR="#fffff6" colspan=4><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b>Att betala (inkl. moms) <?php echo $txt_currency ?></b></FONT></td><td align=right BGCOLOR="#fffff6"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">'+alterError(totalcost+tax)+'</FONT></td></tr>');

  		document.writeln('<INPUT TYPE="hidden" NAME="totprice" VALUE="'+alterError(totprice)+'" SIZE="40">');
  		document.writeln('<INPUT TYPE="hidden" NAME="total" VALUE="'+alterError(totalcost+tax)+'" SIZE="40">');
  		document.writeln('<INPUT TYPE="hidden" NAME="tax" VALUE="'+alterError(tax)+'" SIZE="40">');
  		document.writeln('<INPUT TYPE="hidden" NAME="shipping" VALUE="'+alterError(shipping*0.8)+'" SIZE="40">');

		document.writeln('</TABLE>');

	}

</script>
<center><font size="5" face="Verdana, Arial, Helvetica, sans-serif"><b><?php echo $txt_order_form ?></B></FONT></center>
<center><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><b>Betalning via postf&ouml;rskott</B></FONT></center>
<HR WIDTH=90% size=1 COLOR="#000000">
<CENTER>
<script LANGUAGE="JavaScript">
	showItems();
</script></CENTER>
<BR>
<BR>

<CENTER><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=2>
<tr BGCOLOR="#E9AF03">
<td colspan=2 bgcolor="#E9AF03"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><B>Kunduppgifter</B></FONT></td>
</tr>
<tr BGCOLOR="#FFFFF6">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Kund Nr</FONT></td>
<td><input type=text name="kundnr" size=35 class="field_orderform"></td></tr>
<tr BGCOLOR="#fffff6">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">F&ouml;retag</FONT></td>
<td><input type=text name="foretag" size=35 class="field_orderform"></td></tr>
<tr BGCOLOR="#fffff6">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">F&ouml;rnamn *</FONT></td>
<td><input type=text name="fname" size=35 class="field_orderform"></td></tr>
<tr BGCOLOR="#fffff6">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Efternamn *</FONT></td>
<td><input type=text name="lname" size=35 class="field_orderform"></td></tr>
<tr BGCOLOR="#fffff6">
<td ><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Adress *</FONT></td>
<td><input type=text name="street" size=35 class="field_orderform"></td></tr>
<tr BGCOLOR="#fffff6">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Postnummer *</FONT></td>
<td><input type=text name="postno" size=35 class="field_orderform"></td></tr>
<tr BGCOLOR="#fffff6">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Postort *</FONT></td>
<td><input type=text name="city" size=35 class="field_orderform"></td></tr>

<tr BGCOLOR="#FFFFF6">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Land *</FONT></td>
<td>
<SELECT name="Country" class="field_orderform">
		<option value="Sverige" selected>Sverige</option>
</select>
</td></tr>
<tr BGCOLOR="#fffff6">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Telefon *</FONT></td>
<td><input type=text name="telno" size=25 class="field_orderform"></td></tr>
<tr BGCOLOR="#fffff6">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Mobiltelefon</FONT></td>
<td><input type=text name="cellno" size=25 class="field_orderform"></td></tr>
<tr BGCOLOR="#fffff6">
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">E-post *</FONT></td>
<td><input type=text name="email" size=35 class="field_orderform"></td></tr>
<tr BGCOLOR="#fffff6">
<td valign=top><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Meddelande</FONT></td>
<td><TEXTAREA NAME="meddelande"  ROWS=4 COLS=37 WRAP=Physical class="field_orderform"></TEXTAREA></td></tr>
</table>

<table>
<tr><td>
<font size="2" face="Verdana, Arial, Helvetica, sans-serif">( * betyder att uppgiften &auml;r obligatorisk! )</FONT>
</td></tr>

<TR>

<TD ALIGN=center COLSPAN=2>
<INPUT TYPE=submit  NAME=Submit VALUE="Skicka order" class="button">
</TD>
</TR>
</TABLE>
<P>
<P>
</CENTER>
</FORM>

</BODY>
</HTML>

PelletsteknikMedlem sedan feb. 200844 inlägg

10 nov. 2010 16:49#22


Nu funkar det, jag anropar en funktion och fixar till strängen, sedan kollar jag om kunden redan finns.

$foretag = ucname($foretag);
$fname = ucname($fname);
$lname = ucname($lname);
$street = ucname($street);
$fname = ucname($fname);
$city = ucname($city);

$postno = trim($postno);
$telno = trim($telno);
$cellno = trim($cellno);
$email = trim(strtolower($email));

// skriver information till den angivna tabellen

$oldkund = "SELECT * FROM Kunder WHERE fname ='$fname' AND lname ='$lname' AND postno ='$postno' ";
$result = mysql_query($oldkund); 

$user_exist = mysql_num_rows($result);

if ($user_exist > 0) { 
      $repeatcustomer = ", och tack för att du har handlat i v&aring;r butik igen";

   } 
      else { 

$nykund = mysql_query("INSERT INTO Kunder (kundnr, foretag, fname, lname, street, postno, city, telno, cellno, email) 
VALUES('$kundnr','$foretag','$fname','$lname','$street','$postno','$city','$telno','$cellno','$email')");

}

PelletsteknikMedlem sedan feb. 200844 inlägg

10 nov. 2010 16:49#23


Nu funkar det, jag anropar en funktion och fixar till strängen, sedan kollar jag om kunden redan finns. :)

$foretag = ucname($foretag);
$fname = ucname($fname);
$lname = ucname($lname);
$street = ucname($street);
$fname = ucname($fname);
$city = ucname($city);

$postno = trim($postno);
$telno = trim($telno);
$cellno = trim($cellno);
$email = trim(strtolower($email));

// skriver information till den angivna tabellen

$oldkund = "SELECT * FROM Kunder WHERE fname ='$fname' AND lname ='$lname' AND postno ='$postno' ";
$result = mysql_query($oldkund); 

$user_exist = mysql_num_rows($result);

if ($user_exist > 0) { 
      $repeatcustomer = ", och tack för att du har handlat i v&aring;r butik igen";

   } 
      else { 

$nykund = mysql_query("INSERT INTO Kunder (kundnr, foretag, fname, lname, street, postno, city, telno, cellno, email) 
VALUES('$kundnr','$foretag','$fname','$lname','$street','$postno','$city','$telno','$cellno','$email')");

}