TinaOConnell

Members

View Profile See their activity

Posts
30
Joined
June 18, 2013
Last visited
June 19, 2013

TinaOConnell's Achievements

Newbie (1/5)

Reputation

Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

SOLVED.. WAS MISSING ONE LITTLE ' !!!! WHAT A HOT MESS.. GLAD IT IS DONE.. FOR THOSE OF YOU HAVING THIS SAME ISSUE.. HERE IS MY FINAL WORKING CODE WITH NO ERRORS YEAH!!!!!!! <?php //send data to sql database first $username="USERNAME HERE"; $password="PASSWORD HERE"; $database="DB HERE"; $server="IP ADDRESS 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($link)); } //now send email $to = 'PUT EMAIL ADDRESS TO SEND THIS FORM TO HERE'; $from = $_POST['ApplicantName']; // $status = $_POST['Project_status']; /* subject */ $subject = "Application For Employment Web Submission"; /* message */ $message = '<html> <head> <title>Application For Employment Web Submission</title> </head> <body> <p>Dear '.$to.',</p> <table> <tr> <td colspan="2">"Employment Application Details:"</td> </tr><tr> <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td> </tr> <tr> <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td> </tr><tr> <td>Company: </td><td>'.$_POST['Company'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['Address'].'</td> </tr><tr> <td>Signature: </td><td>'.$_POST['Signature1'].'</td> </tr><tr> <td>Date: </td><td>'.$_POST['Date'].'</td> </tr> <tr> <td></h3><strong> FOR COMPANY USE</strong> </h3></td> </tr> <td> </td> <tr> <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td> </tr> <tr> <td>District: </td><td>'.$_POST['District'].'</td> </tr> <tr> <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td> </tr> <tr> <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td> </tr> <tr> <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td> </tr> <td> </td> <tr> </h3> <strong> <td>APPLICANT TO COMPLETE</h3></strong></td> </tr> <tr> <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td> </tr><tr> <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td> </tr><tr> <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td> </tr><tr> <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td> </tr><tr> <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td> </tr><tr> <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Current<br /> Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Previous Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td> </tr> <td> </td> <tr> <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td> </tr><tr> <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td> </tr><tr> <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td> </tr><tr> <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td> </tr><tr> <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td> </tr> <tr> <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td> </tr><tr> <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td> </tr><tr> <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td> </tr> <td> </td> <tr> <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td> </tr> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> <td> </td> <tr> <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td> </tr> <td> </td> <td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> <tr> <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td> </tr> <tr> <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td> </tr><tr> <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td> </tr><tr> <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td> </tr><tr> <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td> </tr> <tr> <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td> </tr><tr> <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td> </tr><tr> <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td> </tr><tr> <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td> </tr><tr> <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td> </tr><tr> <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td> </tr> <td> </td> <td> <h3> <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> <td> </td> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License1'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License2'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License3'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td> </tr> <tr> <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td> </tr> <tr> <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td> </tr> <tr> <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td> </tr> <td> </td> <tr> <td>Signature: </td><td>'.$_POST['Signature'].'</td> </tr> <tr> <td>Date: </td><td>'.$_POST['Date1'].'</td> </tr> <td> </td> </tr> </table> </body> </html>'; /* To send HTML mail, set the Content-type header. */ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: " . $from . "\r\n"; /* and now mail it */ /*echo $message; die;*/ @mail($to, $subject, $message, $headers); echo "<h4>Your message has been sent to us with your full application details.<br /> <span>We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment.</span></h4>"; mysqli_close($link); ?> THANK YOU SO MUCH FOR ALL CODERS WHO HELPED.. PROBLEM SOLVED!!!
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

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

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

