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: [EMAIL PROTECTED]


-----Original Message-----
From: Altug Sahin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 8 January 2003 2:07 PM
To: [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...

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', '[EMAIL PROTECTED]', '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





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

Reply via email to