47 lines
1.6 KiB
PHP
47 lines
1.6 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
error_log("Start Printing Request Attributes");
|
|
$requestStr = "";
|
|
foreach ($_REQUEST as $key => $value) {
|
|
$requestStr .= $key . " : " . $value . "\n";
|
|
error_log($key . " : " . $value . "<br />\r\n");
|
|
}
|
|
error_log("End Printing Request Attributes");
|
|
save_log($requestStr, 'Training List', 'SAVE', 'training_form_script.php');
|
|
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
|
|
begin();
|
|
$training_id = $_POST['training_id'];
|
|
//echo $id ;
|
|
$training_name = $_POST['training_name'];
|
|
$training_description = $_POST['training_description'];
|
|
$training_duration = $_POST['training_duration'];
|
|
$training_mode_id = $_POST['training_mode_id'];
|
|
$training_type_id = $_POST['training_type_id'];
|
|
$key_health_param_sections = implode(",", $_POST['key_health_param_sections']);
|
|
|
|
|
|
if (!empty($training_id)) {
|
|
//update case
|
|
$initquery = "update ";
|
|
$endquery = " where training_master_id = '" . $training_id . "' ";
|
|
} else {
|
|
//insert case
|
|
$initquery = "INSERT INTO ";
|
|
$endquery = "";
|
|
}
|
|
|
|
$query = $initquery . " training_master set training_name='$training_name',description='$training_description', durations='$training_duration',type_of_training='$training_type_id',key_health_param_sections='$key_health_param_sections', mode_of_training='$training_mode_id' " . $endquery;
|
|
error_log("program query: " . $query);
|
|
|
|
if (!$result = @mysqli_query($conn, $query)) {
|
|
error_log("program query error " . mysqli_error($conn));
|
|
rollback();
|
|
} else {
|
|
echo json_encode($training_id);
|
|
}
|
|
commit();
|
|
?>
|
|
|