"; $query_current="SELECT * from $clients_db WHERE CL_id = '$tempuserCLid'"; $result_current_query=mysql_query($query_current); if(!$result_current_query){error_message("Failed to retrieve client info. Make sure province is correct!");} $current_array=mysql_fetch_array($result_current_query); $CLfname=$current_array["CLfname"]; $CLlname=$current_array["CLlname"]; $CLemail=$current_array["CLemail"]; $CLemail_me=$current_array["CLemail_me"]; $CLphone=$current_array["CLphone"]; $CLfax=$current_array["CLfax"]; $CLaddress1=$current_array["CLaddress1"]; $CLaddress2=$current_array["CLaddress2"]; $CLcity=$current_array["CLcity"]; $CLprov=$current_array["CLprov"]; $CLpostal=$current_array["CLpostal"]; $CL_iv=$current_array['CL_iv']; $CLthird_co1=$current_array["CLthird_co1"]; $CLthird_co2=$current_array["CLthird_co2"]; $CLthird_co3=$current_array["CLthird_co3"]; $CLthird_co4=$current_array["CLthird_co4"]; $CLthird_co5=$current_array["CLthird_co5"]; $CLclaim_no1=$current_array["CLclaim_no1"]; $CLclaim_no2=$current_array["CLclaim_no2"]; $CLclaim_no3=$current_array["CLclaim_no3"]; $CLclaim_no4=$current_array["CLclaim_no4"]; $CLclaim_no5=$current_array["CLclaim_no5"]; $thirdptyemail1=$current_array["third_party_email1"]; $thirdptyemail2=$current_array["third_party_email2"]; $thirdptyemail3=$current_array["third_party_email3"]; $thirdptyemail4=$current_array["third_party_email4"]; $thirdptyemail5=$current_array["third_party_email5"]; } function retrieve_and_decrypt_DOB($tempuserCLid) { global $mcrypt_key, $mcrypt_iv; global $default_dbname; if(!empty($_SESSION['userCLprov'])){$tempCLprov=$_SESSION['userCLprov'];} else if(!empty($_GET['CLprov'])){$tempCLprov=$_GET['CLprov'];} else {echo "No client logged in, cannot update info";} if($tempCLprov=="BC"){$clients_db = "clients";} else if($tempCLprov=="AB"){$clients_db = "clients_ab";} else if($tempCLprov=="SK"){$clients_db = "clients_sk";} else if($tempCLprov=="MB"){$clients_db = "clients_mb";} else if($tempCLprov=="ON"){$clients_db = "clients_on";} else if($tempCLprov=="QC"){$clients_db = "clients_qc";} else if($tempCLprov=="NB"){$clients_db = "clients_nb";} else if($tempCLprov=="NS"){$clients_db = "clients_ns";} else if($tempCLprov=="PE"){$clients_db = "clients_pe";} else if($tempCLprov=="NL"){$clients_db = "clients_nl";} else if($tempCLprov=="YK"){$clients_db = "clients_yk";} else if($tempCLprov=="NW"){$clients_db = "clients_nw";} else if($tempCLprov=="NV"){$clients_db = "clients_nv";} else {echo "No client logged in, cannot update info";} $query="SELECT CL_iv, DOB from "; $query .= $clients_db; $query .= " WHERE CL_id='$tempuserCLid'"; $result=mysql_query($query); if(!$result){error_message("No result from query");} $retrieved=mysql_fetch_array($result); $CL_iv_fetched=$retrieved['CL_iv']; //echo "CL_iv fetched is " . $CL_iv_fetched; $DOB=$retrieved['DOB']; $DOB=rtrim($DOB, "\0"); $mcrypt_iv=base64_decode($CL_iv_fetched); $mcrypt_module = mcrypt_module_open('rijndael-256', '', 'cbc', ''); mcrypt_generic_init($mcrypt_module, $mcrypt_key, $mcrypt_iv); $DOB_decrypted=mdecrypt_generic($mcrypt_module, base64_decode($DOB)); return $DOB_decrypted; } function dateOfBirthWithInput($yearInput, $monthInput, $dayInput) { global $DOBMonthName; echo ""; echo ""; echo ""; } function update_CL_form() { global $CL_id, $CLfname, $CLlname, $CLemail, $CLemail_me, $CLphone, $CLfax, $CLaddress1, $CLaddress2, $CLcity, $CLprov, $CLpostal, $CL_iv, $CLthird_co1, $CLthird_co2, $CLthird_co3, $CLthird_co4, $CLthird_co5, $CLclaim_no1, $thirdptyemail1, $CLclaim_no2, $thirdptyemail2,$CLclaim_no3, $thirdptyemail3,$CLclaim_no4, $thirdptyemail4,$CLclaim_no5, $thirdptyemail5, $DOBMonthName; global $PHP_SELF, $third_co1; if(!empty($_SESSION['userCLprov'])){$tempCLprov=$_SESSION['userCLprov'];} else if(!empty($_GET['CLprov'])){$tempCLprov=$_GET['CLprov'];} else {echo "No client logged in, cannot update info";} if($tempCLprov=="BC"){$clients_db = "clients";} else if($tempCLprov=="AB"){$clients_db = "clients_ab";} else if($tempCLprov=="SK"){$clients_db = "clients_sk";} else if($tempCLprov=="MB"){$clients_db = "clients_mb";} else if($tempCLprov=="ON"){$clients_db = "clients_on";} else if($tempCLprov=="QC"){$clients_db = "clients_qc";} else if($tempCLprov=="NB"){$clients_db = "clients_nb";} else if($tempCLprov=="NS"){$clients_db = "clients_ns";} else if($tempCLprov=="PE"){$clients_db = "clients_pe";} else if($tempCLprov=="NL"){$clients_db = "clients_nl";} else if($tempCLprov=="YK"){$clients_db = "clients_yk";} else if($tempCLprov=="NW"){$clients_db = "clients_nw";} else if($tempCLprov=="NV"){$clients_db = "clients_nv";} else {$clients_db = "clients";} $DOB_decrypted=retrieve_and_decrypt_DOB($_SESSION['userCLid']); list($DOBYear, $DOBMonth, $DOBDay)=explode("-",$DOB_decrypted); if($DOBMonth==1){$DOBMonthName="Jan";} if($DOBMonth==2){$DOBMonthName="Feb";} if($DOBMonth==3){$DOBMonthName="Mar";} if($DOBMonth==4){$DOBMonthName="Apr";} if($DOBMonth==5){$DOBMonthName="May";} if($DOBMonth==6){$DOBMonthName="Jun";} if($DOBMonth==7){$DOBMonthName="Jul";} if($DOBMonth==8){$DOBMonthName="Aug";} if($DOBMonth==9){$DOBMonthName="Sep";} if($DOBMonth==10){$DOBMonthName="Oct";} if($DOBMonth==11){$DOBMonthName="Nov";} if($DOBMonth==12){$DOBMonthName="Dec";} ?>

