php registration date issue

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

Hello,

It appears that you have too many Quote marks here:
//registrationType = ‘".$registration_type."’";

take away the last one so looks like this:
//registrationType = ‘".$registration_type."’;

that should fix it

Red. :wink:

Sponsor our Newsletter | Privacy Policy | Terms of Service