[SOLVED] Session Variables in loop

[dfowler]

Hey guys, I'm pulling a bunch of information from a database in a loop.  As I pull the information I want to store them in a $_SESSION variable.  Here is my code so far:

 

$query  = "SELECT * FROM table where id='$k'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
     $_SESSION['item_name'] = $row['name'];
}

 

The problem is that it is only saving the last item.  I'm not sure how to do this correctly as using session variables are rather new to me.

[papaface]

$query  = "SELECT * FROM table where id='$k'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
     foreach ($row as $key => $value)
      {
     $_SESSION[$key] = $value;
       }
}

[trq]

Assuming your only looking for the data related to one member, there may only be one record. No need for a while loop.

 

<?php

 session_start();

 $query  = "SELECT * FROM table where id='$k' LIMIT 1";
 if ($result = mysql_query($query)) {
   if (mysql_num_rows($result)) {
     $row = mysql_fetch_array($result);
     foreach ($row as $k => $v) {
       $_SESSION[$k] = $v;
     }
   }
 }

?>

[dfowler]

No, there will be multiple data.  The user will can pick either one or multiple items that they want to look at.  It's going to be a shopping cart system.

 

Screen 1

The user picks what they want to look at

 

Screen 2

shows what they picked on screen #1

 

Screen 3

processes checkout

[trq]

Then your going to need to append something to the $key on each iteration of your while loop. eg;

 

<?php

  session_start();
  $index = 0;

  $query  = "SELECT * FROM table where id='$k'";
  if ($result = mysql_query($query)) {
    if (mysql_num_rows($result)) {
      while ($row = mysql_fetch_array($result)) {
        foreach ($row as $k => $v) {
          $_SESSION[$k . '_' . $index] = $v;
          $index++;
        }
      }
    }
  }

?>

[dfowler]

Thanks for your help so far!  I assume this worked as I didn't get any error on the page and it loaded correctly.  As I stated before, I have never used session variables before.  Now that the information is in there, how do I retrieve it?

[adam291086]

just do

 

echo $SESSION['your session name here']

[dfowler]

I'm just really messing this stuff up I think, because I have no idea what the name would be.

[adam291086]

i think it will be something like

 

$SESSION[iD number_1'] The one will change everythime the loop runs thorugh, it will stop when theres no more data from the database query result

 

[dfowler]

So I should be able to come up with another loop to process the information into the database?  I'm sorry to be so dumb about this.  When I started this process I thought it would be a lot easier than it has become.

[dfowler]

I couldn't get it to work right, so I ended up as the objects were pulled in the initial loop putting them in a hidden input field.  Then I just posted them to the next screen.