Member Avatar for dreaogse
dreaogse 0 Newbie Poster

I have been searching for days looking for a good way to solve my code problem.

I have a PHP page that is dynamically creating a form with textboxes and checkboxes. The textbox has a quantity to order of an item and the checkbox is add item to order.
The user is to check the boxes of items he/she wants to order and then press the "Add to shopping cart" button below.

Problem 1: I can't use the Value field because it's set with formatted data for the chopping cart server (off site service).
Possible solution is to build an array with the data and/or feed the data direct from variables available via PHP server, but how.

What I need is for the "Subtotal" to update every time the user changes a checkbox and/or quantity in the textbox.

I am, as usual, VERY new to Javascript and also new but learning PHP. The PHP side is working wonderfully and I have currently a bit of code that is updating the checkbox side that I found on another web page:
http://www.dynamicsitesolutions.com/javascript/using-checkboxes-to-update-total/
But, again, it only updates the total with the change to the checkbox and I need something that will update with a change to both.

I have included the .js code and the PHP page in this post

Thanks

/* 
*  Copyright 2006 Dynamic Site Solutions.
*  Free use of this script is permitted for commercial and non-commercial 
*  applications, subject to the requirement that this comment block be kept 
*  and not be altered.  The data and executable parts of the script may be 
*  changed as needed.  Dynamic Site Solutions makes no warranty regarding 
*  fitness of use or correct function of the script.  If you would like help
*  customizing this script or if you have other questions, contact 
*  "contact_us@dynamicsitesolutions.com".
*
*  Script by: Dynamic Site Solutions -- http://www.dynamicsitesolutions.com/
*  Last Updated: 2007-06-12
*/
// Safari 1.0 to 1.2
var isOldSafari=(navigator.userAgent.search(/Safari\/(85|1\d\d)\D/i)!=-1);

function dss_addEvent(el,etype,fn) {
  var tN = el.tagName?el.tagName.toLowerCase():'';
  if(el.addEventListener && (!window.opera || opera.version) &&
  (etype!='load') &&(!isOldSafari || ((tN!='input') && (tN!='textarea')))) {
    el.addEventListener(etype,fn,false);
  } else if(el.attachEvent) {
    el.attachEvent('on'+etype,fn);
  } else {
    var tempFunc;
    if(typeof el['on'+etype] == "function") tempFunc=el['on'+etype];
    el['on'+etype] = function() {
      if(typeof tempFunc == "function") tempFunc();
      if(typeof fn == "function") fn();
    }
  }
}

if(typeof(Number)!='undefined'&&typeof(Number.prototype)!='undefined'){
  if(typeof(Number.prototype.toFixed)=='undefined'){
  // for IE versions older than 5.5 and Netscape 4.x
  // for this script it's only used in IE5.x, though because of the DOM1 
  // support requirement
    Number.prototype.toFixed=function(d){
      var n=this;
      d=(d||((d==0)&&(typeof(d)=='number')))?d:2;
      var f=Math.pow(10,d);
      n=((Math.round(n*f)/f)+Math.pow(10,-(d+1)))+'';
      return n.substring(0,(d==0)?n.indexOf('.'):n.indexOf('.')+d+1);
    }
  }
}

function updateTotal() {
  if(!document.getElementsByTagName || !document.createTextNode) return;
  var cbs = document.getElementById('checkout').getElementsByTagName('input');
  var total = 0,num;
  for(var i=0;i<cbs.length;i++) {
    if(cbs[i].checked) {
      num=parseFloat(checkboxItemValue[cbs[i].id]);
      if(!isNaN(num)) total += num;
    }
  }
  var b = document.getElementById('checkoutTotal');
  while(b.firstChild) b.removeChild(b.firstChild); // removes children of "b"
  b.appendChild(document.createTextNode('Subtotal: $ '+total.toFixed(2)));
}

function addEventsTocheckout() {
  if(!document.getElementsByTagName || !document.createTextNode) return;
  var cbs = document.getElementById('checkout').getElementsByTagName('input');
  for(var i=0;i<cbs.length;i++) {
    dss_addEvent(cbs[i],'click',updateTotal);
  }
}

// IE5+/Win, Firefox, Netscape 6+, Opera 7+, Safari, IE5/Mac, iCab 3

