Need Help with Shopping Cart

RyanMinor · October 4, 2010

Hi everyone,

I am building a shopping cart for a group of friends' website. It is a pay-per-view workout website. Basically, they want to let people find workout videos and pay on a per-day basis (1 day, 3 days, 7 days and depending on the video pricing will be different). I have set them up everything except I am having some difficulty with the shopping cart. I took the basics of the shopping cart script from a tutorial I found online and then modified it. The only problem is that most shopping carts send an action and a product id through the URL and into the session for the shopping cart. Well, I need to also send a price id variable so that the cart will know which price to use. This is because they want to offer pricing on a per-day basis. How would I modify the cart.php page to accomplish this? I have tried, but cannot get the entire thing to work. All help is appreciated. Below is my code:

<?php
// if no session is set, initiate one
if (!isset($_SESSION))
{
session_start();
}

// see if the customer is logged in
//if (!isset($_SESSION['customer_id']))
//{
//header("location:login.php");
//}

// connect to the database
require_once('connect.php');

// select the database
mysql_select_db($database, $connect);

// get the video information
if (isset($_GET['video_id'])) {
$video_id = $_GET['video_id'];
} else {
$video_id = 1;
}
// get the action
if (isset($_GET['action'])) {
$action = $_GET['action'];
} else {
$action = "empty";
}
// get the video pricing information
if (isset($_GET['price_id'])) {
$price_id = $_GET['price_id'];
} else {
$price_id = "";
}

// do the following code based on the action
switch($action) {
// if the action is add then add the product id to the cart session array
case "add":
	if (isset($_SESSION['cart'][$video_id])) {
		$_SESSION['cart'][$video_id]++;
	} else {
		$_SESSION['cart'][$video_id] = 1;
	}
break;
// if the action is remove then remove the product id from the cart session array
case "remove":
	if (isset($_SESSION['cart'][$video_id])) {
		$_SESSION['cart'][$video_id]--;
		if ($_SESSION['cart'][$video_id]==0) {
			unset($_SESSION['cart']);
		}
	}
break;
// if the action is empty then remove the cart session array completely
case "empty":
	unset($_SESSION['cart']);
break;
}
?>
<!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" xml:lang="en" lang="en">

<head>

<meta name="Description" content="Information architecture, Web Design, Web Standards." />
<meta name="Keywords" content="your, keywords" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<link rel="stylesheet" href="layout.css" type="text/css" />

<title>Straight Muscle Videos...Pay-Per-View Alpha Male Muscle Worship Videos</title>


</head>

<body>

<!--wrap starts here-->
<div id="wrap">

<?php include('header.php'); ?>

<?php include('menu.php'); ?>					

<!--content-wrap starts here-->
<div id="content-wrap" class="two-col">	

<?php include('sidebar.php'); ?>

<!--main content starts here-->
<div id="main">

<h1>Shopping Cart</h1>
<br />
<?php if (isset($_SESSION['cart'])) {
$total = 0; ?>
<table width="95%" border="0" cellspacing="0" cellpadding="5">
<?php foreach($_SESSION['cart'] as $video_id => $x) {
	$query = mysql_query("SELECT VideoId, VideoTitle, PriceId, PriceVideoId, PriceAmount, PriceTimeId, TimeId, TimeTitle, TimeLength FROM Video, Price, Time WHERE VideoId = $video_id AND PriceId = $price_id AND PriceVideoId = $video_id AND PriceTimeId = TimeId", $connect);
	$row = mysql_fetch_array($query);
	$video_name = $row['VideoTitle'];
	$order_length = $row['TimeTitle'];
	$video_price = $row['PriceAmount'];
	$line_cost = $video_price * $x;
	$total_cost = $total + $line_cost;
?>

<tr>
<td align="left" valign="middle"><?php echo $video_name; ?></td>
<td align="center" valign="middle"><?php echo $order_length; ?></td>
<td align="center" valign="middle"><?php echo "$".$line_cost; ?></td>
<td align="center" valign="middle"><a href="cart.php?action=remove&video_id=<?php echo $video_id; ?>&price_id=<?php echo $price_id; ?>">Remove</a></td>
</tr>
<?php } ?>
<tr>
<td colspan="4" bgcolor="#666666"><span class="shopping_cart">Purchase Total: $<?php echo $total_cost; ?></span></td>
</tr>
</table>
<div align="center">
<form id="shopping_cart" method="post" action="confirm.php">
<input type="submit" name="place_order" id="place_order" value="Place Order" />
</form>
</div>
<div align="center">  
  <p><a href="search.php">Continue Shopping</a></p>
  <p><a href="cart.php?action=empty">Empty Cart</a></p>
</div>
<?php } 
else
{
echo "<br /><br /><div align='center'>There are no items in your cart.</div>";
} ?>

<!--main content ends here-->
</div>
<!--content-wrap ends here-->	
</div>

<?php include('footer.php'); ?>	

<!--wrap ends here-->
</div>

</body>
</html>

Sign In

Need Help with Shopping Cart

Recommended Posts

RyanMinor

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information