this is the line that data assist creates for the insert values:
$WA_fieldValuesStr = "".((isset($_POST["firstName"]))?$_POST["firstName"]:"") ."" . "|" . "".((isset($_POST["lastName"]))?$_POST["lastName"]:"") ."" . "|" . "".((isset($_POST["date"]))?$_POST["date"]:"") ."" . "|" . "".((isset($_POST["presentAdd"]))?$_POST["presentAdd"]:"") ."" . "|" . "".((isset($_POST["presentCity"]))?$_POST["presentCity"]:"") ."" . "|" . "".((isset($_POST["presentState"]))?$_POST["presentState"]:"") ."" . "|" . "".((isset($_POST["presentZip"]))?$_POST["presentZip"]:"") ."" . "|" . "".((isset($_POST["permAdd"]))?$_POST["permAdd"]:"") ."" . "|" . "".((isset($_POST["permCity"]))?$_POST["permCity"]:"") ."" . "|" . "".((isset($_POST["permState"]))?$_POST["permState"]:"") ."" . "|" . "".((isset($_POST["permZip"]))?$_POST["permZip"]:"") ."" . "|" . "".((isset($_POST["phoneHome"]))?$_POST["phoneHome"]:"") ."" . "|" . "".((isset($_POST["phoneWork"]))?$_POST["phoneWork"]:"") ."" . "|" . "".((isset($_POST["phoneOther"]))?$_POST["phoneOther"]:"") ."" . "|" . "".((isset($_POST["birthdate"]))?$_POST["birthdate"]:"") ."" . "|" . "".((isset($_POST["ssn"]))?$_POST["ssn"]:"") ."" . "|" . "".((isset($_POST["dlNumber"]))?$_POST["dlNumber"]:"") ."" . "|" . "".((isset($_POST["dlState"]))?$_POST["dlState"]:"") ."" . "|" . "".((isset($_POST["dlExp"]))?$_POST["dlExp"]:"") ."" . "|" . "".((isset($_POST["carAvail"]))?$_POST["carAvail"]:"") ."" . "|" . "".((isset($_POST["felony"]))?$_POST["felony"]:"") ."" . "|" . "".((isset($_POST["felonyExplain"]))?$_POST["felonyExplain"]:"") ."" . "|" . "".((isset($_POST["position"]))?$_POST["position"]:"") ."" . "|" . "".((isset($_POST["time"]))?$_POST["time"]:"") ."" . "|" . "".((isset($_POST["dateBegin"]))?$_POST["dateBegin"]:"") ."" . "|" . "".((isset($_POST["salary"]))?$_POST["salary"]:"") ."" . "|" . "".((isset($_POST["limit"]))?$_POST["limit"]:"") ."" . "|" . "".((isset($_POST["eduHSname"]))?$_POST["eduHSname"]:"") ."" . "|" . "".((isset($_POST["eduHSloc"]))?$_POST["eduHSloc"]:"") ."" . "|" . "".((isset($_POST["eduHSyears"]))?$_POST["eduHSyears"]:"") ."" . "|" . "".((isset($_POST["eduHSdegree"]))?$_POST["eduHSdegree"]:"") ."" . "|" . "".((isset($_POST["eduHSgpa"]))?$_POST["eduHSgpa"]:"") ."" . "|" . "".((isset($_POST["eduHSgpaScale"]))?$_POST["eduHSgpaScale"]:"") ."" . "|" . "".((isset($_POST["eduCollegeName"]))?$_POST["eduCollegeName"]:"") ."" . "|" . "".((isset($_POST["eduCollegeLoc"]))?$_POST["eduCollegeLoc"]:"") ."" . "|" . "".((isset($_POST["eduCollegeYears"]))?$_POST["eduCollegeYears"]:"") ."" . "|" . "".((isset($_POST["eduCollegeDegree"]))?$_POST["eduCollegeDegree"]:"") ."" . "|" . "".((isset($_POST["eduCollegeGPA"]))?$_POST["eduCollegeGPA"]:"") ."" . "|" . "".((isset($_POST["eduCollegeGPAscale"]))?$_POST["eduCollegeGPAscale"]:"") ."" . "|" . "".((isset($_POST["eduGradName"]))?$_POST["eduGradName"]:"") ."" . "|" . "".((isset($_POST["eduGradLoc"]))?$_POST["eduGradLoc"]:"") ."" . "|" . "".((isset($_POST["eduGradYears"]))?$_POST["eduGradYears"]:"") ."" . "|" . "".((isset($_POST["eduGradDegree"]))?$_POST["eduGradDegree"]:"") ."" . "|" . "".((isset($_POST["eduGradGPA"]))?$_POST["eduGradGPA"]:"") ."" . "|" . "".((isset($_POST["eduGradGPAscale"]))?$_POST["eduGradGPAscale"]:"") ."" . "|" . "".((isset($_POST["eduBusName"]))?$_POST["eduBusName"]:"") ."" . "|" . "".((isset($_POST["eduBusLoc"]))?$_POST["eduBusLoc"]:"") ."" . "|" . "".((isset($_POST["eduBusDegree"]))?$_POST["eduBusDegree"]:"") ."" . "|" . "".((isset($_POST["eduBusGPA"]))?$_POST["eduBusGPA"]:"") ."" . "|" . "".((isset($_POST["eduBusGPAscale"]))?$_POST["eduBusGPAscale"]:"") ."" . "|" . "".((isset($_POST["ref1Name"]))?$_POST["ref1Name"]:"") ."" . "|" . "".((isset($_POST["ref1Address"]))?$_POST["ref1Address"]:"") ."" . "|" . "".((isset($_POST["ref1CityStateZip"]))?$_POST["ref1CityStateZip"]:"") ."" . "|" . "".((isset($_POST["ref1Phone1"]))?$_POST["ref1Phone1"]:"") ."" . "|" . "".((isset($_POST["ref1Phone2"]))?$_POST["ref1Phone2"]:"") ."" . "|" . "".((isset($_POST["ref1Occup"]))?$_POST["ref1Occup"]:"") ."" . "|" . "".((isset($_POST["ref1Years"]))?$_POST["ref1Years"]:"") ."" . "|" . "".((isset($_POST["ref2Name"]))?$_POST["ref2Name"]:"") ."" . "|" . "".((isset($_POST["ref2Address"]))?$_POST["ref2Address"]:"") ."" . "|" . "".((isset($_POST["ref2CityStateZip"]))?$_POST["ref2CityStateZip"]:"") ."" . "|" . "".((isset($_POST["ref2Phone1"]))?$_POST["ref2Phone1"]:"") ."" . "|" . "".((isset($_POST["ref2Phone2"]))?$_POST["ref2Phone2"]:"") ."" . "|" . "".((isset($_POST["ref2Occup"]))?$_POST["ref2Occup"]:"") ."" . "|" . "".((isset($_POST["ref2Years"]))?$_POST["ref2Years"]:"") ."" . "|" . "".((isset($_POST["ref3Name"]))?$_POST["ref3Name"]:"") ."" . "|" . "".((isset($_POST["ref3Address"]))?$_POST["ref3Address"]:"") ."" . "|" . "".((isset($_POST["ref3CityStateZip"]))?$_POST["ref3CityStateZip"]:"") ."" . "|" . "".((isset($_POST["ref3Phone1"]))?$_POST["ref3Phone1"]:"") ."" . "|" . "".((isset($_POST["ref3Phone2"]))?$_POST["ref3Phone2"]:"") ."" . "|" . "".((isset($_POST["ref3Occup"]))?$_POST["ref3Occup"]:"") ."" . "|" . "".((isset($_POST["ref3Years"]))?$_POST["ref3Years"]:"") ."" . "|" . "".((isset($_POST["hist1From"]))?$_POST["hist1From"]:"") ."" . "|" . "".((isset($_POST["hist1To"]))?$_POST["hist1To"]:"") ."" . "|" . "".((isset($_POST["hist1Name"]))?$_POST["hist1Name"]:"") ."" . "|" . "".((isset($_POST["hist1Address"]))?$_POST["hist1Address"]:"") ."" . "|" . "".((isset($_POST["hist1CityStateZip"]))?$_POST["hist1CityStateZip"]:"") ."" . "|" . "".((isset($_POST["hist1Phone"]))?$_POST["hist1Phone"]:"") ."" . "|" . "".((isset($_POST["hist1Position"]))?$_POST["hist1Position"]:"") ."" . "|" . "".((isset($_POST["hist1Sup"]))?$_POST["hist1Sup"]:"") ."" . "|" . "".((isset($_POST["hist1Reason"]))?$_POST["hist1Reason"]:"") ."" . "|" . "".((isset($_POST["hist2From"]))?$_POST["hist2From"]:"") ."" . "|" . "".((isset($_POST["hist2To"]))?$_POST["hist2To"]:"") ."" . "|" . "".((isset($_POST["hist2Name"]))?$_POST["hist2Name"]:"") ."" . "|" . "".((isset($_POST["hist2Address"]))?$_POST["hist2Address"]:"") ."" . "|" . "".((isset($_POST["hist2CityStateZip"]))?$_POST["hist2CityStateZip"]:"") ."" . "|" . "".((isset($_POST["hist2Phone"]))?$_POST["hist2Phone"]:"") ."" . "|" . "".((isset($_POST["hist2Position"]))?$_POST["hist2Position"]:"") ."" . "|" . "".((isset($_POST["hist2Sup"]))?$_POST["hist2Sup"]:"") ."" . "|" . "".((isset($_POST["hist2Reason"]))?$_POST["hist2Reason"]:"") ."" . "|" . "".((isset($_POST["hist3From"]))?$_POST["hist3From"]:"") ."" . "|" . "".((isset($_POST["hist3To"]))?$_POST["hist3To"]:"") ."" . "|" . "".((isset($_POST["hist3Name"]))?$_POST["hist3Name"]:"") ."" . "|" . "".((isset($_POST["hist3Address"]))?$_POST["hist3Address"]:"") ."" . "|" . "".((isset($_POST["hist3CityStateZip"]))?$_POST["hist3CityStateZip"]:"") ."" . "|" . "".((isset($_POST["hist3Phone"]))?$_POST["hist3Phone"]:"") ."" . "|" . "".((isset($_POST["hist3Position"]))?$_POST["hist3Position"]:"") ."" . "|" . "".((isset($_POST["hist3Sup"]))?$_POST["hist3Sup"]:"") ."" . "|" . "".((isset($_POST["hist3Reason"]))?$_POST["hist3Reason"]:"") ."" . "|" . "".((isset($_POST["hist4From"]))?$_POST["hist4From"]:"") ."" . "|" . "".((isset($_POST["hist4To"]))?$_POST["hist4To"]:"") ."" . "|" . "".((isset($_POST["hist4Name"]))?$_POST["hist4Name"]:"") ."" . "|" . "".((isset($_POST["hist4Address"]))?$_POST["hist4Address"]:"") ."" . "|" . "".((isset($_POST["hist4CityStateZip"]))?$_POST["hist4CityStateZip"]:"") ."" . "|" . "".((isset($_POST["hist4Phone"]))?$_POST["hist4Phone"]:"") ."" . "|" . "".((isset($_POST["hist4Position"]))?$_POST["hist4Position"]:"") ."" . "|" . "".((isset($_POST["hist4Sup"]))?$_POST["hist4Sup"]:"") ."" . "|" . "".((isset($_POST["hist4Reason"]))?$_POST["hist4Reason"]:"") ."" . "|" . "".((isset($_POST["hist5From"]))?$_POST["hist5From"]:"") ."" . "|" . "".((isset($_POST["hist5To"]))?$_POST["hist5To"]:"") ."" . "|" . "".((isset($_POST["hist5Name"]))?$_POST["hist5Name"]:"") ."" . "|" . "".((isset($_POST["hist5Address"]))?$_POST["hist5Address"]:"") ."" . "|" . "".((isset($_POST["hist5CityStateZip"]))?$_POST["hist5CityStateZip"]:"") ."" . "|" . "".((isset($_POST["hist5Phone"]))?$_POST["hist5Phone"]:"") ."" . "|" . "".((isset($_POST["hist5Position"]))?$_POST["hist5Position"]:"") ."" . "|" . "".((isset($_POST["hist5Sup"]))?$_POST["hist5Sup"]:"") ."" . "|" . "".((isset($_POST["hist5Reason"]))?$_POST["hist5Reason"]:"");
this is a string of ternary conditions that sets the value to either the form post value if it is set, or a blank string.
Lets take the first part for an example:
((isset($_POST["firstName"]))?$_POST["firstName"]:"")
This is a shortened If statement in the following form:
(Question)?true part:false part
It means:
Is the FirstName Form Element set?
Yes: Then Use the Value of the First name Form Element
NO: then use an empty string.
if you wanted to encrypt the first name, then add the AES_ENCRYPT() function around the true part:
((isset($_POST["firstName"]))?AES_ENCRYPT($_POST["firstName"]):"")