Link to home
Start Free TrialLog in
Avatar of Akhil Vinay Mandava
Akhil Vinay MandavaFlag for India

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;?
 ?>

Open in new window

details.php
ASKER CERTIFIED SOLUTION
Avatar of Julian Hansen
Julian Hansen
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial