Help, Pretty Please stuck

TinaOConnell · June 18, 2013

still not connecting..

Error message is

Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2005): Unknown MySQL server host '50.97.101.236:3307' (25) in/home2/astrans/public_html/employment/contact_action_contact.php on line 9
Could not connect:

TinaOConnell · June 18, 2013

I have the form on one site.. www.aandstransportation.com/employment and the database on another site.. www.bigschoolbus.com

I believe that is part of the problem here..

but I have whitelisted both sites on the other's cpanel under Remote Mysql..

any other suggestions?

simeonC · June 18, 2013

Well I would suggest contactng your hosting company to make sure that you are connecting to the server correctly they will certainly help you get connected. I don't think having them in two seperate locations is a problem

Edited June 18, 2013 by simeonC

kicken · June 18, 2013

$username="userhere";
$password="passhere";
$database="dbhere";
$server="iphere:3307";

$link=mysqli_connect ($server, $username, $password);

If you check the manual for mysqli_connect, notice it has two separate parameters for the server and port. You need to split them up rather than pass them both as a string like you currently are. You can also select the database during the connect rather than after using mysqli_select_db (which you incorrectly have as mysql_select_db)

$username="userhere";
$password="passhere";
$database="dbhere";
$server="iphere";
$port=3307;
$link = mysqli_connect($server, $username, $password, $database, $port);

gamma1itman · June 18, 2013

Tina OConnell

http://writecodeonline.com/php/ is where I test PHP code. It is telling us that:

Parse error: syntax error, unexpected ''$_POST[APPLICANT_TO_COMPLETE_' (T_CONSTANT_ENCAPSED_STRING) 15

The T indicates that it is a token. A list of tokens can be found at http://php.net/manual/en/tokens.php. Looking there, it shows that the error means that it found a string in an unexpected place

Somewhere around "'$_POST[APPLICANT_ I think its the " or ' but I am by no means a pro. Try removing " and if no..... try replacing it and removing the '

Sorry I could not be more help.

TinaOConnell · June 18, 2013

I think that helped putting the port on a separate line.. seemed to connect now but has one more error message..

Here is the new error:

Warning: mysqli_query() expects at least 2 parameters, 1 given in/home2/astrans/public_html/employment/contact_action_contact.php on line 16

Warning: mysql_query() expects parameter 2 to be resource, object given in/home2/astrans/public_html/employment/contact_action_contact.php on line 18
Error:

Here is the updated code:

<?php 
//send data to sql database first

$username="USER HERE";
$password="PASS HERE";
$database="DB HERE";
$server="IP HERE";
$port="PORT HERE";

$link=mysqli_connect ($server, $port, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysqli_error()); 
  } 

@mysqli_select_db($database, $link); 

