Re: Re: Double entry into MySQL..

Is this a php.ini or apache setting? "Marek Kilimajer" <kilimajer@webglobe.sk> wrote in message news:3E1BEF6B.6000407@webglobe.sk... > 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 > >> > >> > >> > > > > > > > > >