Does this look ok? (cookies, very simple)

faydra92

$timeout = "240";
if (isset($_COOKIE['zs4d'])) {
   if (time() - $_COOKIE["zs4d"] < $timeout){
   // No MySQL
   } else {
   setcookie("zs4d", time());
   // Run MySQL
} else {
   setcookie("zs4d", time());
   // Run MySQL
}

Im trying to reduce mysql connections for my php script. every request to an image or file on my server results in the php script being called, which adds the users ip and time to a mysql table.

if there are 100 images on the site, 100 requests will be made. i want to cut this down, so i decided to set a cookie for the first time a request was made to a file, and then check for the cookie again to determine if another request is neccessary.

How does that code look? Will it work for what im trying to do? Im new to cookies, so if anyone can forsee any bad things happening with that code let me know please..

basically for each request, its going to run thru that code, determining if the mysql should run or not.

However, will cookies still be set for a request to an image or a movie or something? Will that cookie be available for the next image that loads?

Thanks 🙂

Paulus_Magnus

As long as the setcookie is executed before anything is sent to the browser it will work fine, otherwise you'll get a heap of error messages.

One problem you can have is that if your hosting provider supports http://www.mywebsite.com and http://mywebsite.com that cookies created on one domain don't transfer to the other. I use a little redirection script at the top of each page to make sure that the www is used all the time. If no www, then add it and use the header function to send "Location:" etc.

You may also want to consider using persistent connections with MySQL as this can ease MySQL server load considerably.

faydra92

Originally posted by Paulus Magnus
As long as the setcookie is executed before anything is sent to the browser it will work fine, otherwise you'll get a heap of error messages.

One problem you can have is that if your hosting provider supports http://www.mywebsite.com and http://mywebsite.com that cookies created on one domain don't transfer to the other. I use a little redirection script at the top of each page to make sure that the www is used all the time. If no www, then add it and use the header function to send "Location:" etc.

You may also want to consider using persistent connections with MySQL as this can ease MySQL server load considerably.

can you give examples for persistent connections?

Paulus_Magnus

I think you need to refer to the manual for this one as there isn't a concise answer.

http://www.php.net/manual/en/function.mysql-pconnect.php