ESH/save_mapping.php
2024-10-23 18:28:06 +05:30

30 lines
894 B
PHP

<?php
include('includes/config/config.php');
include('includes/functions.php');
include('log_entry.php');
$id = $_POST['id'];
$noOfRows = $_POST['count_items'];
error_log("rows" . $noOfRows);
$query_initial = "";
if (!empty($id)) {
$query_initial = "update dignosys_wise_bodysystem ";
$end_query = "where id = '" . $id . "'";
} else {
$query_initial = "insert into dignosys_wise_bodysystem ";
}
for ($i = 0; $i < $noOfRows; $i++) {
$query = $query_initial . " set ailment_id='" . ${"diag_name$i"} . "',ailment_system_id='" . ${"body_name$i"} . "',modified_by = '" . $_SESSION['user_id'] . "'" . $end_query;
error_log("map update/insert query " . $query);
if (!$result = @mysqli_query($conn, $query)) {
error_log("Failed to Update the mapping. Error Found" . mysqli_error($conn) . ". Failing Query:" . $query);
exit(mysqli_error($conn));
}
}
?>