Page 1 of 2 12 Last
  • Jump to page:
    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    10
    Rep Power
    0

    Question Form and database on separate server- cannot connect? HELP PLEASE?


    I have two shared hosting packages/domains..
    1. Bigschoolbus (houses my database and other applications)
    2. aandstransportation (houses our company website and the form "application for employment" that I am having issues with.

    I have whitelisted in cpanel the ip address for each on the other to avoid any issues there.. but yet I still get an error when my script is run on the form.

    Here is the error:

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


    Here is the code:

    PHP Code:

    <?php 
    //send data to sql database first

    $username="USER HERE";
    $password="PASSWORD HERE";
    $database="DB NAME HERE";
    $server="IP HERE:3307";

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

    @
    mysql_select_db($database$link); 

    $mysql_query=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 (!
    mysql_query($mysql_query,$link)) 
      { 
      die(
    'Error: ' mysql_error()); 
      } 

    //now send email
    $to 'appsATaandstransportationDOTcom';
    $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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
     </tr>


     <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
     </tr>

    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
     </tr>
    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
     </tr>

    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
     </tr>

    <td>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</td>



    <td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
    <td>&nbsp;</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 &amp; 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>&nbsp;</td>

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

     <td>&nbsp;</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>"
    ;


    mysql_close($link); 
    ?>
    Any and all help is greatly apprecieated!!
  2. #2
  3. Sarcky
    Devshed Supreme Being (6500+ posts)

    Join Date
    Oct 2006
    Location
    Pennsylvania, USA
    Posts
    10,908
    Rep Power
    6352
    Remove the port number. When I removed it, I got a message saying my password was incorrect.
    HEY! YOU! Read the New User Guide and Forum Rules

    "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

    "The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

    Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.
  4. #3
  5. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,959
    Rep Power
    1014
    Hi,

    I guess you wanted to connect to 3306, because that port is open.
    The 6 worst sins of security ē How to (properly) access a MySQL database with PHP

    Why canít I use certain words like "drop" as part of my Security Question answers?
    There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    10
    Rep Power
    0

    Seemed to solve one problem only to find another >> OMG I hate this script today HELP


    OK.. tried that.. now got a whole new error message and it was not the password.. I already had checked all the parameters over and over..

    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 code the lines spoken above..
    Your thoughts???

    PHP Code:


    @mysql_select_db($database$link); 

    $mysql_query=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 (!
    mysql_query($mysql_query,$link)) 
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    10
    Rep Power
    0
    I wanted to connect to the port because the port yes was open but because it is on a different server and I was told that was the best way to do it.. maybe not such good information as it now seems to be connecting and just not processing the code.

    I am surprised at just what a stinker these few lines of code have been..

    Thank you for helping.
  10. #6
  11. Sarcky
    Devshed Supreme Being (6500+ posts)

    Join Date
    Oct 2006
    Location
    Pennsylvania, USA
    Posts
    10,908
    Rep Power
    6352
    You are...doing this wrong. you can't mix mysql and mysqli, and you shouldn't be double-performing these queries.

    More correct, though not perfect:

    PHP Code:
    $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());  
      } 
    HEY! YOU! Read the New User Guide and Forum Rules

    "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

    "The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

    Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.
  12. #7
  13. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,959
    Rep Power
    1014
    Wait a minute, what is that mysql_* stuff doing there? You cannot mix MySQLi with the old MySQL extension.

    You also need to seriously rethink your security concept. Your code is vulnerable to pretty much any attack known to man. If that site gets online, it won't take long until some skript kiddie has captured your server.
    The 6 worst sins of security ē How to (properly) access a MySQL database with PHP

    Why canít I use certain words like "drop" as part of my Security Question answers?
    There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".
  14. #8
  15. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    10
    Rep Power
    0

    Question Thanks to DantheManiac.. I got a little further... but still an issue


    Well I was able to get the email part to work, and it connects now.. but I am still missing something on line 17 of the code..

    Here is the error message:

    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.


    PHP Code:
    <?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($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 appsATaandstransportation.com
    $to 'appsATaandstransportation.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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
     </tr>


     <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
     </tr>

    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
     </tr>
    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
     </tr>

    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
     </tr>

    <td>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</td>



    <td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
    <td>&nbsp;</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 &amp; 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>&nbsp;</td>

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

     <td>&nbsp;</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); 
    ?>
  16. #9
  17. No Profile Picture
    I haz teh codez!
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Dec 2003
    Posts
    2,552
    Rep Power
    2337
    I ♥ ManiacDan & requinix

    This is a sig, and not necessarily a comment on the OP:
    Please don't be a help vampire!
  18. #10
  19. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,959
    Rep Power
    1014
    I see you've ignored all warnings regarding security. Well, I guess some people have to learn the hard way.
    The 6 worst sins of security ē How to (properly) access a MySQL database with PHP

    Why canít I use certain words like "drop" as part of my Security Question answers?
    There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".
  20. #11
  21. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    10
    Rep Power
    0

    Exclamation


    BTW... this is line 17..

    PHP Code:
    $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()); 
  22. #12
  23. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    10
    Rep Power
    0
    Figured out was missing $link on line 17.. see below..
    But now no error message and still it does not put anything into the database.. I am ready to pay.. who wants to fix this and how much? FRUSTRATED AND OVER IT!

    PHP Code:
    $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()); 
  24. #13
  25. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    10
    Rep Power
    0

    Question still stuck.. now no error message and Jaques.. the escape is there.. :) HELP


    Ok no error message at all, however it is still giving me an error because it is intended to drop the data from a few fields in this form into our database.. now the email portion of the form works great but I want to eliminate the data entry side of it.

    Can you please please pretty please help me get this done?
    Here is the updated code with all the additions and changes thanks to some help on this form and the other.

    PHP Code:
    <?php 
    //send data to sql database first

    $username="user name here";
    $password="pass here";
    $database="db name 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 ('{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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
     </tr>


     <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
     </tr>

    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
     </tr>
    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
     </tr>

    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
     </tr>

    <td>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</td>



    <td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
    <td>&nbsp;</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 &amp; 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>&nbsp;</td>

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

     <td>&nbsp;</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); 
    ?>
  26. #14
  27. No Profile Picture
    Dazed&Confused
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2002
    Location
    Tempe, AZ
    Posts
    506
    Rep Power
    128
    Originally Posted by TinaO
    PHP Code:
    <?php 
    //send data to sql database first

    $username="user name here";
    $password="pass here";
    $database="db name 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 ('{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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
     </tr>


     <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
     </tr>

    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
     </tr>
    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
     </tr>

    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
     </tr>

    <td>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</td>



    <td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
    <td>&nbsp;</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 &amp; 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>&nbsp;</td>

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

     <td>&nbsp;</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); 
    ?>
    Besides those variable names making me want to curl up into a fetal position and cry, you haven't updated your query with them; you still have $_POST[foo].
  28. #15
  29. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    10
    Rep Power
    0
    Originally Posted by dmittner
    Besides those variable names making me want to curl up into a fetal position and cry, you haven't updated your query with them; you still have $_POST[foo].
    I am not clear on what you mean.. not being a coder.. can you spell it out as in an example for one field for me please?

    Oh.. don't I know how bad those names suck, and I did not create the original form.. only wanted to edit it to link the data to the database.. the idiot that created it sucks and did a horrid job as there were originally so many errors in this code it was rediculas.. I am just playing clean up here. I am not a coder, just learning really, graphic animation, modeling.. that is my thing..

    Thanks for your help...
    Here is the updated code so far..

    PHP Code:
    <?php 
    //send data to sql database first

    $username="username 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 (
    '{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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
     </tr>


     <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td>  
     </tr>

    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td>  
     </tr>
    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td>  
     </tr>

    <td>&nbsp;</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 &amp; alcohol testing?: </td><td>'
    .$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td>  
     </tr>

    <td>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</td>



    <td> <h3>  <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> 
    <td>&nbsp;</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 &amp; 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>&nbsp;</td>

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

     <td>&nbsp;</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); 
    ?>
    Here is error message I am getting now..
    Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home2/astrans/public_html/employment/contact_action_contact.php on line 54
    Error:
Page 1 of 2 12 Last
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo