SO I have a form that is connected to 1 database. I want to put the data collected in the form into the mutiple tables I have created.
Code is below. Problem is I can get data to go into the first table but after that nothing happens. Rows get created but the data is blank.
I have some data in the second table that is populated in the first table so it seems the data is passing correctly but I don't see it in the database.
Thanks for any help!🙂
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("samplephr", $con);
$Patient_ID=mysql_real_escape_string($_POST['Patient_ID']);
$Patient_First_Name=mysql_real_escape_string($_POST['Patient_First_Name']);
$Patient_Middle_Name=mysql_real_escape_string($_POST['Patient_Middle_Name']);
$Patient_Last_Name=mysql_real_escape_string($_POST['Patient_Last_Name']);
$Patient_email=mysql_real_escape_string($_POST['Patient_email']);
$Patient_DOB=mysql_real_escape_string($_POST['Patient_DOB']);
$Patient_Sex=mysql_real_escape_string($_POST['Patient_Sex']);
$Patient_Street_Address1=mysql_real_escape_string($_POST['Patient_Street_Address1']);
$Patient_Street_Address2=mysql_real_escape_string($_POST['Patient_Street_Address2']);
$Patient_City=mysql_real_escape_string($_POST['Patient_City']);
$Patient_State=mysql_real_escape_string($_POST['Patient_State']);
$Patient_Zip=mysql_real_escape_string($_POST['Patient_Zip']);
$Patient_Blood_Type=mysql_real_escape_string($_POST['Patient_Blood_Type']);
$Patient_Language=mysql_real_escape_string($_POST['Patient_Language']);
$Patient_Height=mysql_real_escape_string($_POST['Patient_Height']);
$Patient_Weight=mysql_real_escape_string($_POST['Patient_Weight']);
$Patient_Prim_Phone=mysql_real_escape_string($_POST['Patient_Prim_Phone']);
$Ins_Provider_ID=mysql_real_escape_string($_POST['Ins_Provider_ID']);
$Ins_Policy_Number=mysql_real_escape_string($_POST['Ins_Policy_Number']);
$Ins_Policy_Holder=mysql_real_escape_string($_POST['Ins_Policy_Holder']);
$PCP_ID=mysql_real_escape_string($_POST['PCP_ID']);
$sql="INSERT INTO patient (Patient_ID,Patient_First_Name,Patient_Middle_Name,Patient_Last_Name,Patient_email,Patient_DOB,Patient_Sex,Patient_Street_Address1,Patient_Street_Address2,Patient_City,Patient_State,Patient_Zip,Patient_Blood_Type,Patient_Language,Patient_Height,Patient_Weight,Patient_Prim_Phone,Ins_Provider_ID,Ins_Policy_Number,Ins_Policy_Holder,PCP_ID) VALUES ('$Patient_ID','$Patient_First_Name','$Patient_Middle_Name','$Patient_Last_Name','$Patient_email','$Patient_DOB','$Patient_Sex','$Patient_Street_Address1','$Patient_Street_Address2','$Patient_City','$Patient_State','$Patient_Zip','$Patient_Blood_Type','$Patient_Language','$Patient_Height','$Patient_Weight','$Patient_Prim_Phone','$Ins_Provider_ID','$Ins_Policy_Number','$Ins_Policy_Holder','$PCP_ID')";
if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error());
}
$Ins_Provider_Name=mysql_real_escape_string($_POST['Ins_Provider_Name']);
$Ins_Provider_Address1=mysql_real_escape_string($_POST['Ins_Provider_Address1']);
$Ins_Provider_Address2=mysql_real_escape_string($_POST['Ins_Provider_Address2']);
$Ins_Provider_City=mysql_real_escape_string($_POST['Ins_Provider_City']);
$Ins_Provider_State=mysql_real_escape_string($_POST['Ins_Provider_State']);
$Ins_Provider_Zip=mysql_real_escape_string($_POST['Ins_Provider_Zip']);
$Ins_Provider_Phone=mysql_real_escape_string($_POST['Ins_Provider_Phone']);
$Ins_Provider_Fax=mysql_real_escape_string($_POST['Ins_Provider_Fax']);
$sql="INSERT INTO insurance (Ins_Provider_Name,Ins_Policy_Holder,Ins_Provider_Address1,Ins_Provider_Address2,Ins_Provider_City,Ins_Provider_State,Ins_Provider_Zip,Ins_Provider_Phone,Ins_Provider_Fax) VALUES ('$Ins_Provider_Name','$Ins_Provider_Address1','$Ins_Provider_Address2','$Ins_Provider_City','$Ins_Provider_State','$Ins_Provider_Zip','$Ins_Provider_Phone','$Ins_Provider_Fax')";
if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error());
}
$PCP_ID=mysql_real_escape_string($_POST['PCP_ID']);
$PCP_First_Name=mysql_real_escape_string($_POST['PCP_First_Name']);
$PCP_Last_Name=mysql_real_escape_string($_POST['PCP_Last_Name']);
$PCP_Address1=mysql_real_escape_string($_POST['PCP_Address1']);
$PCP_Address2=mysql_real_escape_string($_POST['PCP_Address2']);
$PCP_City=mysql_real_escape_string($_POST['PCP_City']);
$PCP_State=mysql_real_escape_string($_POST['PCP_State']);
$PCP_Zip=mysql_real_escape_string($_POST['PCP_Zip']);
$PCP_Phone=mysql_real_escape_string($_POST['PCP_Phone']);
$PCP_Fax=mysql_real_escape_string($_POST['PCP_Fax']);
$PCP_Email=mysql_real_escape_string($_POST['PCP_Email']);
$sql="INSERT INTO primarycarephysician (PCP_ID,PCP_First_Name,PCP_Last_Name,PCP_Address1,PCP_Address2,PCP_City,PCP_State,PCP_Zip,PCP_Phone,PCP_Fax,PCP_Email) VALUES ('$PCP_ID','$PCP_First_Name','$PCP_Last_Name','$PCP_Address1','$PCP_Address2','$PCP_City','$PCP_State','$PCP_Zip','$PCP_Phone','$PCP_Fax','$PCP_Email')";
if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error());
}
$Refer_First_Name=mysql_real_escape_string($_POST['Refer_First_Name']);
$Refer_Last_Name=mysql_real_escape_string($_POST['Refer_Last_Name']);
$Refer_Specialty=mysql_real_escape_string($_POST['Refer_Specialty']);
$Refer_Phone=mysql_real_escape_string($_POST['Refer_Phone']);
$Refer_Fax=mysql_real_escape_string($_POST['Refer_Fax']);
$Refer_Email=mysql_real_escape_string($_POST['Refer_Email']);
$sql="INSERT INTO referredphysicians (Refer_First_Name,Refer_Specialty,Refer_Phone,Refer_Fax,Refer_Email) VALUES ('$Refer_First_Name','$Refer_Last_Name','$Refer_Specialty','$Refer_Phone','$Refer_Fax','$Refer_Email')";
if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error());
}
$Emer_First_Name=mysql_real_escape_string($_POST['Emer_First_Name']);
$Emer_Last_Name=mysql_real_escape_string($_POST['Emer_Last_Name']);
$Emer_Mobile_Phone=mysql_real_escape_string($_POST['Emer_Mobile_Phone']);
$Emer_Home_Phone=mysql_real_escape_string($_POST['Emer_Home_Phone']);
$Emer_Work_Phone=mysql_real_escape_string($_POST['Emer_Work_Phone']);
$Emer_Address1=mysql_real_escape_string($_POST['Emer_Address1']);
$Emer_Address2=mysql_real_escape_string($_POST['Emer_Address2']);
$Emer_City=mysql_real_escape_string($_POST['Emer_City']);
$Emer_State=mysql_real_escape_string($_POST['Emer_State']);
$Emer_Zip=mysql_real_escape_string($_POST['Emer_Zip']);
$Emer_Relationship=mysql_real_escape_string($_POST['Emer_Relationship']);
$Patient_ID=mysql_real_escape_string($_POST['Patient_ID']);
$sql="INSERT INTO emergencyinfo (Emer_First_Name,Emer_Last_Name,Emer_Mobile_Phone,Emer_Home_Phone,Emer_Work_Phone,Emer_Address1,Emer_Address2,Emer_City,Emer_State,Emer_Zip,Emer_Relationship,Patient_ID) VALUES ('$Emer_First_Name','$Emer_Last_Name','$Emer_Mobile_Phone','$Emer_Home_Phone','$Emer_Work_Phone','$Emer_Address1','$Emer_Address2','$Emer_City','$Emer_Zip','$Emer_Relationship','$Patient_ID')";
if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error());
}
$Avocadoes=mysql_real_escape_string($_POST['Allergy_Name']);
$Eggs=mysql_real_escape_string($_POST['Allergy_Name']);
$Peanuts=mysql_real_escape_string($_POST['Allergy_Name']);
$Fish=mysql_real_escape_string($_POST['Allergy_Name']);
$Shellfish=mysql_real_escape_string($_POST['Allergy_Name']);
$Milk=mysql_real_escape_string($_POST['Allergy_Name']);
$Soy=mysql_real_escape_string($_POST['Allergy_Name']);
$Wheat=mysql_real_escape_string($_POST['Allergy_Name']);
$Chocolate=mysql_real_escape_string($_POST['Allergy_Name']);
$Chicken=mysql_real_escape_string($_POST['Allergy_Name']);
$Fruit=mysql_real_escape_string($_POST['Allergy_Name']);
$Alcohol=mysql_real_escape_string($_POST['Allergy_Name']);
$Dust=mysql_real_escape_string($_POST['Allergy_Name']);
$Mold=mysql_real_escape_string($_POST['Allergy_Name']);
$Pets=mysql_real_escape_string($_POST['Allergy_Name']);
$Smoke=mysql_real_escape_string($_POST['Allergy_Name']);
$Insect_Stings=mysql_real_escape_string($_POST['Allergy_Name']);
$Latex=mysql_real_escape_string($_POST['Allergy_Name']);
$Plants=mysql_real_escape_string($_POST['Allergy_Name']);
$Cosmetics=mysql_real_escape_string($_POST['Allergy_Name']);
$Fragrances=mysql_real_escape_string($_POST['Allergy_Name']);
$Jewelry=mysql_real_escape_string($_POST['Allergy_Name']);
$Soaps_Detergents=mysql_real_escape_string($_POST['Allergy_Name']);
$Topicals=mysql_real_escape_string($_POST['Allergy_Name']);
$ACE_Inhibitors=mysql_real_escape_string($_POST['Allergy_Name']);
$Beta_Blockers=mysql_real_escape_string($_POST['Allergy_Name']);
$Ibuprofen=mysql_real_escape_string($_POST['Allergy_Name']);
$Penicillin=mysql_real_escape_string($_POST['Allergy_Name']);
$Aspirin=mysql_real_escape_string($_POST['Allergy_Name']);
$Patient_ID=mysql_real_escape_string($_POST['Patient_ID']);
$sql="INSERT INTO patientallergies (Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Allergy_Name,Patient_ID) VALUES ('$Avocadoes','$Eggs','$Peanuts','$Fish','$Shellfish','$Milk','$Soy','$Wheat','$Chocolate','$Chicken','$Fruit','$Alcohol','$Dust','$Molds','$Pets','$Smoke','$Insect_Stings','$Latex','$Cosmetics','$Fragrances','$Jewelry','$Soap_Detergents','$Topicals','$ACE_Inhibitors','$Beta_Blockers','$Ibuprofen','$Penicillin','$Aspirin','$Patient_ID')";
if (!mysql_query($sql,$con)) {
die('Error: ' . mysql_error());
}
?>