dss_addEvent(window,'load',addEventsTocheckout);
dss_addEvent(window,'load',updateTotal);
<?php

$pricetb = "part"; // parts & pricing detail database table name
$veh = $_POST['vehicle']; // data key number in main.dbf for vehicle type detail
$year = (string)$_POST['year'];
$fflag = $_POST['front']; // data flag for front tie down - used in part.dbf
$front = "front$fflag"; // convert front data code (see db details)
$rflag = $_POST['rear']; // data flag for rear tie down - used in part.dbf
$rear = "rear$rflag"; // convert rear data code (see db details)
$turnb = (string)$_POST['turnb']; // turnbuckle choice passed from first page choice
if ($turnb == "b") $tbstag = (string)"92-2234"; // assign springload xl - only single color available
if ($turnb == "c") $tbstag = (string)"92-1912"; // assign basic springload - only single color available
$dbf = "c:\\inetpub\\wwwroot\\parts\\rv-hitches\\torklift"; // dbase tables location
global $conn;
$cb = (string)"";
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("DRIVER={Microsoft dBase Driver (*.DBF)}; DBQ=$dbf");
if (!$veh) header('Location:../camper-tie-downs.htm');
// This section pulls down the main vehicle data
$sqlm="SELECT * FROM main WHERE key=$veh;";
$rs = $conn->Execute($sqlm);
$key=$rs->Fields("key");
// load fresh data from the db file
$make = (string)$rs->Fields("make");
$model = (string)$rs->Fields("model");
$cab = (string)$rs->Fields("cab");
$drive = (string)$rs->Fields("drive");
$bed = (string)$rs->Fields("bed");
$frontpn = (string)$rs->Fields($front);
$backpn = (string)$rs->Fields($rear);
// This section pulls down the part number information details
// Front tiedown data
if ($frontpn != "A0000") // make sure that part is available for the truck
	{
		$sqlf = "SELECT * FROM part WHERE mp='$frontpn' and flag='$fflag'";
		$fd = $conn->Execute($sqlf);
		$fstag=$fd->Fields("sp");
		$fholes=$fd->Fields("h");
		$fna= $fd->Fields("notea");
		$fnb= $fd->Fields("noteb");
		$fnc= $fd->Fields("notec");
		if ($fna)
			{
				$sqln = "SELECT * FROM inotes WHERE nmbr=$fna";
				$rn = $conn->Execute($sqln);
				$fnta = "<font color='#FF0000'>\n".(string)$rn->Fields("note").".</font>\n";
			}
		if ($fnb)
			{
				$sqln = "SELECT * FROM inotes WHERE nmbr=$fnb";
				$rn = $conn->Execute($sqln);
				$fntb = "<font color='#FF0000'>\n".(string)$rn->Fields("note").".</font>\n";
			}
		if ($fnc)
			{
				$sqln = "SELECT * FROM inotes WHERE nmbr=$fnc";
				$rn = $conn->Execute($sqln);
				$fntc = "<font color='#FF0000'>\n".(string)$rn->Fields("note").".</font>\n";
			}
	}
else
	{
		$fstag = "N/A"; // flag it unavailable
	}
//rear tiedown data
if ($backpn != "A0000")  // make sure that part is available for the truck
	{
		$rna = "0";
		$rnb = "0";
		$rnc = "0";
		$sqlr = "SELECT * FROM part WHERE mp='$backpn' and flag='$rflag'";
		$rd = $conn->Execute($sqlr);
		$rstag = $rd->Fields("sp");
		$rholes = $rd->Fields("h");
		$rna = $rd->Fields("notea");
		$rnb = $rd->Fields("noteb");
		$rnc = $rd->Fields("notec");
		if ($rna)
			{
				$sqln="SELECT * FROM inotes WHERE nmbr=$rna";
				$rn = $conn->Execute($sqln);
				$rnta = "<font color='#FF0000'>\n".(string)$rn->Fields("note").".</font>\n";
			}
		if ($rnb)
			{
				
				$sqln="SELECT * FROM inotes WHERE nmbr=$rnb";
				$rn = $conn->Execute($sqln);
				$rntb = "<font color='#FF0000'>\n".(string)$rn->Fields("note").".</font>\n";
			}
		if ($rnc)
			{
				$sqln="SELECT * FROM inotes WHERE nmbr=$rnc";
				$rn = $conn->Execute($sqln);
				$rntc = "<font color='#FF0000'>\n".(string)$rn->Fields("note").".</font>\n";
			}
	}