$result = mysqli_query("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); 

if (!mysqli_query($mysql_query,$link)) 
  { 
  die('Error: ' . mysqli_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


mysqli_close($link); 
?>

Can you help with this new error? Thank you all so much for all you have done so far to help me on this. I am sorry for presenting such a monster code.. What a stinker.

TinaOConnell · June 18, 2013

Actually I found out having the port there at all is part of the issue.. per another forum... tried this code below and now have only one small issue which is a warning!!!

Error is:

Warning: mysqli_query() expects at least 2 parameters, 1 given in/home2/astrans/public_html/employment/contact_action_contact.php on line 17

Your message has been sent to us with your full application details.
We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment.

Code is:

<?php 
//send data to sql database first

$username="school_ast";
$password="maryia11";
$database="school_1";
$server="50.97.101.236";


$link=mysqli_connect ($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysqli_error()); 
  } 

@mysqli_select_db($database, $link); 

$result = mysqli_query("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); 

if (!result)
  { 
  die('Error: ' . mysqli_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


mysqli_close($link); 
?>

Help.. just on line 17 please ????

Almost done!!!

kicken · June 18, 2013

I think that helped putting the port on a separate line.. seemed to connect now but has one more error message..

Your connect line is still incorrect. Look at what I wrote above, the port goes at the end, not as the second argument. There is also the database argument to be added.

Warning: mysqli_query() expects at least 2 parameters, 1 given in/home2/astrans/public_html/employment/contact_action_contact.php on line 16

mysqli_query requires two arguments, the first being the connection resource, the second being the query text. You need to update your call to match that. Add $link as the first argument.

$result = mysqli_query($link, "INSERT INTO ...");

Warning: mysql_query() expects parameter 2 to be resource, object given in/home2/astrans/public_html/employment/contact_action_contact.php on line 18

Error:

This error is caused by the second call to mysqli query that you have, which is unnecessary and can be removed. That if statement should be changed to just check the value of $result.

if (!$result){
die('Error: '.mysqli_error());
}

Lastly, I believe this has been mentioned before already but you really need to make sure you run all those $_POST fields used in your query through mysqli_real_escape_string. Failure to do so will cause problems with your query whenever special characters are used, and leaves you open to sql injections attacks.

TinaOConnell · June 18, 2013

Kicken,

I tried it with the port number.. with it I get the cannot connect error..

I tried it without the port number and it works, I have no error message now however it is not putting the data into the database at all.. Not sure why.

I don't understand mysqli_real_escape_string(). enough to do that yet.. I will but I will wait till I get the basics working and backed up and then add that to the script..

Now no error message BUT NOT PUTTING DATA into table from the employment application.

Here is the code now:

<?php 
//send data to sql database first

$username="username";
$password="pass";
$database="database name";
$server="ip";


$link=mysqli_connect ($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysqli_error()); 
  } 

@mysqli_select_db($database, $link); 

$result = mysqli_query($link, "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); 

if (!result)
  { 
  die('Error: ' . mysqli_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


mysqli_close($link); 
?>

Thanks, Tina

mikosiko · June 18, 2013

from this line

@mysqli_select_db($database, $link);

take out the error suppression character (@) ... it will hide possible errors at that level... is better to find the errors and solve'em instead to hide'em.

for debugging is better if you take out the SQL string from your mysqli_query() like this:

// This line has been copied just in the way that you it now, but as been said... you must run mysqli_real_escape_string() in all the $_POST fields
$query =  "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'";

// echo your string during debugging to be sure you are trying to execute the right sentence (you must comment the echo line after your finish your debugging)
echo $query;

// Is the query string OK... then execute it 
$result = mysqli_query($link, $query);

Edited June 18, 2013 by mikosiko

TinaOConnell · June 18, 2013

For escape strings...

Should it be like this for each field on the form or each field on the database???

$APPLICANT_TO_COMPLETE_FirstName = $_POST['APPLICANT_TO_COMPLETE_FirstName];

$APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($APPLICANT_TO_COMPLETE_FirstName);

???

And this goes under line 17? or after each field??? does it matter where it goes???

Thanks, Tina

TinaOConnell · June 18, 2013

I started by removing just the @ symbol and tested.. got another error message..

trying the other steps now.. here is the error message..

Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in/home2/astrans/public_html/employment/contact_action_contact.php on line 15

mikosiko · June 18, 2013

could be in this way:

$APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_FirstName']);

for each $_POST field that you will pass to the $query string that I show in my previous post... so obviously must be before your INSERT query string.

mikosiko · June 18, 2013

you see now what the error suppression character was doing?.... hiding an error from you... the right syntax is:

bool mysqli_select_db ( mysqli $link , string $dbname )

in your code should be

mysqli_select_db( $link, $database)

Edited June 18, 2013 by mikosiko

kicken · June 18, 2013

You can simplify the mysqli_real_escape_string by doing an array_map call on $_POST. Like this:

function mres_cb($v){
   global $link;
   return mysqli_real_escape_string($link, $v);
}

$Escaped = array_map('mres_cb', $_POST);

That will escape every item in the $_POST array and save the escaped data to a new array called $Escaped. This needs to be done before your query is defined and run. Then you just change all your $_POST's in the query text to $Escaped.

$query =  "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('{$Escaped['APPLICANT_TO_COMPLETE_FirstName']}', ... ";

I tried it with the port number.. with it I get the cannot connect error..

Unless you were specifically told by your host that you need to connect to a different port, you should not be specifying it anyway. The default port for mysql is 3306. I assumed you were attempting to use 3307 for a reason, but if not then just leave it out.

TinaOConnell · June 18, 2013

Miko..

Here goes.. does this look ok?

<?php 
//send data to sql database first

$username="user here";
$password="pass here";
$database="db here";
$server="ip here";


$link=mysqli_connect ($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysqli_error()); 
  } 

mysqli_select_db($link, $database); 

$APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_FirstName']);
$APPLICANT_TO_COMPLETE_LastName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_LastName']);
$DateofApplication = mysqli_real_escape_string($link, $_POST['DateofApplication']);
$APPLICANT_TO_COMPLETE_PhoneNumber = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_PhoneNumber']);
$APPLICANT_TO_COMPLETE_SecondaryPhone = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_SecondaryPhone']);
$License1 = mysqli_real_escape_string($link, $_POST['License1']);
$APPLICANT_TO_COMPLETE_CurrentAddress = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentAddress']);
$APPLICANT_TO_COMPLETE_CurrentCity = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentCity']);
$APPLICANT_TO_COMPLETE_CurrentState = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentState']);
$APPLICANT_TO_COMPLETE_CurrentZip = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentZip']);

$result = mysqli_query($link, "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); 


if (!result)
  { 
  die('Error: ' . mysqli_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


mysqli_close($link); 
?>

Edited June 18, 2013 by TinaOConnell

mikosiko · June 18, 2013

lines 17 to 26 looks ok... but now you have to replace all the $_POST in the INSERT with the variables that you just created, other way is use mysqli_real_escape_string() directly in your INSERT sentence, it will eliminate the additional variables ... I will suggest you to look kicken answer too... he showed you another method using a function and how to use it in the INSERT.. either one that you use should put you in the right track

TinaOConnell · June 18, 2013

OK.. did these changes.. tested.. and here is the result.. NO ERROR MESSAGE NOW.. and here is the code.. email works but does not send the data to the database..

HELP.. I am so lost.. anyone want to trade some work out.. design for programming to get this off my desk??

<?php 
//send data to sql database first

$username="user";
$password="pass";
$database="db name here";
$server="ip";

$link=mysqli_connect ($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysqli_error()); 
  } 

mysqli_select_db( $link, $database); 

$APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_FirstName']);
$APPLICANT_TO_COMPLETE_LastName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_LastName']);
$DateofApplication = mysqli_real_escape_string($link, $_POST['DateofApplication']);
$APPLICANT_TO_COMPLETE_PhoneNumber = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_PhoneNumber']);
$APPLICANT_TO_COMPLETE_SecondaryPhone = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_SecondaryPhone']);
$License1 = mysqli_real_escape_string($link, $_POST['License1']);
$APPLICANT_TO_COMPLETE_CurrentAddress = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentAddress']);
$APPLICANT_TO_COMPLETE_CurrentCity = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentCity']);
$APPLICANT_TO_COMPLETE_CurrentState = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentState']);
$APPLICANT_TO_COMPLETE_CurrentZip = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentZip']);

$result = mysqli_query($link, "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); 


if (!result)
  { 
  die('Error: ' . mysqli_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


mysqli_close($link); 
?>

Thanks everyone who has been helping thus far.. really thank you bunches!!

TinaOConnell · June 18, 2013

Miko,

I am sorry I don't understand what your saying here... again not being a hard coder... background in design and ecommerce the most programming I usually do it for interface design and very little at that. Can you kinda spell it out what you mean? In code?? just one line?

Thanks, T

mikosiko · June 18, 2013

here you go... just one field as example:

$APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_FirstName']);

.....

$query = "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('{$APPLICANT_TO_COMPLETE_FirstName}', <same for the other fields>....";

$result = mysqli_query($link, $query);

but, look kicken answer... it is the easiest/shortest one... just quoting part of his answer here in case you lost it:

You can simplify the mysqli_real_escape_string by doing an array_map call on $_POST. Like this:
function mres_cb($v){
global $link;
return mysqli_real_escape_string($link, $v);
}

$Escaped = array_map('mres_cb', $_POST);That will escape every item in the $_POST array and save the escaped data to a new array called $Escaped. This needs to be done before your query is defined and run. Then you just change all your $_POST's in the query text to $Escaped.

$query = "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('{$Escaped['APPLICANT_TO_COMPLETE_FirstName']}', ... ";

TinaOConnell · June 18, 2013

I think I understand.. his idea would be better and faster but I already did your suggestion.. so.. here goes..

I am still getting NO ERROR MESSAGE but the data is not going into the database AT ALL!!! It is connecting per the log on my cpanel.. but nothing is happening after that.

I checked the names of each field.. checked EVERYTHING.. I need to be done with this project. Can you please help me.. Here is the code I am left with..

<?php 
//send data to sql database first

$username="user";
$password="pass";
$database="db";
$server="ip";

$link=mysqli_connect ($server, $username, $password); 
if (!$link)  { 
  die('Could not connect: ' . mysqli_error()); 
  } 

mysqli_select_db( $link, $database); 

$APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_FirstName']);
$APPLICANT_TO_COMPLETE_LastName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_LastName']);
$DateofApplication = mysqli_real_escape_string($link, $_POST['DateofApplication']);
$APPLICANT_TO_COMPLETE_PhoneNumber = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_PhoneNumber']);
$APPLICANT_TO_COMPLETE_SecondaryPhone = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_SecondaryPhone']);
$License1 = mysqli_real_escape_string($link, $_POST['License1']);
$APPLICANT_TO_COMPLETE_CurrentAddress = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentAddress']);
$APPLICANT_TO_COMPLETE_CurrentCity = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentCity']);
$APPLICANT_TO_COMPLETE_CurrentState = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentState']);
$APPLICANT_TO_COMPLETE_CurrentZip = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentZip']);

$result = mysqli_query($link, "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('{APPLICANT_TO_COMPLETE_FirstName},'{APPLICANT_TO_COMPLETE_LastName}','{DateofApplication}','{APPLICANT_TO_COMPLETE_PhoneNumber}','{APPLICANT_TO_COMPLETE_SecondaryPhone}','{License1}','{APPLICANT_TO_COMPLETE_CurrentAddress}','{APPLICANT_TO_COMPLETE_CurrentCity}','{APPLICANT_TO_COMPLETE_CurrentState}','{APPLICANT_TO_COMPLETE_CurrentZip}'"); 


if (!result)
  { 
  die('Error: ' . mysqli_error()); 
  } 

//now send email to applications@aandstransportation.com
$to = 'applications@aandstransportation.com';
$from = $_POST['ApplicantName'];
// $status = $_POST['Project_status'];
/* subject */ 
$subject = "Application For Employment Web Submission"; 
/* message */ 
$message = '<html> 
<head> 
<title>Application For Employment Web Submission</title> 
</head> 
<body> 
<p>Dear '.$to.',</p> 
<table>
<tr> 
<td colspan="2">"Employment Application Details:"</td>
</tr><tr> 
 <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td>  
 </tr>  <tr> 
  <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td>
</tr><tr> 
 <td>Company: </td><td>'.$_POST['Company'].'</td>  
</tr><tr> 
<td>Address: </td><td>'.$_POST['Address'].'</td>  
</tr><tr> 
 <td>Signature: </td><td>'.$_POST['Signature1'].'</td>  
</tr><tr> 
 <td>Date: </td><td>'.$_POST['Date'].'</td>  
</tr>

<tr> 
                  <td></h3><strong> FOR COMPANY USE</strong> </h3></td>  
</tr>

<td> </td>
<tr> 
 <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td>  
</tr>
<tr> 
 <td>District: </td><td>'.$_POST['District'].'</td>  
</tr>
<tr> 
 <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td>  
</tr>
<tr> 
 <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td>  
</tr>
<tr> 
 <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td>  
</tr>
<tr> 
 <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td>  
</tr>
<td> </td>


<tr> 
                </h3>  <strong> <td>APPLICANT TO COMPLETE</h3></strong></td>  
</tr>
<tr> 
 <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td>  
</tr><tr> 
 <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td>  
</tr><tr> 
 <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td>  
</tr><tr> 
 <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td>  
</tr><tr> 
 <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Current<br />
                            Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td></h3> <strong>Previous Addresses</strong></h3></td>  
</tr>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td>  
</tr>
<td> </td>
<tr> 
 <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td>  
</tr><tr> 
 <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td>  
</tr>


<td> </td>
<tr> 
 <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td>  
</tr><tr> 
 <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td>  
</tr><tr> 
 <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td>  
</tr><tr> 
 <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td>  
</tr><tr> 
 <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td>  
</tr>
<tr> 
 <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td>  
</tr><tr> 
 <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td>  
</tr><tr> 
 <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td>  
</tr>
<td> </td>
<tr> 
                  <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td>  
</tr>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>


 <td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
 </tr>
<td> </td>

<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
 </tr>

<td> </td>
<tr> 
 <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td>  
</tr><tr> 
 <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td>  
</tr><tr> 
 <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td>  
</tr><tr> 
 <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td>  
</tr><tr> 
 <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td>  
</tr><tr> 
 <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td>  
</tr><tr> 
 <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td>  
</tr><tr> 
 <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td>  
</tr><tr> 
 <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td>  
</tr><tr> 
 <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td>  
</tr><tr> 
 <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td>  
</tr><tr> 
 <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td>  
</tr><tr> 
 <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td>  
 </tr><tr> 
 <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
 </tr>

<td> </td>
<td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> 
<td> </td> 
<tr> 
 <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td>  
</tr>

<td> </td>
<td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> 
<tr> 
 <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td>  
</tr><tr> 
 <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td>  
</tr>


<tr> 
 <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td>  
</tr>

<tr> 
 <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td>  
</tr><tr> 
 <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td>  
</tr><tr> 
 <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td>  
</tr><tr> 
 <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td>  
</tr><tr> 
 <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td>  
</tr><tr> 
 <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td>  
</tr>
<td> </td>



<td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
<td> </td>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License1'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License2'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td>  
</tr>

<tr> 
 <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td>  
</tr><tr> 
 <td>Licence: </td><td>'.$_POST['License3'].'</td>  
</tr><tr> 
 <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td>  
</tr><tr> 
 <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td>  
</tr>
<tr> 
 <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td>  
</tr>
<tr> 
 <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td>  
</tr>
<tr> 
 <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td>  
</tr>

<td> </td>

 <tr> 
 <td>Signature: </td><td>'.$_POST['Signature'].'</td>  
</tr>
 <tr> 
 <td>Date: </td><td>'.$_POST['Date1'].'</td>  
</tr>

 <td> </td>
</tr>
</table> 

</body> 
</html>';
/* To send HTML mail, set the Content-type header. */ 
$headers  = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: " . $from . "\r\n"; 
/* and now mail it */ 
/*echo $message; die;*/
@mail($to, $subject, $message, $headers);

echo "<h4>Your message has been sent to us with your full application details.<br />
            <span>We will reply soon as soon as possible to follow up with you on our hiring process.  Thank you for considering A&S Transportation, Inc. for employment.</span></h4>";


mysqli_close($link); 
?>

Please any suggestions are welcome.. this is something that should be simple.. not sure why it takes 4 advanced programmers to help and still does not work.. I know the code started as a hot mess but I always believed php to be more forgiving.. I guess no code is forgiving at all.. Please help. Thanks, Tina

mikosiko · June 18, 2013

is a little of lack of attention to the details on your part.... look what I wrote:

$APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_FirstName']);
.....
$query = "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('{$APPLICANT_TO_COMPLETE_FirstName}', <same for the other fields>....";

and now how you did translate that to your code (just one field show as example):

$APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_FirstName']);
$result = mysqli_query($link, "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('{APPLICANT_TO_COMPLETE_FirstName},

you see the difference? (other than the obvious that in my example I'm using the query string separated)... can you see it?

TinaOConnell · June 18, 2013

Miko,

I tried that four posts ago.. and I got help from another coder who provided that update.. which eliminated one of the error messages..

AT THIS POINT.. I want to be done.. this is something that I would like to hire out to be done.. HOW MUCH ?? ANYONE??

TinaOConnell · June 18, 2013

besides.. I tried that too and getting the same error message now..

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{APPLICANT_TO_COMPLETE_LastName}', '{DateofApplication}', '{APPLICANT_TO_COMPL' at line 13

TinaOConnell · June 18, 2013

I could have done the data entry myself for 5 months for the time it took me to eliminate the data entry on this stupid form.. I am so over looking at code.. I need help.. I want this done.. Please help me I have provided ALLL code.. can you modify it how you are sure it would work, let me test it and if it works charge me..

Give me a price to do it right?

Sign In

Help, Pretty Please stuck

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information