#24952 [Com]: PHP 4.3.2 + Postgresql 4.3.x without SSL inserts 2 elements

 ID:               24952
 Comment by:       test dot lamp at gmail dot com
 Reported By:      sirber at myrealbox dot com
 Status:           No Feedback
 Bug Type:         PostgreSQL related
 Operating System: Gentoo Linux
 PHP Version:      4.3.2
 New Comment:

This is issue because of submitting form for two times.

I found that the form is submitted through javascript as well as in
OnSubmit action.


Previous Comments:
------------------------------------------------------------------------

[2004-02-11 15:01:36] sirb3r at yahoo dot ca

got the bug, not related at all to PHP nor postgresql.

we had an <input type="submit" onclick="document.formu.submit()">

Took 7 months to find it :S

------------------------------------------------------------------------

[2004-01-19 14:10:32] [email protected]

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.

And too old PHP version anyway.


------------------------------------------------------------------------

[2004-01-13 14:28:32] [email protected]

Does it happen if your page contains ONLY the code, no HTML at all? 


------------------------------------------------------------------------

[2004-01-12 11:37:30] sirb3r at yahoo dot ca

The bug strike again, in Internet Explorer, whitout SSL.

PostgreSQL: 7.3.5
PHP: 4.3.4-r2
Apache: 2.0.48-r1

From apache logs:
the pages are asked only once: page1 - save - page2
From Javascript:
the output from page "save" is only sent once (tested with "alert")
From PHP:
the script is executed twice:
12 2004-01-12 11:08:34.834394 Ajout de contrat: PID:10607 ID:3200
13 2004-01-12 11:08:34.900397 Ajout de contrat: PID:24142 ID:3201

with this code:
pg_query("INSERT INTO tblasscontrat (enttitulaireid, refassureurid,
nom, numero, dateeffective, dateterminaison , ident_emp, creepar, type)
VALUES (" . $entTitulaireID . ", " . $selAssureur . ", '" . $txtNom .
"', '" . $txtNo . "', " .$txtDateEffective . ", " . $txtDateTerminaison
. ", " . GetMyPid() . ", " . $sUserID . ", " . $Type.")");
$sqlLastID = pg_query("SELECT currval('tblasscontrat_asscontratid_seq')
AS lastid FROM tblasscontrat");
$rsLastID = pg_fetch_object($sqlLastID);
$rsLastID = $rsLastID->lastid;
$req = "INSERT INTO tbllog (message) VALUES ('Ajout de contrat: PID:" .
GetMyPid() . " ID:" . $rsLastID . "')";
pg_query($req);

Possible cause:

from: Internet Explorer 6.0.2800.1106.XPSP2.030422-1633 - apache -
mod_php - postgresql
mod_php execute the scripts 2 times, but only return the first one to
apache.
from: Internet Explorer 6.0.2800.1106.XPSP2.030422-1633 - apache -
mod_ssl - mod_php - postgresql
the script is only executed once.
On Mozilla 1.5, with or without SSL, the script is only executed once.

I tryed with HTTP 1.0/1.1, with and without proxy (squid), and this
error happend on both of my servers, both running gentoo linux.

------------------------------------------------------------------------

[2003-08-06 08:00:04] sirber at myrealbox dot com

Ths page isn't reloaded, and it's processed only 1 time. I think there
is a conflict between mod_php and apache, coz when the page goes through
mod_ssl it's working #1...

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/24952

-- 
Edit this bug report at http://bugs.php.net/?id=24952&edit=1