else
	{
		$rstag = "N/A"; // flag it unavailable
	}
// This section pulls the price detail data from the parts.dbf database
if ($frontpn != "A0000") // front details
	{
		$fs="";
		$fpsql = "SELECT * FROM part WHERE SP='$fstag'";
		$rp = $conn->Execute($fpsql);
		$fps = $rp->Fields("STOCKED"); // is item discontinued 'X'
		$fpd = (string)$rp->Fields("LONG_DESC"); // web description field
		$fpr = number_format(($rp->Fields("I_RETAIL")),2); // sale price 
		$fpn = number_format(($rp->Fields("RETAIL")),2); // normal price
		$fpw = (string)$rp->Fields("S_WHT"); // shipping weight
		if ($fpn > ($fpr * 1.05)) $fs=1; // flag as being on sale
		if ($fps == "X") 
			{
				$frontpn = "A0000";
				$fstag = "N/A";
			}
 	}
if ($backpn != "A0000") // rear details
	{
		$rs="";
		$rpsql = "SELECT * FROM part WHERE SP='$rstag'";
		$rp = $conn->Execute($rpsql);
		$rps = $rp->Fields("STOCKED"); // is item discontinued 'X'
		$rpd = (string)$rp->Fields("LONG_DESC"); // web description field
		$rpr = number_format(($rp->Fields("I_RETAIL")),2); // sale price
		$rpn = number_format(($rp->Fields("RETAIL")),2); // normal price
		$rpw = (string)$rp->Fields("S_WHT"); // shipping weight
		if ($rpn > ($rpr * 1.05)) $rs=1; // flag as being on sale
		if ($rps == "X")
			{
				$backpn = "A0000";
				$rstag = "N/A";
			}
	}
if ($rnc == 14 and $backpn = "D3102")  // Dually adapter addon
	{
		$ds="";
		$dstag = "92-1933"; // stag number for A7004 adapter for Dodge Dually pickups
		$df = 1; // flag for Dodge dually pickups
		$dsql = "SELECT * FROM part WHERE SP='$dstag'";
		$rp = $conn->Execute($dsql);
		$dps = $rp->Fields("STOCKED"); // is item discontinued 'X'
		$dpd = (string)$rp->Fields("LONG_DESC"); // web description field
		$dpr = number_format(($rp->Fields("I_RETAIL")),2); // sale price
		$dpn = number_format(($rp->Fields("RETAIL")),2); // normal price
		$dpw = (string)$rp->Fields("S_WHT"); // shipping weight
		if ($dpn > ($dpr * 1.05)) $ds=1; // flag as being on sale
	}
else // clear all flags and variables for dually
	{
		$df = "";
		$dps = "";
		$dpd = "";
		$dpr = "";
		$dpn = "";
		$dpw = "";
	}


// format text info for vehicle type display
if ($drive == 2 or $drive == 4) // for handling 2 & 4 wheel drive notices
	{
		$drivetxt = $drive." wheel drive";
	}
if ($bed == "ALL") // for handling non-lenth bed sizes
		{
			$bedtxt = " ";
		}
elseif ($bed == "N/A")
		{
			$bedtxt = " ";
		}
elseif ($bed == "8")
		{
			$bedtxt = "with an ".$bed." foot bed";
		}
else
		{
			$bedtxt = "with a ".$bed." foot bed";
		}
if ($cab == "CAB & CHASSIS") // cab Selections
	{
		$cabtxt = "Cab & Chassis Only";
	}
elseif ($drive == NULL)
	{
		$cabtxt = " ";
	}
else
	{
		$cabtxt = $cab;
	}
	
// header info for web page
echo "<html>\n<head>\n";

