<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

include "db-con.php";

$randomNumber = rand(100,999);

if (isset($_REQUEST['submit'])) {
	$trainee_id = "AIST-".$randomNumber;
	$trainee_name = $_POST['trainee_name'];
	$trainee_designation = $_POST['trainee_designation'];
	$trainee_location = $_POST['trainee_location'];
	// $trainee_signature = $_POST['trainee_signature'];

    $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);

  	if(move_uploaded_file($_FILES['trainee_signature']['tmp_name'], $target_path)){

	$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($insertData) or die("query error");
	
	    if ($result == TRUE) {

	        $con->close();	

	    	header("Location: https://ais.org.in/digitalcertificate/trainee_add.php");
	        exit;
	   	

		}else{


		}


	}else{

		echo "cannot upload file";
	}



}else{

	echo "No post";
}






?>