Akhil Vinay Mandava
asked on
errors in qualification process
<?php
$EmployeeID = "";
if(isset($_POST['EmployeeID'])){
$EmployeeID = $_POST['EmployeeID'];
}
$FirstName = "";
if(isset($_POST['FirstName'])){
$FirstName = $_POST['FirstName'];
}
$MiddleName = "";
if(isset($_POST['MiddleName'])){
$MiddleName = $_POST['MiddleName'];
}
$LastName = "";
if(isset($_POST['LastName'])){
$LastName = $_POST['LastName'];
}
$FatherName = "";
if(isset($_POST['FatherName'])){
$FatherName = $_POST['FatherName'];
}
$SpouseName = "";
if(isset($_POST['SpouseName'])){
$SpouseName = $_POST['SpouseName'];
}
$MotherName = "";
if(isset($_POST['MotherName'])){
$MotherName = $_POST['MotherName'];
}
$DOBMonth = "";
if(isset($_POST['DOBMonth'])){
$DOBMonth = $_POST['DOBMonth'];
}
$DOBDay = "";
if(isset($_POST['DOBDay'])){
$DOBDay = $_POST['DOBDay'];
}
$DOBYear = "";
if(isset($_POST['DOBYear'])){
$DOBYear = $_POST['DOBYear'];
}
$DateOfBirth="{$DOBMonth}-{$DOBDay}-{$DOBYear}";
$Age = "";
if(isset($_POST['Age'])){
$Age = $_POST['Age'];
}
$BloodGroup = "";
if(isset($_POST['BloodGroup'])){
$BloodGroup = $_POST['BloodGroup'];
}
$MaritalStatus = "";
if(isset($_POST['MaritalStatus'])){
$MaritalStatus = $_POST['MaritalStatus'];
}
$Gender = "";
if(isset($_POST['Gender'])){
$Gender = $_POST['Gender'];
}
$EducationDetails = "";
if(isset($_POST['EducationDetails'])){
$EducationDetails = $_POST['EducationDetails'];
}
$ContactNumber= "";
if(isset($_POST['ContactNumber'])){
$ContactNumber = $_POST['ContactNumber'];
}
$AlternativeNumber= "";
if(isset($_POST['AlternativeNumber'])){
$AlternativeNumber = $_POST['AlternativeNumber'];
}
$Emailid= "";
if(isset($_POST['Emailid'])){
$Emailid = $_POST['Emailid'];
}
$TotalYearOfExperience = "";
if(isset($_POST['TotalYearOfExperience'])){
$TotalYearOfExperience = $_POST['TotalYearOfExperience'];
}
$ReleventYearOfExperience = "";
if(isset($_POST['ReleventYearOfExperience'])){
$ReleventYearOfExperience = $_POST['ReleventYearOfExperience'];
}
$PreviousCompanyDetails = "";
if(isset($_POST['PreviousCompanyDetails'])){
$PreviousCompanyDetails = $_POST['PreviousCompanyDetails'];
}
$PANnumber = "";
if(isset($_POST['PANnumber'])){
$PANnumber = $_POST['PANnumber'];
}
$PassportNumber = "";
if(isset($_POST['PassportNumber'])){
$PassportNumber = $_POST['PassportNumber'];
}
$UANnumber= "";
if(isset($_POST['UANnumber'])){
$UANnumber = $_POST['UANnumber'];
}
$AadharNumber= "";
if(isset($_POST['AadharNumber'])){
$AadharNumber = $_POST['AadharNumber'];
}
$PresentAddress= "";
if(isset($_POST['PresentAddress'])){
$PresentAddress = $_POST['PresentAddress'];
}
$PermanentAddress= "";
if(isset($_POST['PermanentAddress'])){
$PermanentAddress = $_POST['PermanentAddress'];
}
$Qualification = "";
if(isset($_POST['Qualification1'])){
$Qualification = $_POST['Qualification1'];
}
$Years= "";
if(isset($_POST['Years1'])){
$Years = $_POST['Years1'];
}
$University = "";
if(isset($_POST['University1'])){
$University = $_POST['University1'];
}
$Percentage = "";
if(isset($_POST['Percentage1'])){
$Percentage = $_POST['Percentage1'];
}
/*if(isset($_POST['submit']))
{
$image=null;
if(getimagesize($_FILES['image']['tmp_name'])== FALSE )
{
echo "please select an image.";
}
else
{
$image=addslashes($_FILES['image']['tmp_name']);
$name=addslashes($_FILES['image']['name']);
$image=file_get_contents($image);
$image=base64_encode($image);
echo $image;
//echo $name;
saveimage($name,$image);
echo"ss";
}
}
function saveimage()
{
echo"called";
}*/
/* $dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$db = "sff";
$conn = new mysqli($dbhost, $dbuser, $dbpass,$db) or die("Connect failed: %s\n". $conn -> error);
if($conn){
echo "connected success";
}
$qry="insert into image (name,image) values ('$name','$image')";
if ($conn->query($qry) === TRUE) {
echo "image uploaded successfully";
}
else
echo "<br/>image not uploaded.";
*/
//echo $username; echo "<br/>";
echo $FirstName;
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$db = "sff";
$conn = new mysqli($dbhost, $dbuser, $dbpass,$db) or die("Connect failed: %s\n". $conn -> error);
if($conn){
echo "connected success";
}
try{
$sql = "INSERT INTO employeeinfoo (EmployeeID,FirstName,MiddleName,LastName,FatherName,SpouseName,MotherName,DateOfBirth,Age,BloodGroup,MaritalStatus,Gender,ContactNumber,AlternativeNumber,Emailid,TotalYearOfExperience,ReleventYearOfExperience,PreviousCompanyDetails,PANnumber,PassportNumber,UANnumber,AadharNumber,PresentAddress,PermanentAddress)
VALUES('$EmployeeID','$FirstName','$MiddleName','$LastName','$FatherName','$SpouseName','$MotherName','$DateOfBirth','$Age','$BloodGroup','$MaritalStatus','$Gender','$ContactNumber','$AlternativeNumber','$Emailid','$TotalYearOfExperience','$ReleventYearOfExperience','$PreviousCompanyDetails','$PANnumber','$PassportNumber','$UANnumber','$AadharNumber','$PresentAddress','$PermanentAddress')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
}
else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
for($i=1;$i<=4;$i++){
$qa="Qualification".$i;
$Qualification = "";
if(isset($_POST['Qualification1'.$i])){
$Qualification = $_POST['Qualification'.$i];
}
echo"-----------";
echo $Qualification;
$Years= "";
if(isset($_POST['Years'.$i])){
$Years = $_POST['Years'.$i];
}
$University = "";
if(isset($_POST['University'.$i])){
$University = $_POST['University'.$i];
}
$Percentage = "";
if(isset($_POST['Percentage'.$i])){
$Percentage = $_POST['Percentage'.$i];
}
echo"222222222";
echo $Qualification;
if($Qualification != null){
echo "333333333";
$qry = "INSERT INTO emp_qualification(EmployeeID,Qualification,Years,University,Percentage)
VALUES('$EmployeeID','$Qualification','$Years','$University','$Percentage')";
if ($conn->query($qry)==TRUE){
echo " qulaification details added successfully";
}
else
echo "<br/> not added.";
}
}
$conn->close(); }
catch(PDOException $e)
{
echo $sql . "<br>" . $e->getMessage();
}
//$result = $conn->query($sql);
// return $conn;?
?>
details.php
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.