<?php
    $servername='localhost:3308';
    $username='root';
    $password='';
    $dbname = "abhinav_aimba";
    $conn=mysqli_connect($servername,$username,$password,"$dbname");
	if(!$conn){
	  die('Could not Connect MySql Server:' .mysql_error());
	}
	
	//if(!empty($_POST["submit"])) {
		if(isset($_POST['contactFrmSubmit']) && !empty($_POST['coursename']) && !empty($_POST['fullname']) && !empty($_POST['email']) && (!filter_var($_POST['email'], FILTER_VALIDATE_EMAIL) === false) && !empty($_POST['phone']) && !empty($_POST['address']) && !empty($_POST['qualification']) && !empty($_POST['category'])){

		$coursename = $_POST["coursename"];
		$fullname = $_POST["fullname"];
		$email = $_POST["email"];
		$phone = $_POST["phone"];
		$address = $_POST["address"];
		$qualification = $_POST["qualification"];
		$category = $_POST["category"];
		
		$sql = "INSERT INTO admission_request_list (coursename, fullname, email, phone, address, qualification, category) VALUES ('$coursename','$fullname','$email','$phone','$address','$qualification','$category')";
         
        if(mysqli_query($conn, $sql)){
            echo "<div class='alert alert-success'>Thank you, Admission request submitted successfully!!!</div>";
 
        } else{
            echo "<div class='alert alert-danger'>ERROR: Hush! Sorry $sql. "
                . mysqli_error($conn) ."</div>";
        }
         
        // Close connection
        mysqli_close($conn);
	}
?>