I wish it was as simple as that but in the past it just hasn't always worked!!
Timothy Hitchens (HiTCHO) Open Platform Consulting e-mail: [EMAIL PROTECTED] > -----Original Message----- > From: Marek Kilimajer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 8 January 2003 7:29 PM > To: Timothy Hitchens (HiTCHO) > Cc: 'Altug Sahin'; [EMAIL PROTECTED] > Subject: Re: [PHP] 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: [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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
