<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

include "db-con.php";

if (isset($_REQUEST['submit'])) {
	$trainee_name = $_POST['trainee_name'];
	$trainee_designation = $_POST['trainee_designation'];
	$trainee_location = $_POST['trainee_location'];
	// $trainee_signature = $_POST['trainee_signature'];
	$trainee_id_num = $_POST['trainee_id_num'];

    $name = $_FILES['trainee_signature']['name'];
    $trainee_signature = $_FILES['trainee_signature']['type'];
    $tmp_name = $_FILES['trainee_signature']['tmp_name'];
    $target_path = "images/signature/";
    $target_path = $target_path.basename($name);

    // var_dump();

  	if(move_uploaded_file($_FILES['trainee_signature']['tmp_name'], $target_path)){

	// $updateData = "UPDATE trainee SET trainee_id = 'AIST-925', name= 'smita', designation= 'doctor', location= 'mumbai', signature_image= '001', signature_name= '002' WHERE trainee_id = 'AIST-925'";


	$updateData = "UPDATE trainee SET trainee_id = '$trainee_id_num', name= '$trainee_name', designation= '$trainee_designation', location= '$trainee_location', signature_image= '$trainee_signature', signature_name= '$name' WHERE trainee_id = '$trainee_id_num'";

	// $insertData = "INSERT INTO `trainee` (`trainee_id`, `name`, `designation`, `location`, `signature_image`, `signature_name`) VALUES ('$trainee_id', '$trainee_name', '$trainee_designation', '$trainee_location', '$trainee_signature', '$name')";

    $result = $con->query($updateData) or die("query error");
	
	    if ($result == TRUE) {

	        $con->close();	

	    	header("Location: https://ais.org.in/digitalcertificate/trainee_edit.php?id=$trainee_id_num");
	        exit;
	   	

		}else{


		}


	}else{

		echo "cannot upload file";
	}



}else{

	echo "No post";
}






?>