$check = emailcheck($email);
$checkno = numbercheck($cno);
if ($check == 'yes') {
echo '<script>alert("Email already exists!");</script>';
} elseif ($checkno == 'yes') {
echo '<script>alert("Contact number already exists!");</script>';
} else {
$insert = "INSERT INTO `user`(`first_name`, `last_name`, `email`, `gender`, `user_type`, `is_active`, `password`, `contact_number`, `Address`, `dob`) VALUES ('{$fname}', '{$lname}','{$email}','{$sex}', 'D', '2', '{$password}', '{$cno}','{$add}','{$dob}')";
$result = register($insert);
$doctor = "INSERT INTO `doctor`(`user_id`, `specialization`, `account_no`, `bank`,`address`, `quali`) VALUES ('{$result['0']}', '{$sp}', '{$accno}','{$bank}','{$cadd}', '{$quali}')";
$result2 = registerd($doctor);
$name = $fname . " " . $lname;
$insert2 = "INSERT INTO `doc_pay`(`doc_id`, `doc_name`, `user_id`) VALUES ('{$result2['0']}', '{$name}', '{$result['0']}')";
docpay($insert2);
$charges = "INSERT INTO `doctor_charges`( `doctor_id`, `channeling_fee`) VALUES ('{$result2['0']}', '{$cf}')";
$result3 = registerd($charges);
$ch_id = $result3[0];
$dc_id = $result2[0];
update_cid($ch_id, $dc_id);
echo "<script type='text/javascript'>alert('" . $result3[1] . "')</script>";
}
} elseif (isset($_POST['submit3'])) {
$email = sql_escape($_POST['email']);
$password = md5(sql_escape($_POST['password']));
$email2 = sql_escape($_POST['email2']);
$password2 = md5(sql_escape($_POST['password2']));
$fname = sql_escape($_POST['fname']);
$lname = sql_escape($_POST['lname']);
$sex = sql_escape($_POST['sex']);
$cno = sql_escape($_POST['cno']);
$quali = sql_escape($_POST['quali']);
$insert = "UPDATE `user` SET `first_name`='{$fname}',`last_name`='{$lname}',`contact_number`='{$cno}',`Address`='{$add}' WHERE user_id='{$userid}'";
registerd($insert);
} else {
$insert = "UPDATE `user` SET `first_name`='{$fname}',`last_name`='{$lname}',`email`='{$email}',`contact_number`='{$cno}',`Address`='{$add}' WHERE user_id='{$userid}'";
registerd($insert);
}
if ($_POST['password'] != '') {
$insert = "UPDATE `user` SET `password`='{$password}' WHERE user_id='{$userid}'";
registerd($insert);
}
$doctor = "UPDATE `doctor` SET `specialization`='{$sp}',`account_no`='{$accno}',`bank`='{$bank}',`address`='{$cadd}', `quali`= '{$quali}' WHERE `user_id`='{$userid}'";
registerd($doctor);
$seelctDcId = "select doctor_id from doctor where user_id='{$userid}'";
$result = fetchOne($seelctDcId);
$charges = "UPDATE `doctor_charges` SET `channeling_fee`='{$cf}' WHERE doctor_id='{$result['0']}'";
registerd($charges);
$seelctDchrgesId = "select charges_id from doctor_charges where user_id='{$result['0']}'";
$result3 = fetchOne($seelctDcId);
$ch_id = $result3[0];
$dc_id = $result[0];
update_cid($ch_id, $dc_id);
$message = 'User id: ' . $userid . ' has been updated.';
echo "<script type='text/javascript'>alert('{$message}');</script>";
// echo "<div>";
// echo " <h5 style='text-align: center;top: 210px;position: absolute;left: 0;margin: auto;width: 100%;'><font color=red>" . $result3[1] . "</font></h5>";
// echo "</div>";
} else {
echo "<script type='text/javascript'>alert('Email is already registered');</script>";
}
}
function delete($no)
