<?php

include "dbconnect.php";

$username = mysqli_real_escape_string($con,$_POST['username']);
$email = mysqli_real_escape_string($con,$_POST['useremail']);
$password = mysqli_real_escape_string($con,$_POST['password']);
$cpassword = mysqli_real_escape_string($con,$_POST['cpassword']);
$location = mysqli_real_escape_string($con,$_POST['location']);
$student= mysqli_real_escape_string($con,$_POST['student']);
$collage= mysqli_real_escape_string($con,$_POST['collage']);
$organisation= mysqli_real_escape_string($con,$_POST['organisation']);
$date= mysqli_real_escape_string($con,$_POST['years']);
$purpose= mysqli_real_escape_string($con,$_POST['purpose']);
$phone= mysqli_real_escape_string($con,$_POST['mobile']);


ob_start();  // Output buffering start

if ($password == $cpassword) {
    $sql = "insert into user_register(username, email,password,location,student,collage,organisation,years,purpose,mobile,status) 
            VALUES ('$username','$email','$password','$location','$student','$collage','$organisation','$date','$purpose','$phone',1)";
    
   
            mysqli_query($con,$sql);
            
    
            echo "Thank you for registration.";
        }else{
            echo "Password not matched.";
        }
        

?>