<?php

$name = $_POST['name'];
$enroll = $_POST['enroll'];
$mob = $_POST['mob'];
$email = $_POST['email'];
$fname = $_POST['fname'];
$branch = $_POST['branch'];
$marks = $_POST['marks'];
$py = $_POST['py'];
$wp = $_POST['wp'];
$dg = $_POST['dg'];
$au = $_POST['au'];
$fb = $_POST['fb'];

$pic = $_FILES['pic']['name'];
$pic_name = 'alumni'.rand(000,999).rand(000,999).$pic;
$pic_type = $_FILES['pic']['type'];
$pic_tmp = $_FILES['pic']['tmp_name'];


$cv = $_FILES['cv']['name'];
$cv_name = 'alumni_cv'.rand(000,999).rand(000,999).$cv;
$cv_type = $_FILES['cv']['type'];
$cv_tmp = $_FILES['cv']['tmp_name'];



include("../admin/connection.php");


if(($pic_type=='image/png' || $pic_type=='image/jpg' || $pic_type=='image/jpeg') and ($cv_type=='application/pdf')){

        if(move_uploaded_file($pic_tmp,"../admin/alumni_pic/".$pic_name) and move_uploaded_file($cv_tmp,"../admin/alumni_cv/".$cv_name)){
        $q_ins = "insert into tbl_alumni (name, enrollment, fname, branch, year, mob, email, marks, company, designation, feedback, about, pic, cv, date, status) values('$name', '$enroll', '$fname', '$branch', '$py', '$mob', '$email', '$marks', '$wp', '$dg', '$fb', '$au', '$pic_name', '$cv_name', now(), 'N')";

       

        // echo $q_ins;
        if(mysqli_query($dbCon, $q_ins)){
            header("location:regalumni.php?msg=Your Request Sent");         
        }else{
            header("location:regalumni.php?msg=Sorry Something Went Wrong");
        }
    }else{
        header("location:regalumni.php?msg=Sorry Files Not Uploaded");
    }
    
}else{
    header("location:regalumni.php?msg=please choose correct file types");
}



?>