I am working on fixing an issue on a friends website that was designed by another person.
The site has 2 registration scripts, one for students and one for employees…They are very similar scripts as follows, however I get an error for the registration input to db, regDt, in the student script (NOT in the employee script).
Error message is: Parse error: syntax error, unexpected ‘=’ in /home/lap99go/public_html/Models/StudentModel.php on line 99
Employee script snippet:
function insertEmployeeDetails($employee_array, $admin_insert)
{
if($employee_array[‘dateOfBirth’] !=’’)
{
$DateArray = explode("-",$employee_array[‘dateOfBirth’]);
$dateOfBirth = $DateArray[2]."-".$DateArray[0]."-".$DateArray[1];
}else {
$dateOfBirth = ‘’;
}
//echo “–>”.$dateOfBirth."
";
//empCode = '".addslashes($employee_array['empCode'])."',
$sql = "INSERT INTO Employee SET fkAdminId = ".$admin_insert.",
suffix = '".addslashes($employee_array['suffix'])."' ,
firstName = '".addslashes($employee_array['firstName'])."',
middleName = '".addslashes($employee_array['middleName'])."',
lastName = '".addslashes($employee_array['lastName'])."',
gender = '".addslashes($employee_array['gender'])."',
companyName = '".addslashes($employee_array['companyName'])."',
address1 = '".addslashes($employee_array['address1'])."',
address2 = '".addslashes($employee_array['address2'])."',
city = '".addslashes($employee_array['city'])."',
state = '".$employee_array['state']."',
zipCode = '".addslashes($employee_array['zipCode'])."',
emailAddr = '".addslashes($employee_array['emailAddress'])."',
dayPhone = '".$employee_array['dayPhone']."',
eveningPhone = '".$employee_array['eveningPhone']."',
fax = '".$employee_array['fax']."',
userName = '".addslashes($employee_array['userName'])."',
password = '".addslashes($employee_array['password'])."',
securityQues1 = '".addslashes($employee_array['securityQues1'])."',
securityAns1 = '".addslashes($employee_array['securityAns1'])."',
securityQues2 = '".addslashes($employee_array['securityQues2'])."',
securityAns2 = '".addslashes($employee_array['securityAns2'])."',
DOB = '".$dateOfBirth."' ,
qualification = '".$employee_array['qualification']."',
regDt = now()";
//echo "<br><br>==>".$sql."<br>";
$this->insertInto($sql);
$employeId = $this->sqlInsertId();
if($employeId < 10)
{
$addzero = '00';
}
else if($employeId <=99)
{
$addzero = '0';
} else
$addzero = '';
$employeecode = "emp".$addzero.$employeId;
$updatesql = "Update Employee SET empCode = '".$employeecode."' where empId=".$employeId;
return $this->updateInto($updatesql);
return $this->sqlInsertId();
}
//END:Insert to employee information
Student script snippet:
//BEGIN:Insert to student information
function insertStudentDeatils($student_array,$registration_type)
{
$sql = “INSERT INTO Student SET suffix = “.$registration_type.”,
suffix = '”.addslashes($student_array[‘suffix’])."’ ,
firstName = ‘".addslashes($student_array[‘firstName’])."’,
middelName = ‘".addslashes($student_array[‘middelName’])."’,
lastName = ‘".addslashes($student_array[‘lastName’])."’,
gender = ‘".addslashes($student_array[‘gender’])."’,
companyName = ‘".addslashes($student_array[‘companyName’])."’,
address1 = ‘".addslashes($student_array[‘address1’])."’,
address2 = ‘".addslashes($student_array[‘address2’])."’,
city = ‘".addslashes($student_array[‘city’])."’,
state = ‘".$student_array[‘state’]."’,
zipCode = ‘".addslashes($student_array[‘zipCode’])."’,
emailAddress = ‘".addslashes($student_array[‘emailAddress’])."’,
dayPhone = ‘".$student_array[‘dayPhone’]."’,
eveningPhone = ‘".$student_array[‘eveningPhone’]."’,
fax = ‘".$student_array[‘fax’]."’,
userName = ‘".addslashes($student_array[‘userName’])."’,
password = ‘".addslashes($student_array[‘password’])."’,
securityQues1 = ‘".addslashes($student_array[‘securityQues1’])."’,
securityAns1 = ‘".addslashes($student_array[‘securityAns1’])."’,
securityQues2 = ‘".addslashes($student_array[‘securityQues2’])."’,
securityAns2 = ‘".addslashes($student_array[‘securityAns2’])."’,
age = ‘".$student_array[‘age’]."’ ,
qualification = ‘".$student_array[‘qualification’]."’,
licensedAppraiserYear = ‘".$student_array[‘licensedAppraiserYear’]."’,
continuingEducationPerc = ‘".$student_array[‘continuingEducationPerc’]."’,
atlantisEducationHear = ‘".$student_array[‘atlantisEducationHear’]."’,
//registrationType = ‘".$registration_type."’";
regDt = now()";
//echo “
==>”.$sql."
";die();
$this->insertInto($sql);
return $this->sqlInsertId();
}
function insertStudentlicense($license_array,$studentid)
{
if($license_array[‘exparationdate’] !=’’)
{
$DateArray = explode("-",$license_array[‘exparationdate’]);
$exDate = $DateArray[2]."-".$DateArray[o]."-".$DateArray[1];
}else {
$exDate = ‘’;
}
$sql = “INSERT INTO StudentLicense SET fkStudentId = '”.$studentid."’ ,
fkStateId = ‘".addslashes($license_array[‘licensestate’])."’,
licenceNo = ‘".addslashes($license_array[‘licensenum’])."’,
expirationDt = ‘".$exDate."’,
fkLicenseTypeId = ‘".addslashes($license_array[‘licensetypeid’])."’";
//echo “
====”.$sql;die();
$this->insertInto($sql);
return $this->sqlInsertId();
}
//END:Insert to student information
PLEASE HELP!!!
Thanks,
Gary