Cookie coders...? - GoFuckYourself.com

acctman · 01-05-2005, 02:59 PM

anyone good with cookies? i need a cookie made that will close a database connection once a user leaves the site and closes his/her browser window.

please leave contact info or your website thanks.

mortenb · 01-05-2005, 03:02 PM

A cookie in itself does not in any way have access to the database. A cookie can only contain whatever data you choose to store in it, and that is all it can do.

What you are trying to do would need a server side programming or scripting language like PHP or ASP or C or something similar.

MickeyG · 01-05-2005, 03:05 PM

shouldnt you be closing the connection after each query?

mortenb · 01-05-2005, 03:08 PM

Quote:

Originally Posted by MickeyG

shouldnt you be closing the connection after each query?

You have won. Well, not after each query, but after each opened connection isn't needed anymore. No reason to make a new connection for every query..

onlyreal · 01-05-2005, 03:12 PM

well

as long you request it in php jsp or pure java
i can do it no prob

icq 20196017
msn [email protected]

MickeyG · 01-05-2005, 03:14 PM

Quote:

Originally Posted by mortenb

You have won. Well, not after each query, but after each opened connection isn't needed anymore. No reason to make a new connection for every query..

yeah exactly

acctman · 01-05-2005, 03:34 PM

thanks for the info. I have the i-rater script, its pretty much a nice script but the database connection is crappy. it remains open and doesn't close properly thus resulting in mysql crashing when too many people visit the site.

yes is should close after every query, but i guess the people at i-rater.com didn't think of that resulting in this problem. that setup up a timer to close database connections stupid if you ask me. i spoke to them about this but they just keep blowing me off.

TheMob · 01-05-2005, 03:41 PM

hmm, you should have a custom solution built. irater was made for a few hundred connections at a time max..

01-05-2005, 02:59 PM	#1
acctman Confirmed User Join Date: Oct 2003 Location: Atlanta Posts: 2,840	Cookie coders...? anyone good with cookies? i need a cookie made that will close a database connection once a user leaves the site and closes his/her browser window. please leave contact info or your website thanks.

01-05-2005, 03:02 PM	#2
mortenb Confirmed User Join Date: Jul 2004 Location: Denmark ICQ: 7880009 Posts: 2,203	A cookie in itself does not in any way have access to the database. A cookie can only contain whatever data you choose to store in it, and that is all it can do. What you are trying to do would need a server side programming or scripting language like PHP or ASP or C or something similar.

01-05-2005, 03:05 PM	#3
MickeyG Confirmed User Join Date: May 2004 Location: South Florida Posts: 4,134	shouldnt you be closing the connection after each query?

01-05-2005, 03:12 PM	#5
onlyreal Confirmed User Join Date: Jun 2001 Posts: 853	well as long you request it in php jsp or pure java i can do it no prob icq 20196017 msn [email protected]

01-05-2005, 03:34 PM	#7
acctman Confirmed User Join Date: Oct 2003 Location: Atlanta Posts: 2,840	thanks for the info. I have the i-rater script, its pretty much a nice script but the database connection is crappy. it remains open and doesn't close properly thus resulting in mysql crashing when too many people visit the site. yes is should close after every query, but i guess the people at i-rater.com didn't think of that resulting in this problem. that setup up a timer to close database connections stupid if you ask me. i spoke to them about this but they just keep blowing me off.

01-05-2005, 03:41 PM	#8
TheMob Confirmed User Join Date: Jan 2003 Location: 2006 Posts: 8,584	hmm, you should have a custom solution built. irater was made for a few hundred connections at a time max..