<?php
  session_start();
  if(isset($_SESSION['username'])!=""){
    header("Location: index.php");
  }
  require_once 'dbconnect.php';

    $username = strip_tags($_POST['username']);
    $email = strip_tags($_POST['email']);
    $upassword = strip_tags($_POST['password']);
    $medic = strip_tags($_POST['medic_input']);

    $username = $dbcon->real_escape_string($username);
    $email = $dbcon->real_escape_string($email);
    $upassword = $dbcon->real_escape_string($upassword);

    $check_email = $dbcon -> query("SELECT username from tbl_users WHERE username='$username'");
    $count=$check_email->num_rows;
    var_dump($count);
    if($count==0){
        $query = "INSERT INTO tbl_users(username,password,email,medic) VALUES ('$username','$upassword','$email,'$medic')";
        var_dump($query);
          if($dbcon->query($query) === TRUE){
            header('Location: login.php');
          }
          else {
            echo "Error while registering. Please try again!";
            var_dump($dbcon->query($query));
          }
      }
      else {
        echo "Your username already exists!";
        }

    $dbcon->close();
 ?>