Q> How to Delete Records in the database when the COOKIE has expired

[merck_delmoro]

Can you give me some advise how to do it???? or some sample codes to help me to build my project

[Ken2k7]

What are you trying to do that requires that?

[merck_delmoro]

Im trying to make a login page that inserts the username of the user into the database and when it expires the username of the user will be deleted

[premiso]

Set a timestamp when you set the cookie in the database. If that timestamp is past the date, delete it. This can be done using a Cron job for *nix or Scheduled tasks for Windows.

[Zane]

why do you need to delete it?

if the timestamp is expired then they just flat out shouldn't be logged in anymore.

 

if you delete your records then what's the point of putting them in there...having all those records are good for statistics and such.

[merck_delmoro]

im trying to do a webpage that counts how many user is on my site and who they are ... there username will be stored into my database when they are online but when they are not available they will be deleted into my database

[Ken2k7]

You can select users whose accounts are active without deleting anything.

[merck_delmoro]

I can select all the user that is active that the question is how can I Update the records in the database when they are log-out or the cookie has expired????

[Ken2k7]

Does the cookie being deleted mean it expires as well? If not, then just store the time in the DB when the cookie is to be expired. Then don't worry about the cookie.

[Zane]

check out the onLoad event with JavaScript and use AJAX to do your database thing.

 

EDIT:

oops I mean onUnLoad

http://www.w3schools.com/jsref/jsref_onunload.asp

[Ken2k7]

How would onunload help? They're cookies, not sessions. o.O Perhaps I missed something?

[Zane]

good point, but that raises another question..

does the op really need cookies?

 

in short...there is no function called onCookieExpired (although you can write a cron job for it) but if you use session's you can tell who is active (logged into the page) much easier

[Ken2k7]

Well I guess cookies allow the user to be logged in after they closed the tab or navigated away from it. I'm assuming it's a free trial for x amount of time and he wants the user to only be accounted for those days.