$value) { $requestStr .= $key . " : " . $value . "\n"; error_log($key . " : " . $value . "
\r\n"); } error_log("End Printing Request Attributes"); save_log($requestStr, 'Ambulance Move', 'SAVE', 'save_ambulance_details.php'); $noOfRows = $_POST['count_items']; $dis_agncy = $_POST['dis_agncy']; //ech "hello".$noOfRows; //$waste_id = $_POST['waste_id']; //echo $ambulance_id; //echo $procurement_refno; $query_initial = ""; $endquery = ""; begin(); if (!empty($ambulance_usage_id)) { $query_initial = "update "; $endquery = " where ambulance_usage_id = '" . $ambulance_usage_id . "' "; } else { $query_initial = "insert into "; } $dateENTRY = $_REQUEST['ambulance_date']; $query = $query_initial . " ambulance_usage_details set usage_date=STR_TO_DATE('" . $dateENTRY . "','%d/%m/%Y'),paramedic_id='" . $_REQUEST['paramedic_id_str'] . "', driver_id ='" . $_REQUEST['ambulance_driver'] . "',city_id ='" . $city . "',ambulance_from = '" . $_REQUEST['ambulance_from'] . "',ambulance_to ='" . $_REQUEST['ambulance_to'] . "',ambulance_out_km='" . $_REQUEST['ambulance_out_km'] . "',ambulance_in_km='" . $_REQUEST['ambulance_in_km'] . "',ambulance_total_km='" . $_REQUEST['ambulance_total_km'] . "',ambulance_out_time='" . $_REQUEST['ambulance_out_time'] . "',ambulance_in_time='" . $_REQUEST['ambulance_in_time'] . "',duty_type='" . $_REQUEST['ambulance_duty'] . "',ambulance_used='" . $_REQUEST['ambulance_used'] . "',ambulance_details='" . $_REQUEST['ambulance_details'] . "',ambulance_id='" . $_REQUEST['ambulance_number'] . "',modified_by = '" . $_SESSION['user_id'] . "' ,patient_id = '" . $_REQUEST['patient_name'] . "',ohc_type_id='" . $_SESSION['current_ohcttype'] . "' " . $endquery; //echo $query; error_log($query); if (!$result = mysqli_query($conn, $query)) { rollback(); exit(mysqli_error($conn)); } commit();