Viewing file:  application_action.php (3.99 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
require 'connection.php';
session_start();
$uname = $_SESSION['user_name'];
$u_id = $_SESSION['user_id'];
$studName=$_POST['studName'];
//$dob=$_POST['dob'];
//$age=$_POST['age'];
$email=$_POST['email'];
$address1=$_POST['address1'];
$address2=$_POST['address2'];
$address3=$_POST['address3'];
$pincode=$_POST['pincode'];
// $paddress1=$_POST['paddress1'];
// $paddress2=$_POST['paddress2'];
// $paddress3=$_POST['paddress3'];
// $ppincode=$_POST['ppincode'];
//$check=$_POST['check'];
// $state=$_POST['state'];
// $country=$_POST['country'];
$mobile=$_POST['mobile'];
$altmobile=$_POST['altmobile'];
$course=$_POST['course'];
$board=$_POST['board'];
$passyear=$_POST['passyear'];
$specification=$_POST['specification'];
$mark=$_POST['mark'];
$skills=$_POST['skills'];
$companyname=$_POST['companyname'];
$position=$_POST['position'];
$duration=$_POST['duration'];
$projectName=$_POST['projectName'];
$description=$_POST['description'];
$technology=$_POST['technology'];
$achievements=$_POST['achievements'];
$strengths=$_POST['strengths'];
$interests=$_POST['interests'];
$acadamic=$_POST['acadamic'];
$career_objective=$_POST['career_objective'];
$public_profile_val=$_POST['public_profile_val'];
// $exp=implode(" , ",$experience);
$achie=implode(" , ",$achievements);
// $sql="INSERT INTO `student_reg`( `name`,`email`, `permanent_address1`, `permanent_address2`, `permanent_address3`, `present_address1`, `present_address2`, `present_address3`, `present_pincode`, `permanent_pincode`, `mobile`, `alternate_mobile`, `core_skill`, `strengths`, `interest`,`achievements`,`isResumeActive`,`user_id`,`address_status`,`career_objective`)values('$studName','$email','$address1','$address2','$address3','$paddress1','$paddress2','$paddress3','$ppincode','$pincode','$mobile','$altmobile','$skills','$strengths','$interests','$achie',1,'$u_id','$check','$career_objective')";
$sql="INSERT INTO `student_reg`( `name`,`email`, `permanent_address1`, `permanent_address2`, `permanent_address3`, `permanent_pincode`, `mobile`, `alternate_mobile`, `core_skill`, `strengths`, `interest`,`achievements`,`isResumeActive`,`user_id`,`career_objective`)values('$studName','$email','$address1','$address2','$address3','$pincode','$mobile','$altmobile','$skills','$strengths','$interests','$achie',1,'$u_id','$career_objective')";
$result=$con->query($sql);
$last_id = $con->insert_id;
$que="update user_details set name='$studName' ,email='$email',phone='$mobile',`public_profile_val`='$public_profile_val' where user_id='$u_id'";
$r=$con->query($que);
foreach($companyname as $key => $value)
{
$data4['company_name']=$value;
$data4['position']=$position[$key];
$data4['duration']=$duration[$key];
$sql4="INSERT INTO `experience`( `company_name`, `position`, `duration`, `stud_id`) values('".$data4['company_name']."','".$data4['position']."','".$data4['duration']."',$last_id)";
$result4=$con->query($sql4);
}
foreach($projectName as $key => $value)
{
$data['pro_name']=$value;
$data['description']=$description[$key];
$data['technology']=$technology[$key];
$data['acadamic']=$acadamic[$key];
$sql1="insert into `resume_projects`(pro_name,description,technology,acadamic,stud_id)values('".$data['pro_name']."','".$data['description']."','".$data['technology']."','".$data['acadamic']."',$last_id)";
$result1=$con->query($sql1);
}
foreach($course as $key => $value)
{
$data1['course']=$value;
$data1['board']=$board[$key];
$data1['year']=$passyear[$key];
$data1['specification']=$specification[$key];
$data1['mark']=$mark[$key];
$sql3="INSERT INTO `education`( `course`, `board`, `year`, `specification`, `mark`, `stud_id`) values('".$data1['course']."','".$data1['board']."','".$data1['year']."','".$data1['specification']."','".$data1['mark']."',$last_id)";
$result3=$con->query($sql3);
}
$count=$con->affected_rows;
if($count>0&& $last_id!=""){
header("location:dashboard.php");
}
else{
header("location:application.php?failed");
}
?>
|