besides.. I tried that too and getting the same error message now.. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{APPLICANT_TO_COMPLETE_LastName}', '{DateofApplication}', '{APPLICANT_TO_COMPL' at line 13
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

Miko, I tried that four posts ago.. and I got help from another coder who provided that update.. which eliminated one of the error messages.. AT THIS POINT.. I want to be done.. this is something that I would like to hire out to be done.. HOW MUCH ?? ANYONE??
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

I think I understand.. his idea would be better and faster but I already did your suggestion.. so.. here goes.. I am still getting NO ERROR MESSAGE but the data is not going into the database AT ALL!!! It is connecting per the log on my cpanel.. but nothing is happening after that. I checked the names of each field.. checked EVERYTHING.. I need to be done with this project. Can you please help me.. Here is the code I am left with.. <?php //send data to sql database first $username="user"; $password="pass"; $database="db"; $server="ip"; $link=mysqli_connect ($server, $username, $password); if (!$link) { die('Could not connect: ' . mysqli_error()); } mysqli_select_db( $link, $database); $APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_FirstName']); $APPLICANT_TO_COMPLETE_LastName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_LastName']); $DateofApplication = mysqli_real_escape_string($link, $_POST['DateofApplication']); $APPLICANT_TO_COMPLETE_PhoneNumber = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_PhoneNumber']); $APPLICANT_TO_COMPLETE_SecondaryPhone = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_SecondaryPhone']); $License1 = mysqli_real_escape_string($link, $_POST['License1']); $APPLICANT_TO_COMPLETE_CurrentAddress = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentAddress']); $APPLICANT_TO_COMPLETE_CurrentCity = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentCity']); $APPLICANT_TO_COMPLETE_CurrentState = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentState']); $APPLICANT_TO_COMPLETE_CurrentZip = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentZip']); $result = mysqli_query($link, "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('{APPLICANT_TO_COMPLETE_FirstName},'{APPLICANT_TO_COMPLETE_LastName}','{DateofApplication}','{APPLICANT_TO_COMPLETE_PhoneNumber}','{APPLICANT_TO_COMPLETE_SecondaryPhone}','{License1}','{APPLICANT_TO_COMPLETE_CurrentAddress}','{APPLICANT_TO_COMPLETE_CurrentCity}','{APPLICANT_TO_COMPLETE_CurrentState}','{APPLICANT_TO_COMPLETE_CurrentZip}'"); if (!result) { die('Error: ' . mysqli_error()); } //now send email to applications@aandstransportation.com $to = 'applications@aandstransportation.com'; $from = $_POST['ApplicantName']; // $status = $_POST['Project_status']; /* subject */ $subject = "Application For Employment Web Submission"; /* message */ $message = '<html> <head> <title>Application For Employment Web Submission</title> </head> <body> <p>Dear '.$to.',</p> <table> <tr> <td colspan="2">"Employment Application Details:"</td> </tr><tr> <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td> </tr> <tr> <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td> </tr><tr> <td>Company: </td><td>'.$_POST['Company'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['Address'].'</td> </tr><tr> <td>Signature: </td><td>'.$_POST['Signature1'].'</td> </tr><tr> <td>Date: </td><td>'.$_POST['Date'].'</td> </tr> <tr> <td></h3><strong> FOR COMPANY USE</strong> </h3></td> </tr> <td> </td> <tr> <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td> </tr> <tr> <td>District: </td><td>'.$_POST['District'].'</td> </tr> <tr> <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td> </tr> <tr> <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td> </tr> <tr> <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td> </tr> <td> </td> <tr> </h3> <strong> <td>APPLICANT TO COMPLETE</h3></strong></td> </tr> <tr> <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td> </tr><tr> <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td> </tr><tr> <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td> </tr><tr> <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td> </tr><tr> <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td> </tr><tr> <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Current<br /> Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Previous Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td> </tr> <td> </td> <tr> <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td> </tr><tr> <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td> </tr><tr> <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td> </tr><tr> <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td> </tr><tr> <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td> </tr> <tr> <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td> </tr><tr> <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td> </tr><tr> <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td> </tr> <td> </td> <tr> <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td> </tr> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> <td> </td> <tr> <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td> </tr> <td> </td> <td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> <tr> <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td> </tr> <tr> <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td> </tr><tr> <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td> </tr><tr> <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td> </tr><tr> <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td> </tr> <tr> <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td> </tr><tr> <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td> </tr><tr> <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td> </tr><tr> <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td> </tr><tr> <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td> </tr><tr> <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td> </tr> <td> </td> <td> <h3> <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> <td> </td> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License1'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License2'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License3'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td> </tr> <tr> <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td> </tr> <tr> <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td> </tr> <tr> <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td> </tr> <td> </td> <tr> <td>Signature: </td><td>'.$_POST['Signature'].'</td> </tr> <tr> <td>Date: </td><td>'.$_POST['Date1'].'</td> </tr> <td> </td> </tr> </table> </body> </html>'; /* To send HTML mail, set the Content-type header. */ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: " . $from . "\r\n"; /* and now mail it */ /*echo $message; die;*/ @mail($to, $subject, $message, $headers); echo "<h4>Your message has been sent to us with your full application details.<br /> <span>We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment.</span></h4>"; mysqli_close($link); ?> Please any suggestions are welcome.. this is something that should be simple.. not sure why it takes 4 advanced programmers to help and still does not work.. I know the code started as a hot mess but I always believed php to be more forgiving.. I guess no code is forgiving at all.. Please help. Thanks, Tina
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

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

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

OK.. did these changes.. tested.. and here is the result.. NO ERROR MESSAGE NOW.. and here is the code.. email works but does not send the data to the database.. HELP.. I am so lost.. anyone want to trade some work out.. design for programming to get this off my desk?? <?php //send data to sql database first $username="user"; $password="pass"; $database="db name here"; $server="ip"; $link=mysqli_connect ($server, $username, $password); if (!$link) { die('Could not connect: ' . mysqli_error()); } mysqli_select_db( $link, $database); $APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_FirstName']); $APPLICANT_TO_COMPLETE_LastName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_LastName']); $DateofApplication = mysqli_real_escape_string($link, $_POST['DateofApplication']); $APPLICANT_TO_COMPLETE_PhoneNumber = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_PhoneNumber']); $APPLICANT_TO_COMPLETE_SecondaryPhone = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_SecondaryPhone']); $License1 = mysqli_real_escape_string($link, $_POST['License1']); $APPLICANT_TO_COMPLETE_CurrentAddress = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentAddress']); $APPLICANT_TO_COMPLETE_CurrentCity = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentCity']); $APPLICANT_TO_COMPLETE_CurrentState = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentState']); $APPLICANT_TO_COMPLETE_CurrentZip = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentZip']); $result = mysqli_query($link, "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); if (!result) { die('Error: ' . mysqli_error()); } //now send email to applications@aandstransportation.com $to = 'applications@aandstransportation.com'; $from = $_POST['ApplicantName']; // $status = $_POST['Project_status']; /* subject */ $subject = "Application For Employment Web Submission"; /* message */ $message = '<html> <head> <title>Application For Employment Web Submission</title> </head> <body> <p>Dear '.$to.',</p> <table> <tr> <td colspan="2">"Employment Application Details:"</td> </tr><tr> <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td> </tr> <tr> <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td> </tr><tr> <td>Company: </td><td>'.$_POST['Company'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['Address'].'</td> </tr><tr> <td>Signature: </td><td>'.$_POST['Signature1'].'</td> </tr><tr> <td>Date: </td><td>'.$_POST['Date'].'</td> </tr> <tr> <td></h3><strong> FOR COMPANY USE</strong> </h3></td> </tr> <td> </td> <tr> <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td> </tr> <tr> <td>District: </td><td>'.$_POST['District'].'</td> </tr> <tr> <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td> </tr> <tr> <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td> </tr> <tr> <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td> </tr> <td> </td> <tr> </h3> <strong> <td>APPLICANT TO COMPLETE</h3></strong></td> </tr> <tr> <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td> </tr><tr> <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td> </tr><tr> <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td> </tr><tr> <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td> </tr><tr> <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td> </tr><tr> <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Current<br /> Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Previous Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td> </tr> <td> </td> <tr> <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td> </tr><tr> <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td> </tr><tr> <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td> </tr><tr> <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td> </tr><tr> <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td> </tr> <tr> <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td> </tr><tr> <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td> </tr><tr> <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td> </tr> <td> </td> <tr> <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td> </tr> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> <td> </td> <tr> <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td> </tr> <td> </td> <td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> <tr> <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td> </tr> <tr> <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td> </tr><tr> <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td> </tr><tr> <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td> </tr><tr> <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td> </tr> <tr> <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td> </tr><tr> <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td> </tr><tr> <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td> </tr><tr> <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td> </tr><tr> <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td> </tr><tr> <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td> </tr> <td> </td> <td> <h3> <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> <td> </td> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License1'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License2'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License3'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td> </tr> <tr> <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td> </tr> <tr> <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td> </tr> <tr> <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td> </tr> <td> </td> <tr> <td>Signature: </td><td>'.$_POST['Signature'].'</td> </tr> <tr> <td>Date: </td><td>'.$_POST['Date1'].'</td> </tr> <td> </td> </tr> </table> </body> </html>'; /* To send HTML mail, set the Content-type header. */ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: " . $from . "\r\n"; /* and now mail it */ /*echo $message; die;*/ @mail($to, $subject, $message, $headers); echo "<h4>Your message has been sent to us with your full application details.<br /> <span>We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment.</span></h4>"; mysqli_close($link); ?> Thanks everyone who has been helping thus far.. really thank you bunches!!
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

Miko.. Here goes.. does this look ok? <?php //send data to sql database first $username="user here"; $password="pass here"; $database="db here"; $server="ip here"; $link=mysqli_connect ($server, $username, $password); if (!$link) { die('Could not connect: ' . mysqli_error()); } mysqli_select_db($link, $database); $APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_FirstName']); $APPLICANT_TO_COMPLETE_LastName = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_LastName']); $DateofApplication = mysqli_real_escape_string($link, $_POST['DateofApplication']); $APPLICANT_TO_COMPLETE_PhoneNumber = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_PhoneNumber']); $APPLICANT_TO_COMPLETE_SecondaryPhone = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_SecondaryPhone']); $License1 = mysqli_real_escape_string($link, $_POST['License1']); $APPLICANT_TO_COMPLETE_CurrentAddress = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentAddress']); $APPLICANT_TO_COMPLETE_CurrentCity = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentCity']); $APPLICANT_TO_COMPLETE_CurrentState = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentState']); $APPLICANT_TO_COMPLETE_CurrentZip = mysqli_real_escape_string($link, $_POST['APPLICANT_TO_COMPLETE_CurrentZip']); $result = mysqli_query($link, "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); if (!result) { die('Error: ' . mysqli_error()); } //now send email to applications@aandstransportation.com $to = 'applications@aandstransportation.com'; $from = $_POST['ApplicantName']; // $status = $_POST['Project_status']; /* subject */ $subject = "Application For Employment Web Submission"; /* message */ $message = '<html> <head> <title>Application For Employment Web Submission</title> </head> <body> <p>Dear '.$to.',</p> <table> <tr> <td colspan="2">"Employment Application Details:"</td> </tr><tr> <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td> </tr> <tr> <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td> </tr><tr> <td>Company: </td><td>'.$_POST['Company'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['Address'].'</td> </tr><tr> <td>Signature: </td><td>'.$_POST['Signature1'].'</td> </tr><tr> <td>Date: </td><td>'.$_POST['Date'].'</td> </tr> <tr> <td></h3><strong> FOR COMPANY USE</strong> </h3></td> </tr> <td> </td> <tr> <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td> </tr> <tr> <td>District: </td><td>'.$_POST['District'].'</td> </tr> <tr> <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td> </tr> <tr> <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td> </tr> <tr> <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td> </tr> <td> </td> <tr> </h3> <strong> <td>APPLICANT TO COMPLETE</h3></strong></td> </tr> <tr> <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td> </tr><tr> <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td> </tr><tr> <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td> </tr><tr> <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td> </tr><tr> <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td> </tr><tr> <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Current<br /> Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Previous Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td> </tr> <td> </td> <tr> <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td> </tr><tr> <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td> </tr><tr> <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td> </tr><tr> <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td> </tr><tr> <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td> </tr> <tr> <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td> </tr><tr> <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td> </tr><tr> <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td> </tr> <td> </td> <tr> <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td> </tr> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> <td> </td> <tr> <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td> </tr> <td> </td> <td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> <tr> <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td> </tr> <tr> <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td> </tr><tr> <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td> </tr><tr> <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td> </tr><tr> <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td> </tr> <tr> <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td> </tr><tr> <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td> </tr><tr> <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td> </tr><tr> <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td> </tr><tr> <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td> </tr><tr> <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td> </tr> <td> </td> <td> <h3> <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> <td> </td> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License1'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License2'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License3'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td> </tr> <tr> <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td> </tr> <tr> <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td> </tr> <tr> <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td> </tr> <td> </td> <tr> <td>Signature: </td><td>'.$_POST['Signature'].'</td> </tr> <tr> <td>Date: </td><td>'.$_POST['Date1'].'</td> </tr> <td> </td> </tr> </table> </body> </html>'; /* To send HTML mail, set the Content-type header. */ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: " . $from . "\r\n"; /* and now mail it */ /*echo $message; die;*/ @mail($to, $subject, $message, $headers); echo "<h4>Your message has been sent to us with your full application details.<br /> <span>We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment.</span></h4>"; mysqli_close($link); ?>
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

I started by removing just the @ symbol and tested.. got another error message.. trying the other steps now.. here is the error message.. Warning: mysqli_select_db() expects parameter 1 to be mysqli, string given in/home2/astrans/public_html/employment/contact_action_contact.php on line 15
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

For escape strings... Should it be like this for each field on the form or each field on the database??? $APPLICANT_TO_COMPLETE_FirstName = $_POST['APPLICANT_TO_COMPLETE_FirstName]; $APPLICANT_TO_COMPLETE_FirstName = mysqli_real_escape_string($APPLICANT_TO_COMPLETE_FirstName); ??? And this goes under line 17? or after each field??? does it matter where it goes??? Thanks, Tina
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

Kicken, I tried it with the port number.. with it I get the cannot connect error.. I tried it without the port number and it works, I have no error message now however it is not putting the data into the database at all.. Not sure why. I don't understand mysqli_real_escape_string(). enough to do that yet.. I will but I will wait till I get the basics working and backed up and then add that to the script.. Now no error message BUT NOT PUTTING DATA into table from the employment application. Here is the code now: <?php //send data to sql database first $username="username"; $password="pass"; $database="database name"; $server="ip"; $link=mysqli_connect ($server, $username, $password); if (!$link) { die('Could not connect: ' . mysqli_error()); } @mysqli_select_db($database, $link); $result = mysqli_query($link, "INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); if (!result) { die('Error: ' . mysqli_error()); } //now send email to applications@aandstransportation.com $to = 'applications@aandstransportation.com'; $from = $_POST['ApplicantName']; // $status = $_POST['Project_status']; /* subject */ $subject = "Application For Employment Web Submission"; /* message */ $message = '<html> <head> <title>Application For Employment Web Submission</title> </head> <body> <p>Dear '.$to.',</p> <table> <tr> <td colspan="2">"Employment Application Details:"</td> </tr><tr> <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td> </tr> <tr> <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td> </tr><tr> <td>Company: </td><td>'.$_POST['Company'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['Address'].'</td> </tr><tr> <td>Signature: </td><td>'.$_POST['Signature1'].'</td> </tr><tr> <td>Date: </td><td>'.$_POST['Date'].'</td> </tr> <tr> <td></h3><strong> FOR COMPANY USE</strong> </h3></td> </tr> <td> </td> <tr> <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td> </tr> <tr> <td>District: </td><td>'.$_POST['District'].'</td> </tr> <tr> <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td> </tr> <tr> <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td> </tr> <tr> <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td> </tr> <td> </td> <tr> </h3> <strong> <td>APPLICANT TO COMPLETE</h3></strong></td> </tr> <tr> <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td> </tr><tr> <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td> </tr><tr> <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td> </tr><tr> <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td> </tr><tr> <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td> </tr><tr> <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Current<br /> Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Previous Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td> </tr> <td> </td> <tr> <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td> </tr><tr> <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td> </tr><tr> <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td> </tr><tr> <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td> </tr><tr> <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td> </tr> <tr> <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td> </tr><tr> <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td> </tr><tr> <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td> </tr> <td> </td> <tr> <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td> </tr> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> <td> </td> <tr> <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td> </tr> <td> </td> <td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> <tr> <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td> </tr> <tr> <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td> </tr><tr> <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td> </tr><tr> <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td> </tr><tr> <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td> </tr> <tr> <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td> </tr><tr> <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td> </tr><tr> <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td> </tr><tr> <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td> </tr><tr> <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td> </tr><tr> <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td> </tr> <td> </td> <td> <h3> <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> <td> </td> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License1'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License2'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License3'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td> </tr> <tr> <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td> </tr> <tr> <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td> </tr> <tr> <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td> </tr> <td> </td> <tr> <td>Signature: </td><td>'.$_POST['Signature'].'</td> </tr> <tr> <td>Date: </td><td>'.$_POST['Date1'].'</td> </tr> <td> </td> </tr> </table> </body> </html>'; /* To send HTML mail, set the Content-type header. */ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: " . $from . "\r\n"; /* and now mail it */ /*echo $message; die;*/ @mail($to, $subject, $message, $headers); echo "<h4>Your message has been sent to us with your full application details.<br /> <span>We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment.</span></h4>"; mysqli_close($link); ?> Thanks, Tina
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

Actually I found out having the port there at all is part of the issue.. per another forum... tried this code below and now have only one small issue which is a warning!!! Error is: Warning: mysqli_query() expects at least 2 parameters, 1 given in/home2/astrans/public_html/employment/contact_action_contact.php on line 17 Your message has been sent to us with your full application details. We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment. Code is: <?php //send data to sql database first $username="school_ast"; $password="maryia11"; $database="school_1"; $server="50.97.101.236"; $link=mysqli_connect ($server, $username, $password); if (!$link) { die('Could not connect: ' . mysqli_error()); } @mysqli_select_db($database, $link); $result = mysqli_query("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); if (!result) { die('Error: ' . mysqli_error()); } //now send email to applications@aandstransportation.com $to = 'applications@aandstransportation.com'; $from = $_POST['ApplicantName']; // $status = $_POST['Project_status']; /* subject */ $subject = "Application For Employment Web Submission"; /* message */ $message = '<html> <head> <title>Application For Employment Web Submission</title> </head> <body> <p>Dear '.$to.',</p> <table> <tr> <td colspan="2">"Employment Application Details:"</td> </tr><tr> <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td> </tr> <tr> <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td> </tr><tr> <td>Company: </td><td>'.$_POST['Company'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['Address'].'</td> </tr><tr> <td>Signature: </td><td>'.$_POST['Signature1'].'</td> </tr><tr> <td>Date: </td><td>'.$_POST['Date'].'</td> </tr> <tr> <td></h3><strong> FOR COMPANY USE</strong> </h3></td> </tr> <td> </td> <tr> <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td> </tr> <tr> <td>District: </td><td>'.$_POST['District'].'</td> </tr> <tr> <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td> </tr> <tr> <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td> </tr> <tr> <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td> </tr> <td> </td> <tr> </h3> <strong> <td>APPLICANT TO COMPLETE</h3></strong></td> </tr> <tr> <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td> </tr><tr> <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td> </tr><tr> <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td> </tr><tr> <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td> </tr><tr> <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td> </tr><tr> <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Current<br /> Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Previous Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td> </tr> <td> </td> <tr> <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td> </tr><tr> <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td> </tr><tr> <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td> </tr><tr> <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td> </tr><tr> <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td> </tr> <tr> <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td> </tr><tr> <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td> </tr><tr> <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td> </tr> <td> </td> <tr> <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td> </tr> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> <td> </td> <tr> <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td> </tr> <td> </td> <td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> <tr> <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td> </tr> <tr> <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td> </tr><tr> <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td> </tr><tr> <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td> </tr><tr> <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td> </tr> <tr> <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td> </tr><tr> <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td> </tr><tr> <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td> </tr><tr> <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td> </tr><tr> <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td> </tr><tr> <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td> </tr> <td> </td> <td> <h3> <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> <td> </td> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License1'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License2'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License3'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td> </tr> <tr> <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td> </tr> <tr> <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td> </tr> <tr> <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td> </tr> <td> </td> <tr> <td>Signature: </td><td>'.$_POST['Signature'].'</td> </tr> <tr> <td>Date: </td><td>'.$_POST['Date1'].'</td> </tr> <td> </td> </tr> </table> </body> </html>'; /* To send HTML mail, set the Content-type header. */ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: " . $from . "\r\n"; /* and now mail it */ /*echo $message; die;*/ @mail($to, $subject, $message, $headers); echo "<h4>Your message has been sent to us with your full application details.<br /> <span>We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment.</span></h4>"; mysqli_close($link); ?> Help.. just on line 17 please ???? Almost done!!!
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

I think that helped putting the port on a separate line.. seemed to connect now but has one more error message.. Here is the new error: Warning: mysqli_query() expects at least 2 parameters, 1 given in/home2/astrans/public_html/employment/contact_action_contact.php on line 16 Warning: mysql_query() expects parameter 2 to be resource, object given in/home2/astrans/public_html/employment/contact_action_contact.php on line 18 Error: Here is the updated code: <?php //send data to sql database first $username="USER HERE"; $password="PASS HERE"; $database="DB HERE"; $server="IP HERE"; $port="PORT HERE"; $link=mysqli_connect ($server, $port, $username, $password); if (!$link) { die('Could not connect: ' . mysqli_error()); } @mysqli_select_db($database, $link); $result = mysqli_query("INSERT INTO Driver_applicants (FirstName, LastName, Applicationdate, Phone, AltPhone, DL, StreetAddress, City, State, Zip) VALUES ('$_POST[APPLICANT_TO_COMPLETE_FirstName]','$_POST[APPLICANT_TO_COMPLETE_LastName]','$_POST[DateofApplication]','$_POST[APPLICANT_TO_COMPLETE_PhoneNumber]','$_POST[APPLICANT_TO_COMPLETE_SecondaryPhone]','$_POST[License1]','$_POST[APPLICANT_TO_COMPLETE_CurrentAddress]','$_POST[APPLICANT_TO_COMPLETE_CurrentCity]','$_POST[APPLICANT_TO_COMPLETE_CurrentState]','$_POST[APPLICANT_TO_COMPLETE_CurrentZip]'"); if (!mysqli_query($mysql_query,$link)) { die('Error: ' . mysqli_error()); } //now send email to applications@aandstransportation.com $to = 'applications@aandstransportation.com'; $from = $_POST['ApplicantName']; // $status = $_POST['Project_status']; /* subject */ $subject = "Application For Employment Web Submission"; /* message */ $message = '<html> <head> <title>Application For Employment Web Submission</title> </head> <body> <p>Dear '.$to.',</p> <table> <tr> <td colspan="2">"Employment Application Details:"</td> </tr><tr> <td>Applicant Name: </td><td>'.$_POST['ApplicantName'].'</td> </tr> <tr> <td>Date of Application: </td><td>'.$_POST['DateofApplication'].'</td> </tr><tr> <td>Company: </td><td>'.$_POST['Company'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['Address'].'</td> </tr><tr> <td>Signature: </td><td>'.$_POST['Signature1'].'</td> </tr><tr> <td>Date: </td><td>'.$_POST['Date'].'</td> </tr> <tr> <td></h3><strong> FOR COMPANY USE</strong> </h3></td> </tr> <td> </td> <tr> <td>APPLICANT HIRED: </td><td>'.$_POST['APPLICANTHIRED'].'</td> </tr> <tr> <td>District: </td><td>'.$_POST['District'].'</td> </tr> <tr> <td>DATE EMPLOYED: </td><td>'.$_POST['DATEEMPLOYED'].'</td> </tr> <tr> <td>Interviewing Manager: </td><td>'.$_POST['InterviewingManager'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['InterviewingManager_Signature'].'</td> </tr> <tr> <td>Human Resources: </td><td>'.$_POST['HumanResources'].'</td> </tr> <tr> <td>Signature: </td><td>'.$_POST['HumanResources_Signature'].'</td> </tr> <td> </td> <tr> </h3> <strong> <td>APPLICANT TO COMPLETE</h3></strong></td> </tr> <tr> <td>LastName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_LastName'].'</td> </tr><tr> <td>FirstName: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_FirstName'].'</td> </tr><tr> <td>SSN: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SSN'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PhoneNumber'].'</td> </tr><tr> <td>Secondary Phone: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_SecondaryPhone'].'</td> </tr><tr> <td>Position(s) applied for: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Position_applied__for'].'</td> </tr><tr> <td>Rate of pay expected: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_Rate_of_pay_expected'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Current<br /> Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentAddress'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentCity'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentState'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentZip'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_CurrentHowLong'].'</td> </tr> <td> </td> <tr> <td></h3> <strong>Previous Addresses</strong></h3></td> </tr> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip1'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong1'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip2'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong2'].'</td> </tr> <td> </td> <tr> <td>Address: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousAddress3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousCity3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousState3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousZip3'].'</td> </tr><tr> <td>How Long?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousHowLong3'].'</td> </tr> <td> </td> <tr> <td>Do you have the legal right to work in the United States? : </td><td>'.$_POST['Do_you_have_the_legal_right_to_work_in_the_United_States'].'</td> </tr><tr> <td>Date of Birth: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousDate_of_Birth'].'</td> </tr><tr> <td>Can you provide proof of age?: </td><td>'.$_POST['Can_you_provide_proof_of_age'].'</td> </tr><tr> <td>Have you worked for this company before?: </td><td>'.$_POST['Have_you_worked_for_this_company_before'].'</td> </tr><tr> <td>Where?: </td><td>'.$_POST['APPLICANT_TO_COMPLETE_PreviousWhere'].'</td> </tr> <tr> <td>Are you currently employed?: </td><td>'.$_POST['Are_you_currently_employed'].'</td> </tr><tr> <td>How were you referred to the company?: </td><td>'.$_POST['How_were_you_referred_to_the_company'].'</td> </tr><tr> <td>If yes, explain if you wish: </td><td>'.$_POST['If_yes_explain_if_you_wish'].'</td> </tr> <td> </td> <tr> <td><h3><strong>EMPLOYMENT HISTORY</strong></h3></td> </tr> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer1'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom1'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To1'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address1'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City1'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State1'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip1'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson1'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber1'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld1'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage1'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving1'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed1'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing1'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer2'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom2'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To2'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address2'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City2'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State2'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip2'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson2'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber2'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld2'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage2'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving2'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed2'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing2'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer3'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom3'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To3'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address3'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City3'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State3'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip3'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson3'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber3'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld3'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage3'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving3'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed3'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing3'].'</td> </tr> <td> </td> <tr> <td>Employer: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employer4'].'</td> </tr><tr> <td>Employed from: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Employedfrom4'].'</td> </tr><tr> <td>To: </td><td>'.$_POST['EMPLOYMENT_HISTORY_To4'].'</td> </tr><tr> <td>Address: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Address4'].'</td> </tr><tr> <td>City: </td><td>'.$_POST['EMPLOYMENT_HISTORY_City4'].'</td> </tr><tr> <td>State: </td><td>'.$_POST['EMPLOYMENT_HISTORY_State4'].'</td> </tr><tr> <td>Zip: </td><td>'.$_POST['EMPLOYMENT_HISTORY_Zip4'].'</td> </tr><tr> <td>Contact Person: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ContactPerson4'].'</td> </tr><tr> <td>Phone Number: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PhoneNumber4'].'</td> </tr><tr> <td>Position Held: </td><td>'.$_POST['EMPLOYMENT_HISTORY_PositionHeld4'].'</td> </tr><tr> <td>Salary/Wage: </td><td>'.$_POST['EMPLOYMENT_HISTORY_SalaryWage4'].'</td> </tr><tr> <td>Reason For Leaving: </td><td>'.$_POST['EMPLOYMENT_HISTORY_ReasonForLeaving4'].'</td> </tr><tr> <td>Were you subject to FMCSRs* (DOT regulations) while employed: </td><td>'.$_POST['Were_you_subject_to_FMCSRs_DOT_regulations_while_employed4'].'</td> </tr><tr> <td>Were you subject to DOT drug & alcohol testing?: </td><td>'.$_POST['Were_you_subject_to_DOT_drug_alcohol_testing'].'</td> </tr> <td> </td> <td><h3><strong>ACCIDENT RECORD</strong> for past 3 years or more (attach sheet if more space is required). If non, write none.</h3></td> <td> </td> <tr> <td>Last Accident: </td><td>'.$_POST['Last_Accident1'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous11'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous12'].'</td> </tr> <td> </td> <td><h3><strong>TRAFFIC CONVICTIONS</strong> and forfeitures for the past 3 years (other than parking violations). If none, write none.</h3></td> <tr> <td>Last Violation: </td><td>'.$_POST['Last_Accident2'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous21'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous22'].'</td> </tr><tr> <td>Next Previous: </td><td>'.$_POST['Next_Previous23'].'</td> </tr> <tr> <td>Have you EVER been convicted of a DUI, DWI and/or DUBAL?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_DUI_DWI_and_or_DUBAL'].'</td> </tr><tr> <td>Have you EVER been convicted for reckless driving?: </td><td>'.$_POST['Have_you_EVER_been_convicted_for_reckless_driving'].'</td> </tr><tr> <td>Have you EVER been convicted of fleeing or attempting to elude a police officer?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_fleeing_or_attempting_to_elude_a_police_officer'].'</td> </tr><tr> <td>Have you EVER been convicted of leaving the scene of an accident?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_leaving_the_scene_of_an_accident'].'</td> </tr> <tr> <td>Have you EVER been convicted of a railroad crossing violation?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_a_railroad_crossing_violation'].'</td> </tr><tr> <td>Have you EVER been convicted of passing a school bus while it is unloading or loading?: </td><td>'.$_POST['Have_you_EVER_been_convicted_of_passing_a_school_bus_while_it_is_unloading_or_loading'].'</td> </tr><tr> <td>Has your license EVER been suspended or revoked?: </td><td>'.$_POST['Has_your_license_EVER_been_suspended_or_revoked'].'</td> </tr><tr> <td>If so, please explain:: </td><td>'.$_POST['If_yes_explain_if_you_wish1'].'</td> </tr><tr> <td>Have you ever been convicted of a felony?: </td><td>'.$_POST['Have_you_ever_been_convicted_of_a_felony'].'</td> </tr><tr> <td>If so, please explain: </td><td>'.$_POST['If_yes_explain_if_you_wish2'].'</td> </tr> <td> </td> <td> <h3> <strong>EXPERIENCE AND QUALIFICATIONS - DRIVER</strong></h3></td> <td> </td> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State1'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License1'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements1'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration1'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State2'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License2'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements2'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration2'].'</td> </tr> <tr> <td>State: </td><td>'.$_POST['Listalldriverlicenses_State3'].'</td> </tr><tr> <td>Licence: </td><td>'.$_POST['License3'].'</td> </tr><tr> <td>Class/Endorsements: </td><td>'.$_POST['Class_Endorsements3'].'</td> </tr><tr> <td>Expiration: </td><td>'.$_POST['Expiration3'].'</td> </tr> <tr> <td>A. Have you ever been denied a licens, permit or privilege to operate a motor vehicle?: </td><td>'.$_POST['Have_you_ever_been_denied_a_license'].'</td> </tr> <tr> <td>Please list any other driving experience (equipment type & approximate dates/miles driven): </td><td>'.$_POST['If_yes_explain_if_you_wish3'].'</td> </tr> <tr> <td><strong>Education </strong>listing highest grade completed and any degrees earned </td><td>'.$_POST['listing_highest_grade_completed_and_any_degrees_earned'].'</td> </tr> <td> </td> <tr> <td>Signature: </td><td>'.$_POST['Signature'].'</td> </tr> <tr> <td>Date: </td><td>'.$_POST['Date1'].'</td> </tr> <td> </td> </tr> </table> </body> </html>'; /* To send HTML mail, set the Content-type header. */ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: " . $from . "\r\n"; /* and now mail it */ /*echo $message; die;*/ @mail($to, $subject, $message, $headers); echo "<h4>Your message has been sent to us with your full application details.<br /> <span>We will reply soon as soon as possible to follow up with you on our hiring process. Thank you for considering A&S Transportation, Inc. for employment.</span></h4>"; mysqli_close($link); ?> Can you help with this new error? Thank you all so much for all you have done so far to help me on this. I am sorry for presenting such a monster code.. What a stinker.
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

I have the form on one site.. www.aandstransportation.com/employment and the database on another site.. www.bigschoolbus.com I believe that is part of the problem here.. but I have whitelisted both sites on the other's cpanel under Remote Mysql.. any other suggestions?
Help, Pretty Please stuck

TinaOConnell replied to TinaOConnell's topic in PHP Coding Help

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

Sign In

TinaOConnell

Posts

Joined

Last visited

TinaOConnell's Achievements

Newbie (1/5)

Reputation

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Help, Pretty Please stuck

Browse

Activity

Important Information