30 lines
978 B
PHP
30 lines
978 B
PHP
<?php
|
|
include('includes/config/config.php');
|
|
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
|
|
$checkup_mgmt_id = $_POST['checkup_mgmt_id'];
|
|
//echo $id ;
|
|
$checkup_mgmt_name =$_POST['checkup_mgmt_name'];
|
|
$from_date =$_POST['from_date'];
|
|
$to_date =$_POST['to_date'];
|
|
$checkup_by =$_POST['checkup_by'];
|
|
$checkup_location=$_POST['checkup_location'];
|
|
$remarks=$_POST['remarks'];
|
|
if(!empty($checkup_mgmt_id)){
|
|
//update case
|
|
$initquery = "update ";
|
|
$endquery=" where checkup_mgmt_id = '".$checkup_mgmt_id."' ";
|
|
|
|
}
|
|
else {
|
|
//insert case
|
|
$initquery = "INSERT INTO ";
|
|
$endquery="";
|
|
}
|
|
|
|
$query = $initquery." checkup_list_mgmt set checkup_mgmt_name='$checkup_mgmt_name',from_date=STR_TO_DATE('".$_POST['from_date']."', '%d/%m/%Y') , to_date=STR_TO_DATE('".$_POST['to_date']."', '%d/%m/%Y'), checkup_by='$checkup_by',checkup_location='$checkup_location',remarks='$remarks' ".$endquery ;
|
|
echo $query;
|
|
$result = @mysqli_query($conn,$query);
|
|
echo json_encode($training_id);
|
|
?>
|
|
|