if ($password != $password2) {
echo "<script type='text/javascript'>alert('Passwords do not match');</script>";
} elseif ($re != 'yes') {
if ($email == '') {
$update = "UPDATE `user` SET `first_name`='{$fname}',`last_name`='{$lname}',`contact_number`='{$cno}',`Address`='{$add}' WHERE user_id='{$userid}'";
registerc($update);
} else {
$update = "UPDATE `user` SET `first_name`='{$fname}',`last_name`='{$lname}',`email`='{$email}',`contact_number`='{$cno}',`Address`='{$add}' WHERE user_id='{$userid}'";
registerc($update);
}
if ($_POST['password'] != '') {
$update = "UPDATE `user` SET `password`='{$password}' WHERE user_id='{$userid}'";
registerc($update);
}
$mc = "UPDATE `medical_c` SET `acc_no`='{$accno}',`bank`='{$bank}', `qualifications`= '{$quali}' WHERE `user_id`='{$userid}'";
registerc($mc);
$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)
{
require_once "../includes/sql.php";
$conexion = db_connect();
$sql = "DELETE FROM user WHERE user_id='" . $no . "'";
$result = $conexion->query($sql) or die("oopsy, error when tryin to delete ");
$quali = sql_escape($_POST['quali']);
$add = sql_escape($_POST['add']);
$bank = sql_escape($_POST['bank']);
$accno = sql_escape($_POST['accno']);
$dob = sql_escape($_POST['year']) . '-' . sql_escape($_POST['month']) . '-' . sql_escape($_POST['day']);
$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}', 'G', '2', '{$password}', '{$cno}', '{$add}','{$dob}')";
$result = register($insert);
$medcon = "INSERT INTO `medical_c`( `user_id`, `qualifications`, `acc_no`, `bank`) VALUES ('{$result['0']}', '{$quali}','{$accno}','{$bank}')";
$result2 = registerc($medcon);
echo "<script type='text/javascript'>alert('" . $result2[1] . "')</script>";
}
}
require_once "includes/header.php";
//require_once("includes/header2.php");
?>
<!--=========== END HEADER SECTION ================-->
<script type="text/javascript" language="JavaScript">
$(document).ready(function () {
$('#submit1').click(function (e) {
var input = new Array();
$('#patform input, #patform select').each(function (index) {
input[index] = $(this);
// alert('Type: ' + input.attr('type') + ' Name: ' + input.attr('name') + ' Value: ' + input.val());
