<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

include "db-con.php";

$randomNumber = rand(100,999);

if (isset($_REQUEST['submit'])) {

	$event_id = "AISE-".$randomNumber;
	$event_name = $_POST['event_name'];
	$date = $_POST['date'];
	$start_time = $_POST['start_time'];
	$end_time = $_POST['end_time'];
	$event_speaker = $_POST['event_speaker'];
	$event_type = $_POST['event_type'];
	$address_first = $_POST['address_first'];

	if($event_name == NULL || $event_speaker == NULL || $event_type == NULL){
        echo '<script language="javascript">';
        echo 'alert("All fields must be filled out"); location.href="https://ais.org.in/digitalcertificate/event_add.php"';
        echo '</script>';
    
    }else{  

			if($event_type == "Offline"){

		 		$insertData = "INSERT INTO `event` (`event_id`, `name`, `date`, `start_time`, `end_time`, `event_speaker`, `event_type`, `address_one`) VALUES ('$event_id', '$event_name', '$date', '$start_time', '$end_time', '$event_speaker', '$event_type', '$address_first')";

			}else{

				 $insertData = "INSERT INTO `event` (`event_id`, `name`, `date`, `start_time`, `end_time`, `event_speaker`, `event_type`, `address_one`) VALUES ('$event_id', '$event_name', '$date', '$start_time', '$end_time', '$event_speaker', '$event_type', 'NIL')";
			}


		    $result = $con->query($insertData) or die("query error");
			
		    if ($result == TRUE) {

		        $con->close();	

		    	header("Location: https://ais.org.in/digitalcertificate/event_add.php");
		        exit;
		   	

			}else{


			}

		}


}





?>