<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 2016-03-24
 * Time: 06:01 PM
 */
session_start();
extract($_POST);
//echo $fileName;
//echo $_FILES['user_file1'];
//die();
//$staffID=$_SESSION['staffID'];
//if($password==$password2) {


    require('../connect.php');
    $db = db_connect();

    $material = $_FILES['user_file1'];
    $folder = "image/";
    $material_name = $_FILES['user_file1']['name'];
$fileT=explode('.',$material_name);
    $material_type = $_FILES['user_file1']['type'];
    $material_tmp = $_FILES['user_file1']['tmp_name'];
    $material_size = $_FILES['user_file1']['size'];
    $old = $_FILES['user_file1']['tmp_name'];

      $new = "../eClass/assignment_Submitted/" .$fileName.'.'.$fileT[1] ;
echo $kk=$fileName.'.'.$fileT[1];


//die();
//echo $file_check="select * from uploading_tb where courseID='$courseID' and mode=2";
//$file_check=$db->query($file_check);
//    $file_count=$file_check->rowCount();
//$file_count+=1;
//if ($file_count>0){
//    $new_filename="course_assignment/2_" .$courseID."_".$file_count.".".$fileT[1];
//}else{
//    $new_filename="course_assignment/2_" .$courseID."_1.".$fileT[1];
//}
//echo $new_filename;
// if (file_exists($new_filename)) {
//     echo
//     "<script>alert('Record Already Exist')</script>
//     header('location:' . 'eClassSubmission.php?id=1')";
// }else {



//    $new = "course_material/" . $courseID . ".jpg";
//     echo $new_filename;
//     die();

$d_time=date("Y-m-d H:i:s");
//echo $new;

     echo $result_insert = "INSERT INTO `assignmentsubmission` (`sn`, `matNo`, `courseID`, `timeSubmited`,`filename`) VALUES (NULL, $matNo,$courseID, CURRENT_TIMESTAMP,$kk)";
//die();
     $result_insert = "INSERT INTO `assignmentsubmission` (`sn`, `matNo`, `courseID`, `timeSubmited`,`filename`) VALUES (NULL, ?,?, CURRENT_TIMESTAMP,?)";
     $result_insert_p = $db->prepare($result_insert);
    $report= $result_insert_p->execute([$matNo, $courseID, $kk]);
//die();
if ($report){
    move_uploaded_file($old, $new);
    header('location:' . 'courseAssignment.php?id=1');
}else{
    header('location:' . 'courseAssignment.php?id=2');
}

//die();


?>