ERROR! Password didn't matched. Please check your entry and try again. Thank you!

"; }else{ if($chkIfIDExist > 0){ $sysMessage = "

ERROR! ID Number ".$empID." already exist or being used by another user. Please check your entry and try again. Thank you!

"; }else{ //=============================================== $empPosition = $_POST['empPosition']; $lName = $_POST['lName']; $fName = $_POST['fName']; $mName = $_POST['mName']; $lName = mysql_real_escape_string($lName); $fName = mysql_real_escape_string($fName); $mName = mysql_real_escape_string($mName); $empPosition = mysql_real_escape_string($empPosition); $empMobile = $_POST['empMobile']; $empMobile = mysql_real_escape_string($empMobile); $empGender = $_POST['empGender']; $compName = $_POST['compName']; $deptName = $_POST['deptName']; $dealName = $_POST['dealName']; $companyCode = mysql_result(mysql_query("SELECT `code` FROM `company` WHERE `name` ='$compName'"),0); $dealerCode = mysql_result(mysql_query("SELECT `dcode` FROM `dealers` WHERE `name` ='$dealName'"),0); $deptCode = mysql_result(mysql_query("SELECT `code` FROM `departments` WHERE `name` ='$deptName'"),0); $dealerID = mysql_result(mysql_query("SELECT `id` FROM `dealers` WHERE `dcode`='$dealerCode'"),0); $companyID = mysql_result(mysql_query("SELECT `id` FROM `company` WHERE `code`='$companyCode'"),0); $deptID = mysql_result(mysql_query("SELECT `id` FROM `departments` WHERE `code`='$deptCode'"),0); $passWordA = md5($passWordA); $passWordB = md5($passWordB); $sql="INSERT INTO `employee_list` (`id`,`employee_id`,`ccom_code`,`deal_code`,`dept_code`,`head_id`,`supervisor_id`,`last_name`,`first_name`,`middle_name`,`position`,`gender`,`level`,`mobile_number`,`e_mail`) VALUES('','$empID','$companyCode','$dealerCode','$deptCode','','','$lName','$fName','$mName','$empPosition','$empGender','','$empMobile','$empEmail')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ $sysMessage = "

RECORD SAVED! Record Has been saved. You may now login using your e-mail address as your username and password you have provided. Thank you!

"; } $sql="INSERT INTO `c_users` (`u_id`,`emp_id`,`comp_id`,`deal_id`,`dept_id`,`comp_code`,`deal_code`,`dept_code`,`u_name`,`u_fname`,`u_lname`,`u_mname`,`u_position`,`email`,`u_password`,`u_password2`, `account_type`,`user_only`,`status`) VALUES('','$empID','$companyID','$dealerID','$deptID','$companyCode','$dealerCode','$deptCode','$empEmail','$fName','$lName','$mName','$empPosition','$empEmail','$passWordA','$passWordB','User','true','0')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "

REGISTRATION COMPLETE

Please check your e-mail to activate your account. Thank you!

"; } } //============================================= } }else{ $sysMessage = "

ERROR! ".$empEmail." email is not valid or wrong format. Please check your entry and try again. Thank you!

"; } //EMAIL NOTIFICATION $message = "Hi ". $fName. "! Thank you for signing up to our Autohub Portal. Please activate your account by clicking the link below. If link didn't work, copy paste the URL to your browser for automatice activation. Please refer to your account details below: Account Details: Username: ".$empEmail." Password: ".$myPassword." http://www.autohub.ph/portal/index.php?activate=true&token=".md5($empEmail)."&id=".$empID." Thank you! Autohub Support Group"; mail($empEmail, 'AUTOHUB ACCOUNT REGISTRATION', $message, 'From: support@autohubgroup.com'); } ?>

USERNAME:
                                          Your e-mail address will be your official username:

PASSWORD:
                                          Password must be at least 6 characters long combined with letters and numbers

RE-TYPE PASSWORD:
                                          Validate your password to make sure you type it correctly

". $sysMessage."

";?>