Session not destroying

[petenaylor]

Hi all

 

I have a checkout sequence that adds items, prices etc... into an SQL Database with a session id that is started on every page in my header.

 

I have written a success page that uses session_destroy(); but it doesn't unset the $sessionid variable. I have also tried to unset($sessionid) but it keeps the session id?

 

Please help!

 

Many thanks.

 

Pete

[fugix]

make sure you have session_start() at the top of the [age you are using to destroy your session..if you do, please show us your code

[redixx]

Try:

unset($_SESSION);
session_destroy();

[fugix]

just re-read the OP, are you trying to actually use session_destroy() on the variable that holds your $_SESSION value? if so, that wont work...you will need to do something like

<?php

session_start();
session_destroy($_SESSION['id']);

?>

where your index "id" would be whatever you named your session, also, if you wanted to destroy every session you have created you can use redixx method, however be careful, because it will destroy EVERY session that is initialized

[redixx]

just re-read the OP, are you trying to actually use session_destroy() on the variable that holds your $_SESSION value? if so, that wont work...you will need to do something like

<?php

session_start();
session_destroy($_SESSION['id']);

?>

where your index "id" would be whatever you named your session, also, if you wanted to destroy every session you have created you can use redixx method, however be careful, because it will destroy EVERY session that is initialized

 

What do you mean by all sessions? It will only destroy that user's session.

[fugix]

that's what i mean, if the he has sessions stored for lets say his login credentials the user will be logged out if his login is based off of sessions

[redixx]

that's what i mean, if the he has sessions stored for lets say his login credentials the user will be logged out if his login is based off of sessions

 

Gotcha.

 

OP, in case you don't want that to happen you can unset individual session keys like this:

unset($_SESSION['key']);

[petenaylor]

Hi all

 

Thanks for the replies, I have added the following into the code but it still doesn't destroy my session?

 

session_destroy($sessionid);

 

On each of my pages I have session_start(); as it's included in my config file which is included in my header on each page.

 

I have preview of the shopping cart on each page too which looks like this:

 

<?php 
  $getheaderbasket = mysql_query("SELECT * FROM `store_basket` WHERE sessionid = '".$sessionid."'") or die (mysql_error());
  $numproductsheaderbasket = mysql_num_rows($getheaderbasket);
  
  
  while ($showheaderbasket = mysql_fetch_array($getheaderbasket)) { 
  
  // Work out totals:
  
  $header_item_total = $showheaderbasket['qty'] * $showheaderbasket['price'];
  $header_item_total = number_format($header_item_total, 2);
  $header_subtotal += $header_item_total;
  
  }
  ?>

 

Am I right in thinking that if the session is destroyed, the above shoudn't find any products as the $sessionid is destroyed?

 

Many thanks for you help.

 

Pete

[revraz]

$sessionid isn't destroyed, $_SESSION is destroyed.

[petenaylor]

OK, how do I destroy $sessionid  so that it creates a new one for use with my basket?

[revraz]

$sessionid = "";

 

Why does it have to be destroyed, just overwrite it?  I think you are confusing variables with session variables.

[petenaylor]

I see. Basically, when a user checks out I want to keep the basket details in the SQL as they are.

 

The basket has the session id, product, price and shipping cost. When they complete checkout, I want the session id to be reset so that if they place another order, it adds a new sessionid into the basket.

 

Thanks for your help.

 

 

[fugix]

You cannot use session_destroy() on a variable. You must enter the session itself into the function.

session_destroy($_SESSION['id'])

To unset the variable holding the value of your session you can use the method that the previous poster provided

[xyph]

Why not simply move the row out of `store_basket` and into a `checked_out` table... then you can continue to use the same session with a fresh basket.