adding a loop

symoore22

if you visit the link below and add a product to the cart.
http://www.bluetipdvd.co.uk/products.php

i am trying to be able to go back and add more products to the cart so in the end a whole list of products can populate the cart page.

i have tried adding a loop myself but couldnt do it.

thanks

simon
(ive only just started using sessions today so have prob done that wrong also)

heres the code for cart.php:

<?

$qty = $POST['qty'];
$price = $POST['price']; //hidden input
$name = $_POST['name']; //hidden input

$SESSION['qty'] = $qty;
$SESSION['price'] = $price;
$_SESSION['name'] = $name;

?>
<tr>
<td width="29%" valign="top" class="name"><div align="center">QTY </div></td>
<td width="31%" valign="top" class="name"><div align="center">Product
name(s)</div></td>
<td width="40%" valign="top" class="name"><div align="center">Unit Price</div></td>
<td width="40%" valign="top" class="name"> </td>
</tr>
<tr>
<td height="21" valign="top" class="name"><div align="center"><strong><? echo $SESSION['qty']; ?></strong></div></td>
<td valign="top" class="name"><? echo $SESSION['name']; ?> <div align="center"></div>

leatherback

Hey Simon,

Where are you facing the trouble?

You know you need to add session_start();

before any output is started ON EVERY PAGE which is involved in the shopping system, right?

symoore22

ive put this at the top of every page im not if thats right - i was expecting the url to show the session code:

<?php
session_cache_limiter('private');
session_start(); include "vsadmin/db_conn_open.php";
?>

what im trying to do is products to cart.php at the moment you add one product and then the next one you add simply replaces the first one so i thought i needed some sort of a loop.

thanks

simon

LoganK

I don't have code and it's late so I apologize if this isn't that helpful...

That said, you don't need a loop to add multiple items to your shopping cart. Your session variable for your shopping cart should look something like this: $_SESSION['cart'][0] = id_for_product. Basically, everytime a product is added you add a new key=>value pair to the array. For example,

// ex. $id is the ID of the product. This could be from GET, POST, etc.

$_SESSION['cart'][] = $id;

Now you're adding a new key=>value pair to the $_SESSION['cart'] array everytime you add a new product to the cart. This way there is no overwriting. Finally, when the user checks out, you can get all the data about the products with a simple for() loop:

for ($i = 0; $i < count($_SESSION['cart']); $i++)
{
     $id = $_SESSION['cart'][$i];
     $result = mysql_query("SELECT * FROM products WHERE id=$id");
     $row = mysql_fetch_array($result);
}

And now you have $row['productName'], $row['productPrice'], etc., all from the session variable.

I hope you understood this!

symoore22

unfortunately i dont really know what you mean - i am quite new to all of this but am trying to learn - i think i have now got sessions working correctly although i dont know how to tell if i have or not.

I think i will go to the library tomorrow and get a couple of books on php and mysql.

thanks anyway

simon

LoganK

That's a good idea. Reading some books on PHP and MySQL can give you more knowledge than all of us combined here on this forum.