ID: 11427
Comment by: helmutkemper at yahoo 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 a same problem using windows me, php 4.0.1 and mysql
4.23.23
Kemper
Previous Comments:
------------------------------------------------------------------------
[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
