Displaying records from $_SESSION array

[abhi_madhani]

Hi, friends

 

I am trying to store a value in a session array, and calling it on second page, but instead of displaying all the records, its just displaying the 2nd record out of many on the next page.

 

Can you guys please help me as to why this is not happening.

 

First page - it retrieves the result from database and displays in a table.

 

session_start();
$filelistSQL="select * from files";
$exelistarray=mysql_query($filelistSQL) or die (mysql_error);

while ($filelistarray=mysql_fetch_array($exelistarray))
{
	$_SESSION['filename']= array('id' => $filelistarray['id'],
		'merchantid' => $filelistarray['merchantid'],
		'filelocation' => $filelistarray['flocation']);

	echo "<tr>";
	echo "<td>".$filelistarray['id']."</td>";
	echo "<td>".$filelistarray['merchantid']."</td>";
	echo "<td>".$filelistarray['flocation']."</td>";
	echo "</tr>";

}

 

 

Second page grabs the value from the $_SESSION and displays them in a page. Its just displays the 2nd record not 1st and other remaining records

 

session_start();
foreach ($_SESSION['filename'] as $i => $filevalue)
{
	echo $_SESSION['filename'][$i];
}

 

Regards,

Abhishek

[br0ken]

Each time you try to add a new array to your session you actually overwrite the current one.

 

Consider the following:

 

<?php

// Assign an array to filename session variable
// No matter how many times you do this filename will only contain 1 array
$_SESSION['filename'] = array();

// Assign an empty array to filename session variable
$_SESSION['filename'] = array();

// And then assign values to that array...
$_SESSION['filename'][] = array('First Array');
$_SESSION['filename'][] = array('Second Array');
$_SESSION['filename'][] = array('Third Array');
$_SESSION['filename'][] = array('Fourth Array');
?>