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());