<?php 
include("include/connect.php");

     if(isset($_POST['submit'])){
         $name= $_POST['name'];
         $mobile= $_POST['mobile'];
         $state_id= $_POST['state_id'];
         $city_id= $_POST['city_id'];
         $address= $_POST['address'];
         $role= $_POST['role'];
         $email= $_POST['email'];
         $password= $_POST['password'];
         
     
$sql="SELECT * FROM `user` WHERE `email`='$email';";                            
        $run= mysqli_query($db,$sql);
        $row= mysqli_num_rows($run); 
        if($row>0){
        echo "<script> alert('User with this Email ID already registered.')</script>";
        echo "<script> window.open('user.php','_self')</script>";
       }
     else{
         $admin_query="INSERT INTO `user`(`name`, `mobile`, `state`, `user_city_id`, `address`, `email`, `password`, `role`) VALUES ('$name', '$mobile', '$state_id', '$city_id', '$address', '$email','$password', '$role' )";
    $run= mysqli_query($db,$admin_query);
    //  $latID=mysqli_insert_id($db);

    //  echo "$latID";
    // exit();
    echo "<script> alert('User Created Sucsessfuly.')</script>";
       //----------------------------------registration mail code start------------------------------------------------------//
      $to = $email;
       $subject = 'User Registered';
        $headers = "From: usyadav2007@gmail.com \r\n";
         $headers .= "Reply-To: ". strip_tags($email) . "\r\n";
          $headers .= "MIME-Version: 1.0\r\n";
           $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
            $Mailsubject = "Registretion  ".$name;
      $message = "<p>Dear User you registerd with Metha-Q-Lab</p>                        
      <table width='100%' border='0' cellspacing='5' cellpadding='5'>
        <tr><td><strong> Your Account Detail is:</strong></td></tr>
         <tr><td>-----------------------------</td></tr>
          <tr><td><b> Email(Username)</b> : $email </td></tr>
           <tr><td><b>Password </b>: $password </td></tr>  
            <tr><td>-----------------------------</td></tr>
             <tr><td><strong> Thanks & Regard-</strong></td></tr>
              <tr><td>Suppot Team: +91- 8849480304</td></tr>
               <tr><td>Metha-Q-Lab</td></tr>
                </table>";
    mail($to, $Mailsubject, $message, $headers);
  header("location:user.php");
    }

	}   
?>