Another dimension to the problem --- I am running my code on two separate
machines (Desk top & a laptop) the desktop (faster?) has this problem,
notebook (slower?) doesn't. I have code that checks for duplicate inserts
and warns user. Even this fails and the database ends up with two
identical records..
Has any one faced and solved this?
Shri
Steven wrote:
> Hi all
> Note in the source that in the MySQL Insert query "VALUES" starts at a new
> line.
> I put a DELETE command right after the INSERT command, to temporary catch
> the double line. When I did that, I placed the "VALUES..."-part on the
> same line as the first part of the query and the double inserts
> disappeared. (ofcourse)
> Weird is: I removed the DELETE-command, and placed the VALUES-part on
> another line again, and the data is still inserted once in the table.
> Very strange, but I hope putting all of the query on a single line is a
> possible solution for this weird behavior :-)
> Anyone has any idea about this ?
> Steven
> > I'm not using the browsers 'view source' at all... Only the 'view source'
> > function from PHP.
> > But when none of the source is checked, and even right after a restart of
> > MySQL and Apache, the dual insert resists...
> >
> > Funny thing is, I've had this problem in another section of the site, and
> > it
> > disappeared without any known cause.
> > And not to forget: problem doesn't appear in IE6, only in Mozilla and
> > firefox running on WinXP and Gnome2.
> >
> >
> > The code:
> > The file is called shop.php, and contains different functions indicated by
> > a
> > query-string value and separated by a Switch-structure.
> > I post the global code and the section for saving this data into MySQL.
> > If
> > you need the other code, please ask me
> > (I'm trying to avoid that for mailing too much code at once...)
> >
> > <?php
> > require ("classes/class_shops.php");
> > $shop = new shop;
> >
> > $dbconn=mysql_pconnect("localhost", "steven", "steven") or die
> > (mysql_error());
> > mysql_select_db("steven");
> >
> >
> > function pageheader () {
> > echo "<h1>SHOPS</h1>";
> > }
> >
> > $id = $_GET["id"];
> > $shopmode = $_GET["shopmode"];
> >
> > pageheader();
> >
> > switch ($shopmode) { //shop, cat, item, reg, verify, save,
> > default
> > case "shop":
> > ...
> > case "cat":
> > ...
> > case "item":
> > ...
> > case "reg":
> > ...
> > case "verify":
> > ...
> > case "save":
> > echo "SAVE";
> > $name = $_POST["name"];
> > $logo = $_POST["logo"];
> > $logoname = $_POST["logoname"];
> > $address = $_POST["address"];
> > $pcode = $_POST["pcode"];
> > $location = $_POST["location"];
> > $area = $_POST["area"];
> > $phone = $_POST["phone"];
> > $email = $_POST["email"];
> >
> > //THIS is code that inserts an already uploaded
> > image in a separate table, and returns the ID
> > if ($logoname!="" && $logo!="") {
> > require ("classes/class_image.php");
> > $img = new image;
> > $upload = $img->image_upload($logo,
> > $logoname);
> > $logoID = $upload[2];
> > } else {
> > $logoID="";
> > }
> >
> > mysql_query ("INSERT INTO shop (name, logo,
> > address, pcode, location, area, phone, email, dateadded)
> > VALUES ('$name', '$logoID',
> > '$address', '$pcode', '$location', '$area', '$phone', '$email', '" .
> > microtime() . "');", $dbconn) or die("ikke: " . mysql_error());
> > echo "Uw gegevens werden bewaard! Klik <a
> > href=>hier</a> om terug te gaan";
> > //translated: Your data has been saved!
> > break;
> > case default:
> > ...
> > }
> > ?>
> >
> >
> >
> > -----Original Message-----
> > From: Norland, Martin [mailto:Martin.Norland@xxxxxxxxxx]
> > Sent: maandag 6 december 2004 15:53
> > To: php-db@xxxxxxxxxxxxx
> > Subject: RE: Mozilla inserts twice, IE does OK... ?
> >
> > Are you using view source a lot? (some of) Mozillas view source
> > commands send the query again, minus the POST vars. This could be the
> > behaviour you're seeing.
> >
> > I say some of because there are multiple ways of viewing the source -
> > web developer toolbar's (extension) doesn't seem to suffer from this
> > problem. I'm a little cloudy on the specifics, it's a big muddled mess
> > :)
> >
> > Cheers,
> > - Martin Norland, Database / Web Developer, International Outreach x3257
> > The opinion(s) contained within this email do not necessarily represent
> > those of St. Jude Children's Research Hospital.
> >
> >
> > -----Original Message-----
> > From: Steven [Offstage] [mailto:steven@xxxxxxxxxxx]
> > Sent: Sunday, December 05, 2004 4:42 PM
> > To: php-db@xxxxxxxxxxxxx
> > Subject: Mozilla inserts twice, IE does OK... ?
> >
> >
> > Hi there,
> >
> > First post to this mailing list, and I have a very strange problem:
> >
> > I'm using Apache2 with PHP 4.3.9 and MySQL 4.0.21. Sometimes when I
> > execute an INSERT-query using mysql_query, the data is inserted twice.
> > I'm 150% sure the code is only executed once! I tried this by adding
> > 'echo "test";' right before and right after my mysql_query command.
> >
> > The double insert happens only when surfing with Mozilla and Firefox.
> > In Internet Explorer 6 the data is inserted only once (as should be).
> >
> > I found some clues pointing in the direction of sessions, but after
> > commenting out all other sections of the site and so eliminating all
> > other code, the problem was still there...
> >
> > Has anyone any idea in what direction I have to look for a cause or
> > solution ?
> >
> > Thanks in advance!
> >
> > Steven
> > ---
> > from Antwerp - Belgium
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > No virus found in this incoming message.
> > Checked by AVG Anti-Virus.
> > Version: 7.0.289 / Virus Database: 265.4.5 - Release Date: 3/12/2004
> >
> >
> > --
> > No virus found in this outgoing message.
> > Checked by AVG Anti-Virus.
> > Version: 7.0.289 / Virus Database: 265.4.6 - Release Date: 5/12/2004
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
