ESH/save_guest.php

37 lines
1.5 KiB
PHP
Raw Permalink Normal View History

2024-10-23 18:28:06 +05:30
<?php
include('includes/config/config.php');
$id = $_POST['id'];
$fname =$_POST['fname'];
$lname =$_POST['lname'];
$father_name=$_POST['father_name'];
$age = $_POST['age'];
$gender = $_POST['gender'];
$primary_phone = $_POST['primary_phone'];
$address = $_POST['address'];
$aadhar_no = $_POST['aadhar_no'];
$email_id = $_POST['email_id'];
$blood_group = $_POST['blood_group'];
$associated_emp = $_POST['associated_emp'];
$emp_relationship_type = $_POST['emp_relationship_type'];
$initial_query="";
$endquery="";
//$initial_query=" fname = '$fname',lname = '$lname',father_name = '$father_name', age='$age', gender = '$gender',emp_relationship_type='$emp_relationship_type', associated_emp='$associated_emp',primary_phone = '$primary_phone',address = '$address',aadhar_no = '$aadhar_no',blood_group = '$blood_group',modified_by = '".$_SESSION['user_id']."'";
if(!empty($id)){
$initial_query= "update ";
$endquery=" where id = '".$id."' ";
}
else {
$initial_query = " insert into ";
}
$query=$initial_query." guest_patient set fname = '$fname',lname = '$lname',father_name = '$father_name', age='$age', email_id='$email_id',gender = '$gender',emp_relationship_type='$emp_relationship_type', associated_emp_id='$associated_emp',primary_phone = '$primary_phone',address = '$address',aadhar_no = '$aadhar_no',blood_group = '$blood_group',modified_by = '".$_SESSION['user_id']."'".$endquery;
//echo $query;
if (!$result = @mysqli_query($conn,$query)) {
exit(mysqli_error($conn));
}
?>