Shopping Cart Sessions - Think this is a simple prolem - hopefully
| From: | Boa Constructor | Date: | Thu, 14 Nov 2002 00:23:46 +0000 |
| Subject: | Shopping Cart Sessions - Think this is a simple prolem - hopefully | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23318@lists.php.net to get a copy of this message | ||
Evening all, I'm pretty stumped with this basic shopping cart I'm trying to integrate into
my site, if u wanna see what I'm on about visit http://www.hostmaster-x.co.uk/Products.php.
On my products script I've got the following:
<?php
$shoppingcart = array();
session_start();
session_register('shoppingcart');
if($buy != "")
{
$shoppingcart[] = $buy;
//header("Location: $PHP_SELF");
/*
echo "<B>Cart contains: <?=count($shoppingcart)?>
items</B><BR><BR><BR>";
*/
//exit();
}
// Loads more code here ( code that works )
Of course I need a link so that I can buy a product, so I've got the following in a loop:
echo "<a href=$PHP_SELF?buy=$i>Buy</a><BR>";
The link works fine for each product, the problem is that the ID of the product doesn't seem to
be stored in the session and I get a whole pile of mysql errors which don't appear in the same
page when products are displayed. The errors highlight the following code:
while($ProductDetails = mysql_fetch_array($Q))
{
$ProductID = $ProductDetails["ID"];
$ProductName = $ProductDetails["ProductName"];
$SellingPrice = $ProductDetails["SellingPrice"];
$ProductPicture = $ProductDetails["PictureOfProduct"];
$AmountInStock = $ProductDetails["AmountInStock"];
$Description = $ProductDetails["ProductDescription"];
$PictureOfProduct = $ProductDetails["PictureOfProduct"];
}
if(mysql_num_rows($Q) > 0)
Anyone got any ideas? I'm a bit lost as to why this doesn't work.
G :)
Public Sub House()
On Error Resume drink
If Pint.empty = True Then
Pint.refill
Else
Pint.drink
End if
stomach.add Pint
MsgBox " I've had .... " & stomach.count & " Pints"
MsgBox "VERY DRUNK"
End Sub