<?php 
session_start();
if (isset($_POST['submitFormBtn'])) {
	require '../include/connection.php';

	$img_name = $_FILES['img']['name'];
	$feature_img = date('ymdhis').''.$img_name;
	$img_tmp_name = $_FILES['img']['tmp_name'];
	$path = "../upload/homework/".$feature_img;

	if(move_uploaded_file($img_tmp_name, $path)){
			$class_name = $_POST['class_name'];
			$student_subject = $_POST['student_subject'];
			$remark = $_POST['remark'];
			$year = $_POST['year'];
			$year = date('Y');
			$created_at = date('Y-m-d H:i:s');
			$updated_at = date('Y-m-d H:i:s');

			$query = $conn->prepare("INSERT INTO homework(class_name,student_subject,question_pdf,remark,year,created_at,updated_at) values(:class_name,:student_subject,:question_pdf,:remark,:year,:created_at,:updated_at)");
			$query->bindParam(':class_name',$class_name);
			$query->bindParam(':student_subject',$student_subject);
			$query->bindParam(':question_pdf',$feature_img);
			$query->bindParam(':remark',$remark);
			$query->bindParam(':year',$year);
			$query->bindParam(':created_at',$created_at);
			$query->bindParam(':updated_at',$updated_at);
			if($query->execute()){		
				$_SESSION['amsg'] = '<div class="alert alert-success alert-dismissible fade show" role="alert"><i class="mdi mdi-check-all me-2"></i>Added Successfully<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button></div>';
				header("location:../homeworkList.php");
			}else{
				$_SESSION['amsg'] = '<div class="alert alert-danger alert-dismissible fade show" role="alert"><i class="mdi mdi-block-helper me-2"></i>Something went wrong<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button></div>';
				header("location:../homeworkList.php");			    			
			}
	}
}else{
	header("location:../login.php");
}





?>