delete from mysql on window close

krummels

Hi All,
I would like to know if someone can help me.

I'm designing a shopping cart but its currently working without sessions.
So,My problem is ?

Users are adding items to the cart,but what if they add the item to the cart but closes the browser window without submitting the order.So the items stay in the cart.I want to have a script or funtion that emptys the cart WHERE USER_ID=$user_id && USER_TRACK=$user_track .How can I do this without useing sessions as I'm not too clever with those :-)

Any help much appreciated,Thanks

tha_mink

Well, you could use cookies but if you're going to do that, you might as well use sessions. It looks like it's time to start learning.

Here's a good start...

http://www.onlamp.com/pub/a/php/2001/04/26/sessions.html?page=1

and here's part two..

http://www.onlamp.com/lpt/a/php/2001/05/10/sessions.html

krummels

Hi, Thanks for your reply.

Ive been busy with the sessions stuff,its not that bad.

So,I got the cart to work in sessions now but one thing remains
or my sessions is not working properly.

If the user do not submit the the order,the cart items is still in the mysql db
How can I have a script that delete the record entered by the user as soon as the session is destroyed (He/she closes the window for instance) ???

The sesion_id is being entered in mysql too keep track of the intems.

the interface is working perfectly but I need the script to get rid of the ......well "false" orders.

Thanks again!

tha_mink

Well, instead of putting the cart items in a DB while the user is shopping, why not just store all the items with sessions. Then when the user closes his browser the session, and cart items, are destroyed.

If you want to keep the cart items valid for a day or two, you can set your session to last however long you like and set a cookie on the client side with the PHPSESSION id. That way, if the user comes to shop, picks out a few items, but has to stop shopping, when he comes back tommorrow his shopping cart is still how he left it. Then after a day or two, you can have the cookie and session expire and his cart will be empty again. Make sense?

krummels

Yes,It does make sense,I'll go and try it out!! and come back to you .Thanks for the help

krummels

I've tried something else!

Is it possible to execute a script looking like this more or less

if(session_destroy()) {
//Create connection
$connection = mysql_connect("database", "user", "password")
or die ("Couldn't connect to database.". mysql_error());
//Select database
$db = mysql_select_db("database", $connection) or die ("Couldn't select database");

$rm_item_sql = "DELETE FROM session_track WHERE USER_ID = \"$sessionId\"";
mysql_query($rm_item_sql) or die ("Couldn't delete item");
}

the problem with this is...Its going passed the if statement and deletes the record(should only delete IF the session is destroyed).Do I have an error somewhere ?

F_Meijer

It's not going passed the session_destroy() but what you are saying in this statement is:

If you can destroy the session then delete something from my database...and that is what it does. So your code works fine but it's something you didn't want at all.

I'm having the same problem. I'm writing a user system and people should be able to login and out. This works fine but I also have a record user_active which can be set to 0 or 1 representing a user being logged in or not.
(0 being not logged in and 1 being logged in)

If the user logs out by clicking the logout link, the record is updated but if the user closes his browser the session is gone but the record is not updated. So according to this record he or she is still logged in.

I'm looking for something myself to overcome this problem

melsi

Hi there! I haven't read your threads in big depth but if I am not wrong, in general you want to do something if the user presses the cross button of his browser.
If you don't mind using JScript or JavaScript this may help:

This scripts does something ONLY when browser is closed!

Eample with 3 files:

main.htm:
#######################################################################
<html>
<head><script language="JavaScript">
function leave()
{ if ((window.screenTop > 10000) && (window.screenLeft > 10000))
{window.open("dosomething.htm")}
}
</script></head>
<body onUnload=leave();>
<a href=nextpage.htm>nextpage</a>
</body></html>
#######################################################################
nextpage.htm: (same script)
#######################################################################
<html>
<head><script language="JavaScript">
function leave()
{ if ((window.screenTop > 10000) && (window.screenLeft > 10000))
{window.open("dosomething.htm")}
}
</script></head>
<body onUnload=leave();></body></html>
#######################################################################
dosomething.htm:
#######################################################################
<html>
<body>Hi there! I could be a (.php), (.asp) or anything else</body>
</html>
#######################################################################
The basic idea of this script comes from user <sasarivera> from <#dev shed forums>.
Thank you SASARIVERA!

I hope this will be of some help to you!:p