prepare("SELECT id FROM student_documents WHERE enroll_no = ?");
$check->bind_param("s", $enroll);
$check->execute();
$check->store_result();
if ($check->num_rows > 0) {
echo "❌ Enrollment number already submitted!
";
} else {
function uploadFile($fieldName, $division, $subfolder, $enroll, $exts){
if(isset($_FILES[$fieldName]) && $_FILES[$fieldName]['error']==0){
$baseDir="uploads/".$division."/".$subfolder."/";
if(!file_exists($baseDir)){
mkdir($baseDir,0777,true);
}
$ext=strtolower(pathinfo($_FILES[$fieldName]["name"],PATHINFO_EXTENSION));
if(!in_array($ext,$exts)) return null;
$filename=$enroll."_".$fieldName.".".$ext;
$targetFile=$baseDir.$filename;
move_uploaded_file($_FILES[$fieldName]["tmp_name"],$targetFile);
return $targetFile;
}
return null;
}
$ppt=uploadFile('ppt',$division,'ppt',$enroll,['ppt','pptx','pdf']);
$doc=uploadFile('document',$division,'doc',$enroll,['doc','docx','pdf']);
$undertaking=uploadFile('undertaking',$division,'undertaking',$enroll,['pdf','doc','docx']);
$certificate=uploadFile('certificate',$division,'certificate',$enroll,['pdf','doc','docx','jpg','jpeg','png']);
$stmt=$conn->prepare("INSERT INTO student_documents (division,name,roll_no,enroll_no,company_name,company_address,student_contact,company_contact,start_date,end_date,hours,ppt_file,document_file,undertaking_file,certificate_file) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
$stmt->bind_param("sssssssssssssss",$division,$name,$roll,$enroll,$company,$company_address,$student_contact,$company_contact,$start_date,$end_date,$hours,$ppt,$doc,$undertaking,$certificate);
$stmt->execute();
echo "✅ Files uploaded successfully!
";
}
}
?>
Student Document Upload
📁 Domain Specific Internship / Social Immersion - Documents
