format("Y/m/d");
$prtTime =date('H:i:s');
$toDate = $toDateX ." ".$prtTime;
$conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.');
$db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.');
$keyID= addslashes($_REQUEST['keyID']);
//======================================================================
//=========================================================
if($keyID === 'aae10241024aee'){
$regErrorCode = 0;
$regiID= addslashes($_REQUEST['regEmpID']);
$regFName= addslashes($_REQUEST['regFName']);
$regLName= addslashes($_REQUEST['regLName']);
$regMobileA= addslashes($_REQUEST['regMobileA']);
$regEmail= addslashes($_REQUEST['regEmail']);
$regPassword= addslashes($_REQUEST['regPasswordB']);
$regBday= addslashes($_REQUEST['birthdate']);
$regGender= addslashes($_REQUEST['gender']);
//$myFrame="";
$myFrame="";
$myFrame = mysql_real_escape_string($myFrame);
$checkIfEMPIDExist = mysql_result(mysql_query("SELECT COUNT('u_id') FROM `mva_users` WHERE `user_email`='$regEmail' || `user_id`='$regiID'"),0);
if($checkIfEMPIDExist != 0){
$status = "Username already exist.";
$regErrorCode = $regErrorCode + 1;
$json = json_encode(['Status'=>$status,'userID' => $regiID, 'REgCode'=>'REGISTRATION FAILED', 'Password' =>'hidden', 'Mobile'=>$regMobileA, 'email'=>$regEmail, 'statusCode'=>'failed']);
} //else {
//if($MyregPasswordA != $MyregPasswordB){
// $status = "Your password didn't match.";
// $json = json_encode(["status" => "$status", "errorCode" => '0']);
// $regErrorCode = $regErrorCode + 1;
// $json = json_encode(['Status'=>$status,'username' => $regiID, 'REgCode'=>'REGISTRATION FAILED', 'Password' =>'hidden', 'Mobile'=>$regMobileA, 'email'=>$regEmail]);
// }
if($regiID === '' || $regFName ==='' || $regLName ==='' || $regMobileA ==='' || $regEmail ==='' || $regPassword ===''){
$status = "Incomplete information.";
$json = json_encode(["status" => "$status", "errorCode" => '1']);
$regErrorCode = $regErrorCode + 1;
$json = json_encode(['Status'=>$status,'username' => $regiID, 'REgCode'=>'REGISTRATION FAILED', 'Password' =>'hidden', 'Mobile'=>$regMobileA, 'email'=>$regEmail, 'statusCode'=>'failed']);
}
if($regErrorCode == 0){
$sql = "INSERT INTO mva_users (user_id,user_fname,user_lname,user_email,user_mobile,user_password,status,time_stamp,birthdate,qr_code) VALUES('$regiID','$regFName','$regLName','$regEmail','$regMobileA','$regPassword','0', '$toDate','$regBday','$myFrame')";
$sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.');
$status = " Please take note of the following information below while we are validating your request. Thank you!";
$json = json_encode(['Status'=>$status,'username' => $regiID, 'REgCode'=>'REGISTRATION COMPLETE', 'Password' =>'*********', 'Mobile'=>$regMobileA, 'email'=>$regEmail, 'statusCode'=>'success']);
$registrationMessage ="Thank you!
You have successfully registered to i-SMARTAPP. Please take note of the following information:
Your Username: ".$regiID."
Your Password: ".$regPasswordA."
Registered E-mail: ".$regEmail."
Please wait your Admin to Activate your account
Thank you.
From Support Group";
mail($regEmail,'USER REGISTRATION',$registrationMessage, 'From: support@i-smartapps.net');
}
}
if($did_something === 0)
{
$msg = did_nothing_message;
$json = json_encode(["status" => "$MyCustomerID", "statusCode" => "$customerType"]);
}
echo $json;
?>