';
if(isset($_GET['datakey'])){
$stmt = $conn->prepare("select * from nsdlpancard WHERE id = ? AND order_id = ? ");
$stmt->execute([base64_decode($_GET['datakey']),base64_decode($_GET['keypass'])]);
$row=$stmt->fetch();
$rowobj = json_decode($row['changes'],true);
if($row['id']==""){
echo '
';
}
}
if(isset($_POST['action']) ){
$allowed_extensions = array("jpg","jpeg","png","gif");
$allowedExts = array("pdf");
$formexn = end(explode(".",$_FILES["ack_pdf"]["name"]));
$photoexn = end(explode(".",$_FILES["photo"]["name"]));
$signexn = end(explode(".",$_FILES["sign"]["name"]));
if ($_FILES["ack_pdf"]["type"] == "application/pdf"&&
$_FILES["ack_pdf"]["size"] <3000000 &&
in_array($formexn,$allowedExts)
) {
$form_pdf = str_replace(' ','_',$row["ack_no"])."-".rand(100000,999999)."_Form.pdf";
$form_link = "http://".$_SERVER['SERVER_NAME']."/downloads.php?files=$ack_pdf";
move_uploaded_file($_FILES["ack_pdf"]["tmp_name"],"../pan_doc/".$ack_pdf);
$photo_pdf = $_POST["name_card"]."-".rand(100000,999999)."_Photo.jpg";
$photo_link = "http://".$_SERVER['SERVER_NAME']."/downloads.php?files=$photo_pdf";
move_uploaded_file($_FILES["photo"]["tmp_name"],"../pan_doc/".$photo_pdf);
$sign_pdf = $_POST["name_card"]."-".rand(100000,999999)."_Sign.jpg";
$sign_link = "http://".$_SERVER['SERVER_NAME']."/downloads.php?files=$sign_pdf";
move_uploaded_file($_FILES["sign"]["tmp_name"],"../pan_doc/".$sign_pdf);
}
if($_FILES["ack_pdf"]["name"]==""){
$ack_pdf = $row['ack_pdf'];
}else{
$ack_pdf = $form_link;
}
$response->full_name = filter_var($_POST['full_name'],FILTER_SANITIZE_STRING);
$response->father_name = filter_var($_POST['father_name'],FILTER_SANITIZE_STRING);
$response->date_brith = filter_var($_POST['date_brith'],FILTER_SANITIZE_STRING);
$response->gender = filter_var($_POST['gender_c'],FILTER_SANITIZE_STRING);
$response->address = filter_var($_POST['address'],FILTER_SANITIZE_STRING);
$response->nofdoc = filter_var($_POST['nofdoc'],FILTER_SANITIZE_STRING);
$changes = json_encode($response);
$nsdlsql = "UPDATE nsdlpancard SET cat_applicant=:cat_applicant,pan_number=:pan_number,l_name=:l_name,f_name=:f_name,m_name=:m_name,name_card=:name_card,dob=:dob,gender=:gender,fal_name=:fal_name,
faf_name=:faf_name,fam_name=:fam_name,aadhaar_num=:aadhaar_num,name_aadhaar=:name_aadhaar,mob_num=:mob_num,email_id=:email_id,address1=:address1,address2=:address2,address3=:address3,address4=:address4,address5=:address5,
user_state=:user_state,pincode=:pincode,pan_type=:pan_type,r_title=:r_title,rl_name=:rl_name,rf_name=:rf_name,rm_name=:rm_name,r_address1=:r_address1,r_address2=:r_address2,r_address3=:r_address3,r_address4=:r_address4,r_address5=:r_address5,
r_state=:r_state,r_pincode=:r_pincode,city=:city,area_code=:area_code,ao_type=:ao_type,rangecode=:rangecode,aocode=:aocode,proof_id=:proof_id,proof_add=:proof_add,proof_dob=:proof_dob,ack_pdf=:ack_pdf,changes=:changes,ack_no=:ack_no,remark=:remark,remark=:remark,status=:status WHERE id='".$row['id']."'";
$nsdl = $conn->prepare($nsdlsql);
$nsdl->bindParam(":cat_applicant",filter_var($_POST["cat_applicant"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":pan_number",filter_var($_POST["pan_number"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":l_name",filter_var($_POST["l_name"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":f_name",filter_var($_POST["f_name"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":m_name",filter_var($_POST["m_name"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":name_card",filter_var($_POST["name_card"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":dob",filter_var($_POST["dob"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":gender",filter_var($_POST["gender"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":fal_name",filter_var($_POST["fal_name"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":faf_name",filter_var($_POST["faf_name"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":fam_name",filter_var($_POST["fam_name"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":aadhaar_num",filter_var($_POST["aadhaar_num"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":name_aadhaar",filter_var($_POST["name_aadhaar"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":mob_num",filter_var($_POST["mob_num"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":email_id",filter_var($_POST["email_id"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":address1",filter_var($_POST["address1"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":address2",filter_var($_POST["address2"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":address3",filter_var($_POST["address3"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":address4",filter_var($_POST["address4"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":address5",filter_var($_POST["address5"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":user_state",filter_var($_POST["user_state"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":pincode",filter_var($_POST["pincode"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":pan_type",filter_var($_POST["pan_type"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":r_title",filter_var($_POST["r_title"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":rl_name",filter_var($_POST["rl_name"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":rf_name",filter_var($_POST["rf_name"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":rm_name",filter_var($_POST["rm_name"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":r_address1",filter_var($_POST["r_address1"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":r_address2",filter_var($_POST["r_address2"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":r_address3",filter_var($_POST["r_address3"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":r_address4",filter_var($_POST["r_address4"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":r_address5",filter_var($_POST["r_address5"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":r_state",filter_var($_POST["r_state"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":r_pincode",filter_var($_POST["r_pincode"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":city",filter_var($_POST["city"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":area_code",filter_var($_POST["area_code"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":ao_type",filter_var($_POST["ao_type"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":rangecode",filter_var($_POST["rangecode"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":aocode",filter_var($_POST["aocode"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":proof_id",filter_var($_POST["proof_id"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":proof_add",filter_var($_POST["proof_add"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":proof_dob",filter_var($_POST["proof_dob"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":ack_pdf",$ack_pdf);
$nsdl->bindParam(":changes",$changes);
$nsdl->bindParam(":ack_no",filter_var($_POST["ack_no"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":remark",filter_var($_POST["remark"],FILTER_SANITIZE_STRING));
$nsdl->bindParam(":status",filter_var($_POST["status"],FILTER_SANITIZE_STRING));
if($nsdl->execute()){
echo '
Application! Update Successfully!
';
}else {
echo '
Invalid! Data Not Insert!
';
}
}
;echo '