<?php
session_start();

// include("Admin/inc/db.php");
include("Admin/Includes/db.php");

 // include'../compression.php';



// $uid = $_SESSION["userId"];



 date_default_timezone_set('Asia/Kolkata');

 $cudate = date("Y-m-d H:i:s") ;



extract($_POST);

 $rand_no = rand(10000, 99999);



          $otp = $rand_no;

// print_r($_POST);


   $single_user = "SELECT * FROM `tbl_user` WHERE email ='$email'";
	 $single_user_r = mysqli_query($con,$single_user);
	 $numrow = mysqli_num_rows($single_user_r);
	 if($numrow > 0)
	 {
	 		
    		echo "<script>;
       alert('This email id is already registered ');
                window.location.href='register.php';
                </script>";
	 }
    else
    {


 $SQL = "INSERT INTO tbl_user set fname='$fname',lname='$lname',email='$email',phone='$phone',state='$state',city='$city',password='$password',edt='$cudate'

";

    
// exit();
    

          if ($con->query($SQL) === TRUE) {

             

              $last_id = $con->insert_id;
            
              

              $_SESSION['userid'] = $last_id;



                        $_SESSION['flash_message'] = 'useradd';

       

        

       echo "<script>;

                window.location.href='index.php';

                </script>";



   }

   else

   {

      echo "<script>;

                window.location.href='register.php';

                </script>";

   }

  
}




?>