Inserting Session Array values

tubs11

Hi,

does anyone know a way of looping through a Session array and then inserting all the data stored into a database. The code below only inserts the last key & value found.


foreach ($_SESSION['cart'] as $key => $value) {


$test = " INSERT INTO cartcontents (cartcontents_id, product_id, quantity)
	   values ('" . $_SESSION['cart']. "', '" . $key . "' , '" . $qty . "')";



} //end of foereach loop

Many thanks,

j_70

You can reference the entire session array with just $_SESSION. Also, you have specified:

as $key => $value

but in your insert statement you reference $qty.

Try:

foreach ($_SESSION as $key => $value) {


$test = " INSERT INTO cartcontents (cartcontents_id, product_id, quantity)
       values ('" . $_SESSION['cart']. "', '" . $key . "' , '" . $qty . "')";



} //end of foereach loop

What value are you hoping to pull with $_SESSION['cart']? This references a session variable, not the entire session.

tubs11

Thanks for the reply,

Sorry, $qty should be $value (it was a late night!)

If I print the values to the screen then it works (see below) ok but when I insert to the database only the last key & value are stored.

print_r Array ( [cart] => Array ( [25] => 1 [26] => 1 ) )

Thanks for the idea but it returned only one key & value again and they were both set to 0 instead of 25 & 1 or 26 & 1

I'm trying to pull a product_id ($sid) number that is passed to the session using a url hyperlink.

j_70

Could you post your full code. Your problem is probably that you are not executing your insert statement for each iteration.

tubs11

Here's the code,


$query = 'SELECT product_id, description, price FROM products WHERE product_id IN (';


foreach ($_SESSION['cart'] as $key => $value) {

print "$key = $value\n";


$test = " INSERT INTO cartcontents (cartcontents_id, product_id, quantity)
	   values ('" . $_SESSION['cart']. "', '" . $key . "' , '" . $value . "')";

}

$query = substr ($query, 0,-1) .')';


echo mysql_error(); //check for sql error
$result = mysql_query($query) or die(mysql_error());

j_70

Why are you attempting to insert in your subquery?

tubs11

The cartcontents table will be used to capture the customers order which will then allow me to view a list of orders on the admin side of the site.

dalecosp

Isn't $_SESSION['cart'] an array as well? This code will only insert the word "Array" into the 'cartcontents_id' field of the 'cartcontents' table, and since that's most likely a key field, it would overwrite all the previous entries....