[SOLVED] SESSION VALUES INTO MYSQL

[serbestgezer]

Hi There,

I am trying to get session cart values into order_items table

<?php 
$cart = $_SESSION[cart];
$a = array($cart);
//echo $cart;

foreach($a as $data)
{
echo $data; // 1,1,1,1
//$sql = mysql_query("insert into order_items (code) VALUES ('$data')")  or die(mysql_error());
}
?>

 

I dont know what i am doing wrong. it enters the data like 1,1,1,1 doesnt repeats the insert

 

I want it like that

 

order_items table

id      code

1        1

2        1

3        1

4        1

 

 

How can I get the session values and insert them into database?

[trq]

foreach($_SESSION['cart'] as $data)

[serbestgezer]

I tried it before and got error message

 

Warning: Invalid argument supplied for foreach()

[trq]

What is the output of....

 

print_r($_SESSION['cart']);

[redarrow]

session's dont work without session_start()

[redarrow]

look at this example please of session's

<?php session_start();

$data=array(1,1,1,1);

foreach($data as $data_info){

$_SESSION['cart']=$data_info;

echo $_SESSION['cart'];
}?>

[serbestgezer]

 

 

print_r($_SESSION['cart']);

 

output  1,1,1,1,1

[serbestgezer]

session's dont work without session_start()

 

I know mate. I do use session_start

[trq]

<?php 
  $cart = implode(',', $_SESSION[cart]);
  foreach($cart as $data) {
    mysql_query("insert into order_items (code) VALUES ('$data')")  or die(mysql_error());
  }
?>

[serbestgezer]

I changed the code as below.

 

$cart = $_SESSION['cart'];
$items = explode(',',$cart);
$contents = array();
foreach ($items as $item => $value) {
print_r($contents[$value]);
	}

 

doesnt print anything but if I use print_r($contents[$value] . "test ");  it prints //test test test test  I dont get the session value ????

[redarrow]

thorpe, is there any reason there no session_start() on the top of your example....

 

 

is it not needed in this example off work?

 

 

things change so quickly maybe session_start() not needed after all

[serbestgezer]

ok here we go.

<?php
session_start(); // for redarrow
$cart = explode(',', $_SESSION[cart]);
  foreach($cart as $data) {
    mysql_query("insert into order_items (code) VALUES ('$data')")  or die(mysql_error());
  }
?>

 

thanks guys

[serbestgezer]

redarrow, I do use session_start(). i didnt post it the whole script. its just part of it.

[redarrow]

So cart was a string $cart="1,1,1,1"; <<< you never said that?

[serbestgezer]

no cart is not a string. it was ex. from my shopping cart output.

[redarrow]

according to your code if it goes like this.

 

then the $cart << was a string no matter where it come from....

 

<?php session_start();
$_SESSION['cart']="1,1,1,1"; 
$cart = explode(',', $_SESSION['cart']);
foreach($cart as $data) {
echo $data;
}
?>

 

result.

1111

[serbestgezer]

you added it.

 

$_SESSION['cart']="1,1,1,1";

 

not me.

[trq]

print_r indicated you indeed had a string, not an array.

[serbestgezer]

i see, my print_r shows as Array[0] =>1[1]=>1

i think, what I was thinking and what I wrote was bit different

 

Thanks

Thorpe