Creating an array in a session

sgtpepper

Hi,

I need to figure out a way to do the following:

Create a 'Click here' hyperlink that includes an id # from query results. This is no big deal...

<a href="wishlist.php?wishlist[]=<? echo $row['Id']; ?>

Notice I am trying to create an array called wishlist.

I need to store multiple Id numbers that are clicked. So the array could have the end results of something like:

Array ( [0] => 149057 [1] => 149057 [2] => 149057 [3] => 149057 )

I need to be able to store an array in a session.

I am having one heck of a time figuring this out.

Can someone give me some assistance?

My goal is to create a 'wishlist' that stores the Id numbers of items that are clicked.

Thanks

drew010

instead of trying to do something like
wishlist.php?wishlist[]=<?echo $row['id']; ?>

you can just make it a regular link such as wishlist.php?witem=<? echo $row['id']; ?>

and inside wishlist.php do the following...

session_start();

$SESSION['wishlist'][] = $GET['witem'];

which will give you an array in the session called wishlist.

print_r($_SESSION['wishlist']); may yeild something like
Array ( [0] => 149057 [1] => 149057 [2] => 149057 [3] => 149057 )
as you wanted.

sgtpepper

Great...this did what I was hoping for.

Ok, last question...

using this session....how can I write a query that will give me all the results for the session:

something like

$query="SELECT * FROM mastertable WHERE Id='$_SESSION[wishlist]'";

drew010

$_SESSION['wishlist'] is an array so you wont be able to use it in a query like that.

what exactly is it you are trying to do with that query?

sgtpepper

I need to somehow take the Id numbers and query a table in the database so I can get more/other information about the Id number from a different table.

drew010

ok, try this...

foreach($_SESSION['wishlist'] as $item) {
    $where .= "ID = '$item' OR";
}

$where = substr($where, 0, -3);

$query = "SELECT * FROM mastertable WHERE $where";

pretend you have array items in wishlist 14058, 15525, 16485, 15845 you will have a query like this:
SELECT * FROM mastertable WHERE ID = '14058' OR ID = '15525' OR ID = '16485' OR ID = '15845'

that will return 4 rows of data, containing the info about each wishlist item with those id's.