Re: Re: Double entry into MySQL..

You should be able to get around it also by checking if $_SERVER[REQUEST_METHOD]=='HEAD' Timothy Hitchens (HiTCHO) wrote:

When they first click on the file their browser will make a request for type, size etc then when it display's the dialog box on the screen of the client it will make another request to start the download. I get around this by putting the session id into the database and if it is double requested within 5 seconds to discard. So you will need to do a select, num_rows then if below 1 insert. Timothy Hitchens (HiTCHO) Open Platform Consulting e-mail: tim@hitcho.com.au

-----Original Message----- From: Altug Sahin [mailto:altug@bonsai-apart.com] Sent: Wednesday, 8 January 2003 2:07 PM To: php-general@lists.php.net Subject: [PHP] Re: Double entry into MySQL.. Another strange behaviour... When I send the name of the file to be downloaded to this script, it works (still makes a double entry into MySQL though) with GET method but it doesn't work if the file's name is sent with the POST method. Why? I am pulling my hair out here!!! Please help... Thanks again "Altug Sahin" <altug@bonsai-apart.com> wrote in message news:20030107000217.7493.qmail@pb1.pair.com...

Hi here,

I am sending a file to user's browser and logging the downloaded file

into MySQL but everytime this script works, I see double

entry in the

MySQL table... Why is this happening? Any ideas? Thanks <? $today = date("Y-m-d"); $conn = db_connect(); if(!$conn) echo "Can't connect to database..."; $query = "INSERT INTO track_dl (dldate, email, file) VALUES ('$today', 'user@email.com', 'file.ext')"; $result = mysql_query($query); if(!$result) echo "Can't execute query: " . mysql_error(); header("Content-type: application/pdf"); readfile("file.pdf"); exit(); ?>

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php