include('../../../includes/headsection');
echo "<title>Camper Tie Downs - Page 3</title>\n";
echo "<link rel='stylesheet' type='text/css' href='/parts.css' />\n";
echo "<script type=\"text/javascript\" src=\"/js/torklift.js\"></script>";
echo "\n";
echo "</head>\n";
// include('../../../includes/bodysection'); // <--- the onload command in this include prevents the total script to not work.
echo "<body>";
include('../rv-hitches-bc.htm');
echo "<blockquote>\n";

// Begin Checkout section -->

echo "<hr />\n<h3>For your ".$drivetxt." '".substr($year,2)." ".$make." ".$model." ".$cabtxt." ".$bedtxt.":</h3>\n";

// begining of form for cartserver -->
echo "<form action=\"http://www.cartserver.com/sc/cart.cgi\" method=POST id=\"checkout\" onSubmit=\"javascript:pageTracker._linkByPost(this)\"  >\n";

//  Start front tie down display
if ($frontpn != "A0000" and $fps != "X") 
	{
		$id="front";
		$cb = (string)"'$id':'$fpr',\n";
		echo "<table width='800' border='1' rules=none bgcolor='#FFFFCC'>\n"; // open table
		echo "<tr><td width='625'><font face='verdana' size='+1'>Front Tie Down Kit Part #: <font color='#333399'>\n".$fstag."</font> - only <font color='#333399'>$".$fpr."</font></font></td>\n"; // main part display
		echo "<td><strong>Qty: </strong><input type='TEXT' name='op1_front' value='1' size='2' /></td>\n"; // qty
		echo "<td valign='middle'><strong>Select: </strong><input type='checkbox' checked='checked' value='s-1234^".$fstag."^".$fpd."^".$fpr."^op1^^^^".$fpw."' name='item_front' id='".$id."'/></td>\n"; // check box
		echo "</tr>\n"; // terminate row
		if ($fs) echo "<tr><td width='625'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Regularly $".$fpn." <font color='#FF0000'><strong>On Sale for Only $".$fpr."</strong></font></td></tr>\n"; // Part Sale
		
		if ($fholes or $fna) // are there any install notes
			{
				echo "<tr><td><font face='verdana' size='3'><strong>Install notes for front tie down kit:</strong></font>\n";
				if ($fholes) echo "<li><font color='#333399'>Installation requires the drilling of ".$fholes." holes.</font></li>\n";
				if ($fna) // print install notes for rear tie downs
					{
						echo "<li>\n".$fnta."</li>\n";
						if ($fnb) echo "<li>\n".$fntb."</li>\n";
						if ($fnc) echo "<li>\n".$fntc."</li>\n";
						echo "</td></tr>\n";
					}
			}
		else
			{
					if (!$fholes) echo "<tr><td><strong>Install notes for front tie down kit:</strong><li>No holes need to be drilled.</li></td></tr>\n";
			}
	echo "</table>\n";
	}	
else
	{
		echo "<table width='800' border='1' rules=none bgcolor='#FFFFCC'><tr><td><font face='verdana' size='+1'>Front Tie Down Kit Part #: <font color='#333399'>\n".$fstag." </font></font>\n";
		echo " (This tie down may be a special order item. Call us at ";
		Include ('../../../includes/800number');
		echo ")</td></table>\n";
	}


// Start rear tie down display
if ($backpn != "A0000" and $rps != "X") 
	{
		$id = "rear";
		$cb = (string)($cb . "'$id':'$rpr',\n");
		echo "<table width='800' border='1' rules=none bgcolor='#FFFFCC'>\n"; // open table
		echo "<tr><td width='625'><font face='verdana' size='+1'>Rear Tie Down Kit Part #: <font color='#333399'>\n".$rstag."</font> - only <font color='#333399'>$".$rpr."</font></font></td>\n"; // main part display
		echo "<td><strong>Qty: </strong><input type='TEXT' name='op2_rear' value='1' size='2' /></td>\n"; // qty
		echo "<td valign='middle'><strong>Select: </strong><input type='checkbox' checked='checked' value='s-1234^".$rstag."^".$rpd."^".$rpr."^op2^^^^".$rpw."' name='item_rear' id='".$id."' /></td></tr>\n"; // check box

		if ($rs) echo "<tr><td width='625'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Regularly $".$rpn." <font color='#FF0000'><strong>On Sale for Only $".$rpr."</st
  • 1 Contributor
  • 0 Replies
  • 61 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.