Jump to content

Help, Pretty Please stuck


TinaOConnell
Go to solution Solved by TinaOConnell,

Recommended Posts

  • Replies 51
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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? 

Link to comment
Share on other sites

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 by simeonC
Link to comment
Share on other sites

 

$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);
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

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!!! 

Link to comment
Share on other sites

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.
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by mikosiko
Link to comment
Share on other sites

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
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by mikosiko
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by TinaOConnell
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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!!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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']}', ... ";

 

Link to comment
Share on other sites

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 

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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?? 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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? 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.