Update your client account!

Client ID
First Name
Last Name
Date of Birth
email Use this email address:

email me >2 days before >3 days before
each appointment, as a reminder.
>do not remind me before appointments but send me announcements and special offers!
>only email changes!
phone number
Address 1
Address 2
City
Prov.
Postal Code
Current
Insurers/Payors
"; echo $CLthird_co2; echo "
"; echo $CLthird_co3; echo "
"; echo $CLthird_co4; echo "
"; echo $CLthird_co5; echo "
"; ?>
Insurer/Payor
claim/policy nos.
Can be updated here.
Or can be added here.
3rd party emails Can be updated here.

"; echo $tempCLfname_u; echo " "; echo $tempCLlname_u; ?>, thanks for updating your account information!

If you want to log out, click here."; echo "
If you want to check available appointments, click "; echo "here."; } //echo "Deleted from $clients_db and inserted into $clients_dbnoo"; } else { $query="UPDATE $clients_db SET CLfname='$tempCLfname_u', CLlname='$tempCLlname_u', CLemail='$tempCLemail_u', CLemail_me='$tempCLemail_me', CLphone='$tempCLphone_u', CLaddress1='$tempCLaddress1_u', CLaddress2='$tempCLaddress2_u', CLcity='$tempCLcity_u', CLprov='$tempCLprov_u', CLpostal='$tempCLpostal_u', DOB='$tempDOB_encrypted' WHERE CL_id = '$tempuserCLid'"; $result=mysql_query($query); if(!$result) error_message(sql_error()); if($result) { ?>

's account information has been updated!

If you want to logout, click here."; echo "
If you want to check available appointments, click "; echo "here."; } else { echo "

If you want to check for available appointments, click "; echo ""; echo "here"; echo "

"; } } }//end of else } /////OMITTED THE DISPLAY INFO below//// ?>"; echo ""; echo ""; switch($_POST['action']) { case "update_CLregister": get_current_CL(); update_CL_account(); break; default: if(empty($_SESSION['userCLid'])) {echo "
No client logged in. If you are a client, log in here ";} else if(!empty($_GET['CLlook']) && ((!empty($_SESSION['userProid'])) || (!empty($_SESSION['user3id1'])))) { $_SESSION['userCLid']=$_GET['CLlook']; get_current_CL(); update_CL_form(); } else {get_current_CL(); update_CL_form();} break; } ?>