<?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'];
	$address_first = $_POST['address_first'];
	$address_second = $_POST['address_second'];
	$town = $_POST['town'];	
	$city = "Mumbai";
	$country = "India";
	$postal_code = $_POST['postal_code'];

    $insertData = "INSERT INTO `event` (`event_id`, `name`, `date`, `start_time`, `end_time`, `address_one`, `address_two`, `town`, `city`, `country`, `postal_code`) VALUES ('$event_id', '$event_name', '$date', '$start_time', '$end_time', '$address_first', '$address_second', '$town', '$city', '$country', '$postal_code')";

    $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{


	}




}










?>