prepare("insert into hca_app1(app_id,names,pos,dv,location,image) values(:a,:b,:c,:d,:e,:f)") ;
$sql1->bindparam(":a",$appid) ;
$sql1->bindparam(":b",$name) ;
$sql1->bindparam(":c",$posi) ;
$sql1->bindparam(":d",$drive) ;
$sql1->bindparam(":e",$location) ;
$sql1->bindparam(":f",$img) ;
if($sql1->execute())
//2ndtable variable
{
$apply = sanitizeString($_POST['apply']) ;
$title = sanitizeString($_POST['title']) ;
$fname = sanitizeString($_POST['fname']) ;
$sname = sanitizeString($_POST['sname']) ;
$prname = sanitizeString($_POST['pname']) ;
$psname = sanitizeString($_POST['psname']) ;
$add = sanitizeString($_POST['address']) ;
$hphone = sanitizeString($_POST['hphone']) ;
$wphone = sanitizeString($_POST['wphone']) ;
$mobile = sanitizeString($_POST['mobile']) ;
$emails = sanitizeString($_POST['email']) ;
$nation = sanitizeString($_POST['nation']) ;
$nin = sanitizeString($_POST['nin']) ;
$dob = sanitizeString($_POST['dob']) ;
$ct = sanitizeString($_POST['contact']) ;
$sql2 = $DBcon->prepare("insert into hca_app2(app_id,apply,title,fname,sname,pname,psname,address,hphone,wphone,mobile,emails,nation,nin,dob,ct) values(:a,:b,:c,:d,:e,:f,:g,:h,:i,:j,:k,:l,:m,:n,:o,:p)") ;
$sql2->bindparam(":a",$appid) ;
$sql2->bindparam(":b",$apply) ;
$sql2->bindparam(":c",$title) ;
$sql2->bindparam(":d",$fname) ;
$sql2->bindparam(":e",$sname) ;
$sql2->bindparam(":f",$prname) ;
$sql2->bindparam(":g",$psname) ;
$sql2->bindparam(":h",$add) ;
$sql2->bindparam(":i",$hphone) ;
$sql2->bindparam(":j",$wphone) ;
$sql2->bindparam(":k",$mobile) ;
$sql2->bindparam(":l",$emails) ;
$sql2->bindparam(":m",$nation) ;
$sql2->bindparam(":n",$nin) ;
$sql2->bindparam(":o",$dob) ;
$sql2->bindparam(":p",$ct) ;
if($sql2->execute())
{
//another
$nks = sanitizeString($_POST['nks']) ;
$nkf = sanitizeString($_POST['nkf']) ;
$nkaddress = sanitizeString($_POST['nkaddress']) ;
$nkhphone = sanitizeString($_POST['nkhphone']) ;
$nkwphone = sanitizeString($_POST['nkwphone']) ;
$nkmobile = sanitizeString($_POST['nkmobile']) ;
$nr = sanitizeString($_POST['nr']) ;
$nkpcode = sanitizeString($_POST['nkpcode']) ;
$nname = $nks."".$nkf ;
$sql3 = $DBcon->prepare("insert into nextkin(app_id,names,hphone,wphone,mob,address,postcode,relationship) values(:a,:b,:c,:d,:e,:f,:g,:h)") ;
$sql3->bindparam(":a",$appid) ;
$sql3->bindparam(":b",$nname) ;
$sql3->bindparam(":c",$nkhphone) ;
$sql3->bindparam(":d",$nkwphone) ;
$sql3->bindparam(":e",$nkmobile) ;
$sql3->bindparam(":f",$nkaddress) ;
$sql3->bindparam(":g",$nkpcode) ;
$sql3->bindparam(":h",$nr) ;
if($sql3->execute())
{
//
$convict = sanitizeString($_POST['nc']) ;
$rs = sanitizeString($_POST['cyes']) ;
$rsdetail= sanitizeString($_POST['dec']) ;
$sql4 = $DBcon->prepare("insert into bcodes(app_id,convict,reason,rsdetails) values(:a,:b,:c,:d)") ;
$sql4->bindparam(":a",$appid) ;
$sql4->bindparam(":b",$convict) ;
$sql4->bindparam(":c",$rs) ;
$sql4->bindparam(":d",$rsdetail) ;
if($sql4->execute())
{
//update edu qualifications
$sql5 = $DBcon->prepare("update app_education set app_id = '$appid' where unikid = '$unicid'") ;
if($sql5->execute())
{
//update employment history
$sql6 = $DBcon->prepare("update employment_history set app_id = '$appid' where unikid = '$unicid'") ;
if($sql6->execute())
{
//update training history
$sql7 = $DBcon->prepare("update training set app_id = '$appid' where unikid = '$unicid'") ;
if($sql7->execute())
{
//update training history
$sql8 = $DBcon->prepare("update reference set app_id = '$appid' where unikid = '$unicid'") ;
if($sql8->execute())
{
$message = "
 |
Hello ADMIN,
NEW APPLICANT!
A new Application was submitted now, login to the Admin panel to view the Application
CLICK THE LINK BELOW TO LOGIN TO THE ADMIN PANEL
LOGIN TO ADMIN
CRYSTAL BLOOM MANAGEMENT
|
 |
";
$ademails = 'admin@crystalbloomltd.co.uk' ;
$subject = "NEW APPLICATION";
//
// To send HTML mail, the Content-type header must be set
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=UTF-8\r\n";
$headers .= "From: noreply@yourwebsite.com\r\n";
$headers .= "Reply-To: support@yourwebsite.com\r\n";
$headers .= "X-Mailer: PHP/" . phpversion();
if (mail($ademails, $subject, $message, $headers)) {
header("location: success.php") ;
}else{
?>
send_mail($ademails,$message,$subject);
}
}
}
}
}
}
}
}
//
}
else
{
$NewImageName = 'nill' ;
$appid = $_SESSION['appid'] ;
$name = sanitizeString($_POST['names']) ;
$posi = sanitizeString($_POST['posi']) ;
$drive = sanitizeString($_POST['drive']) ;
$location = sanitizeString($_POST['location']) ;
$img = $NewImageName;
$sql1 = $DBcon->prepare("insert into hca_app1(app_id,names,pos,dv,location,image) values(:a,:b,:c,:d,:e,:f)") ;
$sql1->bindparam(":a",$appid) ;
$sql1->bindparam(":b",$name) ;
$sql1->bindparam(":c",$posi) ;
$sql1->bindparam(":d",$drive) ;
$sql1->bindparam(":e",$location) ;
$sql1->bindparam(":f",$img) ;
if($sql1->execute())
//2ndtable variable
{
$apply = sanitizeString($_POST['apply']) ;
$title = sanitizeString($_POST['title']) ;
$fname = sanitizeString($_POST['fname']) ;
$sname = sanitizeString($_POST['sname']) ;
$prname = sanitizeString($_POST['pname']) ;
$psname = sanitizeString($_POST['psname']) ;
$add = sanitizeString($_POST['address']) ;
$hphone = sanitizeString($_POST['hphone']) ;
$wphone = sanitizeString($_POST['wphone']) ;
$mobile = sanitizeString($_POST['mobile']) ;
$emails = sanitizeString($_POST['email']) ;
$nation = sanitizeString($_POST['nation']) ;
$nin = sanitizeString($_POST['nin']) ;
$dob = sanitizeString($_POST['dob']) ;
$ct = sanitizeString($_POST['contact']) ;
$sql2 = $DBcon->prepare("insert into hca_app2(app_id,apply,title,fname,sname,pname,psname,address,hphone,wphone,mobile,emails,nation,nin,dob,ct) values(:a,:b,:c,:d,:e,:f,:g,:h,:i,:j,:k,:l,:m,:n,:o,:p)") ;
$sql2->bindparam(":a",$appid) ;
$sql2->bindparam(":b",$apply) ;
$sql2->bindparam(":c",$title) ;
$sql2->bindparam(":d",$fname) ;
$sql2->bindparam(":e",$sname) ;
$sql2->bindparam(":f",$prname) ;
$sql2->bindparam(":g",$psname) ;
$sql2->bindparam(":h",$add) ;
$sql2->bindparam(":i",$hphone) ;
$sql2->bindparam(":j",$wphone) ;
$sql2->bindparam(":k",$mobile) ;
$sql2->bindparam(":l",$emails) ;
$sql2->bindparam(":m",$nation) ;
$sql2->bindparam(":n",$nin) ;
$sql2->bindparam(":o",$dob) ;
$sql2->bindparam(":p",$ct) ;
if($sql2->execute())
{
//another
$nks = sanitizeString($_POST['nks']) ;
$nkf = sanitizeString($_POST['nkf']) ;
$nkaddress = sanitizeString($_POST['nkaddress']) ;
$nkhphone = sanitizeString($_POST['nkhphone']) ;
$nkwphone = sanitizeString($_POST['nkwphone']) ;
$nkmobile = sanitizeString($_POST['nkmobile']) ;
$nr = sanitizeString($_POST['nr']) ;
$nkpcode = sanitizeString($_POST['nkpcode']) ;
$nname = $nks."".$nkf ;
$sql3 = $DBcon->prepare("insert into nextkin(app_id,names,hphone,wphone,mob,address,postcode,relationship) values(:a,:b,:c,:d,:e,:f,:g,:h)") ;
$sql3->bindparam(":a",$appid) ;
$sql3->bindparam(":b",$nname) ;
$sql3->bindparam(":c",$nkhphone) ;
$sql3->bindparam(":d",$nkwphone) ;
$sql3->bindparam(":e",$nkmobile) ;
$sql3->bindparam(":f",$nkaddress) ;
$sql3->bindparam(":g",$nkpcode) ;
$sql3->bindparam(":h",$nr) ;
if($sql3->execute())
{
//
$convict = sanitizeString($_POST['nc']) ;
$rs = sanitizeString($_POST['cyes']) ;
$rsdetail= sanitizeString($_POST['dec']) ;
$sql4 = $DBcon->prepare("insert into bcodes(app_id,convict,reason,rsdetails) values(:a,:b,:c,:d)") ;
$sql4->bindparam(":a",$appid) ;
$sql4->bindparam(":b",$convict) ;
$sql4->bindparam(":c",$rs) ;
$sql4->bindparam(":d",$rsdetail) ;
if($sql4->execute())
{
//update edu qualifications
$sql5 = $DBcon->prepare("update app_education set app_id = '$appid' where unikid = '$unicid'") ;
if($sql5->execute())
{
//update employment history
$sql6 = $DBcon->prepare("update employment_history set app_id = '$appid' where unikid = '$unicid'") ;
if($sql6->execute())
{
//update training history
$sql7 = $DBcon->prepare("update training set app_id = '$appid' where unikid = '$unicid'") ;
if($sql7->execute())
{
//update training history
$sql8 = $DBcon->prepare("update reference set app_id = '$appid' where unikid = '$unicid'") ;
if($sql8->execute())
{
$message = "
 |
Hello ADMIN,
NEW APPLICANT!
A new Application was submitted now, login to the Admin panel to view the Application
CLICK THE LINK BELOW TO LOGIN TO THE ADMIN PANEL
LOGIN TO ADMIN
CRYSTAL BLOOM MANAGEMENT
|
 |
";
$ademails = 'admin@crystalbloomltd.co.uk' ;
$subject = "NEW APPLICATION";
//
// To send HTML mail, the Content-type header must be set
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=UTF-8\r\n";
$headers .= "From: noreply@yourwebsite.com\r\n";
$headers .= "Reply-To: support@yourwebsite.com\r\n";
$headers .= "X-Mailer: PHP/" . phpversion();
if (mail($ademails, $subject, $message, $headers)) {
header("location: success.php") ;
}else{
?>
send_mail($ademails,$message,$subject);
}
}
}
}
}
}
}
}
}
}
?>
Crystal Bloom ltd