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
