Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

On Session End

Codes here !

Moderators: macek, egami, gesf

On Session End

Postby tsutttra12 » Wed Jun 18, 2014 12:16 pm

I've done custom php sites before but this is the first eCommerce site. I have a MySQL database with a table that matches sessionID to cartID and then a table that has cartID, sku, and quantity.
When someone leaves the site and a session ends obviously the session id along with the cart info is still in the database. the only thing I can think to remedy this is in the header file query the session id's and match it to the current running session ID's and delete anything that's not there. Does anyone have a better way to do this?
tsutttra12
New php-forum User
New php-forum User
 
Posts: 8
Joined: Mon Mar 03, 2014 11:00 am

Return to mySQL & php coding

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.