arrays in sessions help

benracer

hi,
i have id's of products stored in a session that is created when the customer clicks add to cart... it does it like this

<? session_start();

if ( !isset( $_SESSION["cart"] ) ) { 
    $_SESSION["cart"] = array(); 
} 

$id = $_POST["id"]; 
$_SESSION["cart"][$id] = $id; 

header("location:index.php"); 

?>

when they click confirm order this is the code that i want to write the carts id to the database called orders.

<?php
session_start();

$rs = mysql_connect( "********" );
$rs = mysql_select_db( "*****" );

$cart = $_SESSION['cart'];

$sql = "INSERT INTO orders (items) VALUES ('$cart')";
$rs = mysql_query( $sql ) or die('Query:<br />' . $sql . '<br /><br />Error:<br />' . mysql_error());


header("location:pay.php");

?>

this just stores the word Array.

any reason for this

many thanks
regards
ben😕

NogDog

It does not just store the word "Array". It stores an array, but you are trying to treat that array variable as a scalar string variable in your query string.

benracer

so how do i view it

NogDog

Since I have no idea what you are storing in that array or what you want to do with it in your query, I have no real idea. Perhaps you want to [man]implode/man it?

halojoy

you should:

convert you array into a string

store the string in db

pull string from db
convert string to array

Most used is [man]implode[/man] and to convert back [man]explode[/man]
It will work on simple arrays, but not with multidimensional.
in your case $myarray would be: $_SESSION["cart"]

To get the keys + values, makes it more complicated
Maybe make 2 strings: 1 with the keys and 1 with values
But as you use: $_SESSION["cart"][$id] = $id;
it makes it rather easy to fix ( see my foreach loop )

<?php

session_start(); // in the beginning of script

// some substring youre sure doesnt exist in array values!
$delimiter = '_#_';

$string = implode( $delimiter, $myarray );


// Pull back the array  ------------------------
session_start(); // if wasnt started before in script

$delimiter = '_#_';
$arr = explode( $delimiter, $string );

foreach($arr AS $id ){
    $myarray[$id] = $id;
}

$_SESSION["cart"] = $myarray;

?>