doctorSignup.php

<?php

require "connection.php";

header('location:index.php');

$name = $_POST['username'];
$email = $_POST['email'];
$pass = $_POST['password'];
$phone = $_POST['phone'];

$q = " select * from doctors where name = '$name' && email = '$email' ";

$result = mysqli_query($con, $q);

$num = mysqli_num_rows($result);

if ($num == 1) {
    echo " user already present";
} else {
    $qy = " insert into doctors(name , email , phone_no , password) values('$name', '$email', '$phone', '$pass') ";
    mysqli_query($con, $qy);
    $result = mysqli_query($con, $q);
    while ($row = mysqli_fetch_assoc($result)) {
        $_SESSION['currentUser_id'] = $row['doctor_id'];
        $_SESSION['currentUser'] = $row['name'];
        $_SESSION['currentUserEmail'] = $row['email'];
        $_SESSION['user'] = "Doctor";
        header('location:index.php');
    }
}


?>