ID: 11427
Comment by: certaplus at hotmail dot com
Reported By: john at neutralize dot com
Status: Bogus
Bug Type: MySQL related
Operating System: Win NT4 PWS
PHP Version: 4.0.5
New Comment:
I have the same problem. On two different servers, I run Apache on one
and IIS on the other. Both are ran on Windows XP with MySQL 4.0.1 and
PHP 4.3.4. I also use IE 6.0 as well as Netscape 7.1 to display the
pages.
form code :
...</tr>
</table>
<form name="form1" method="POST" action="process.php">
<p>Brand
<input type="text" name="brand">
</p>
<p> Model
<input type="text" name="model">
</p>
<p>
<input type="submit" name="Submit" value="submit">
</p>
</form>
</div>...
PHP code :
<?php
define ('db_user', 'hendrix');
define ('db_password', 'rememberme');
define ('db_host', 'localhost');
define ('db_name', 'products');
$link = mysql_connect (db_host, db_user, db_password)
or die ("Couldn't connect");
mysql_select_db (db_name)
or die ("Database couldn't be accessed");
$brand= $_POST['brand'];
$model= $_POST['model'];
$query="INSERT INTO product (id,brand,model) VALUES
('','$brand','$model')";
$result= mysql_query($query,$link);
if(!mysql_query($query,$link)) die(mysql_error());
echo "Your information as been entered";
mysql_close();
?>
Jack
Previous Comments:
------------------------------------------------------------------------
[2003-07-20 14:29:26] helmutkemper at yahoo dot com
I have a same problem using windows me, php 4.0.1 and mysql
4.23.23
Kemper
------------------------------------------------------------------------
[2001-06-12 12:27:10] [EMAIL PROTECTED]
submitted twice
------------------------------------------------------------------------
[2001-06-12 06:27:55] john at neutralize dot com
The script was fine for an Access database but when I changed it over
for a MySQL database the insertion queries sometimes (most of the time
but not all the time) adds two records to the database.
Heres my connection:
$db_hostname = "jd";
$db_username = "john";
$db_password = "nirvana";
$db_database = "neuquote";
$conn = mysql_connect($db_hostname, $db_username, $db_password)
or die ('Unable to connect to database');
$db = mysql_select_db($db_database,$conn)
or die ('Unable to connect to database');
Heres my queries:
$today = getdate();
$today = $today['mday']."/".$today['mon']."/".$today['year']."
".$today['hours'].":".$today['minutes'].":".$today['seconds'];
// Insert new company
$sql="INSERT INTO Company
(CompanyName,CompanyAddress1,CompanyAddress2,CompanyAddress3,CompanyAddress4,CompanyArea,CompanyCountryId,CompanyPostalCode,CompanyTel,CompanyFax,CompanyEmail,CompanyURL,CompanyDesc,CompanyStatus,TimeCompanyCreated)
".
"VALUES
('$company_name','$company_address1','$company_address2','$company_address3','$company_address4','$company_area',$company_country,'$company_postal_code','$company_tel','$company_fax','$company_email','$company_url','$company_desc',0,'$today')";
$res_insert_company = mysql_query($sql,$conn);
//create a new hash to insert into the db and the confirmation email
$hash=md5($email.$hidden_hash_var);
$sql="INSERT INTO CompanyContact
(ContactTitle,ContactFirstName,ContactSurname,ContactMiddleInitial,ContactAddress1,ContactAddress2,ContactAddress3,ContactAddress4,ContactArea,ContactCountryId,ContactPostalCode,ContactTel,ContactExt,ContactFax,ContactEmail,ContactPositionId,ContactUsername,ContactPassword,ContactRemoteAddress,ContactConfirmHash,ContactStatus,TimeContactCreated,CompanyId)
".
"VALUES
($title,'$first_name','$surname','$middle_initial','$address1','$address2','$address3','$address4','$area',$country_code,'$postal_code','$tel','$ext','$fax','$email',$pos,'$user_name','".
md5($password1)
."','$GLOBALS[REMOTE_ADDR]','$hash',0,'$today',$company_id)";
$res_insert_contact=mysql_query($sql,$conn);
Most of the time two companies are added to the db and sometimes two
companycontacts, this is not consistent though as sometimes it works
fine.
I have checked the submit button is not being clicked twice and the
code is running one insert for company and one for companycontact.
Is this a common problem with MySQL and PHP?
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=11427&edit=1
