Creating a Shopping Cart - Please help me find a clean example/tutorial

[jaZon]

Well, I actually have something that I can deal with running now, but it's junky code and I don't like that.

I want something very simple and clean...I mean BASIC BASIC. I don't want to use a database to store the cart, though I want to pull records from the database as the options for what to place in the cart.

What I'm basically trying to do is something to this effect....I want to have 2 html tables....the one on the left being the cart, the one on the right being what can be inserted into the cart. When you click on the item on the right it'll show on the left...and disappear from the table on the right. That make sense? I also want to be able to click the one on the left and have it disappear and reshow on the right. Kind of like trading the item back and forth. I know I'm not explaining this well, but I hope it's decent enough.

What I've got now does everything except take the item out of the right table. I would post it, but I really don't like the coding and would prefer to start from scratch.

So anyway, does anyone have any suggestions on where I could look?

[jaZon]

Here's what I've got - as you can see it's not pretty

And I can't, for the life of me, figure out how to get the items in the right to not show when it's in the left column. The best I can do is get the last item that was selected to not show.

<? 

session_start();

if($new){

if(!session_is_registered("cart")){
	$cart = array();
	session_register("cart");
}

$cart[$new] = 1;

}

?>

<table border=1 width=90%>
	<tr>
		<td valign=top width=50%>
			Selected Tanks
<?

		foreach($_GET as $serial => $qty) { 
			if ($qty == 0){
				unset($cart[$serial]);
			}
		}

		if($cart&&array_count_values($cart)){

			echo("<table border=1 bordercolor=000000><tr><td>serial</td><td>lot</td><td>tank type</td></tr>");

			foreach($cart as $serial => $qty){ 

				$url = "testbed2.php?$serial=0";

				mysql_connect ('host', 'login', 'pwd');
				mysql_select_db ('db');
				$query = "SELECT * FROM hmedical_oxygen WHERE oxygen_status=1 AND oxygen_serial = $serial";

				$result = mysql_query("$query");
				while ($row = mysql_fetch_array($result)){
					echo("<tr><td><a href=$url>$row[oxygen_serial]</a></td><td>$row[oxygen_lot]</td><td>$row[oxygen_tank] - $qty</td></tr>");
				}
			}

			echo("</table>");

		}
		else{
			echo("<BR>No Tanks Selected");
		}
?>
		</td>
		<td valign=top>
			Tank Options
<? 

		mysql_connect ('host', 'login', 'pwd');
		mysql_select_db ('db');
		$query = "SELECT * FROM hmedical_oxygen WHERE oxygen_status=1";

		$result = mysql_query("$query");
		if (!$result)
			return false;
		$num_tanks = mysql_num_rows($result);
		if ($num_tanks == 0)
			return false;
		$res_array = array();

		for ($count=0; $row=@mysql_fetch_array($result); $count++){
			$res_array[$count] = $row;
		}


		if (!is_array($res_array)){
			echo "<BR>No Oxygen Tanks in stock<br>";
			return;
		}
		echo("<table border=1 bordercolor=000000><tr><td>serial</td><td>lot</td><td>tank type</td></tr>");
		foreach ($res_array as $row){
			$url = "testbed2.php?new=".($row["oxygen_serial"]);
			mysql_connect ('host', 'login', 'pwd');
			mysql_select_db ('db');

			$query = "SELECT * FROM hmedical_oxygen WHERE oxygen_status=1 AND oxygen_serial = $row[oxygen_serial]";

			$result = mysql_query("$query");
			while ($row = mysql_fetch_array($result)){
					echo("<tr><td><A href=$url>$row[oxygen_serial]</a></td><td>$row[oxygen_lot]</td><td>$row[oxygen_tank]</td></tr>");
			}
		}

		echo("</table>");

?>
		</td>
	</tr>
</table>

[jaZon]

anyone?:queasy: 😕

[jaZon]

bttt

[cconn]

Not that this is exactly what you're looking for, but why not use HTML/DOC/JavaScript, and allow this to be done on the client side.
Then take the list on the left and post that as needed.
I had done this before (it's been 4-5 years ago), and it was on a completely different project so I no longer have the source for it.
I believe I merely used select controls - using the size attribute to see more entries.
Also, you would of course have to populate the options in the HTML.

[color=blue]<html>
<script type="text/javascript" language="JavaScript">
function handleIt(theMoveFromList, theMoveToList)
{
	var theIndex = theMoveFromList.selectedIndex;
	var theText = theMoveFromList.options[theIndex].text;
	//alert("Item #" + theIndex + " was selected, and the text is " + theText);
	theMoveFromList.remove(theIndex);
	AddItem(theMoveToList, theText)
}
function AddItem(theList, theText)
{
	var newOpt = document.createElement("OPTION");
	newOpt.text=theText;
	// For our purposes, we're not using this
	//newOpt.value="3";
	theList.add(newOpt);
}
</script>

<body>

<form name="input" action="html_form_action.asp" method="get">
<select name="leftList" size="10" onclick="handleIt(input.leftList, input.rightList)">
<option>item2</option>
</select>
<select name="rightList" size="10" onclick="handleIt(input.rightList, input.leftList)">
<option>item1</option>
<option>item3</option>
<option>item4</option>
<option>item5</option>
<option>item6</option>
<option>item7</option>
<option>item8</option>
<option>item9</option>
<option>item10</option>
<option>item11</option>
<option>item12</option>

</select></form> 


</body>
</html>
[/color]

[cconn]

Relative to me not having the code, I simply rewrote it. :p