$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']; for($i=0;$i<$noOfRows;$i++){ $ambulance_id_str="ambulance_id".$i; $ambulance_id=$_REQUEST[$ambulance_id_str]; //echo $ambulance_id; //echo $procurement_refno; $query_initial=""; $endquery=""; begin(); if(!empty($ambulance_id)){ $query_initial="update "; $endquery=" where ambulance_id = '".$ambulance_id."' "; }else{ $query_initial="insert into "; } $sql="select ambulance_number FROM ambulance_details_new WHERE id=$ambulance_number"; $sql_new=$sql; $result=mysqli_query($conn,$sql); $row=mysqli_fetch_assoc($result); $ambulance_number=$row['ambulance_number']; error_log("ABCDEHHH".$ambulance_number); $city=$_REQUEST['city_id']; error_log("city".$city); $query=$query_initial." ambulance_details set ambulance_date=STR_TO_DATE('".${"ambulance_date$i"}."','%d/%m/%Y'), ambulance_driver ='".${"ambulance_driver$i"}."',city_id ='".$city."',ambulance_type ='".$_REQUEST['ambulance_type']."',IsChargeable ='".$_REQUEST['IsChargeable']."',patient_id ='".$_REQUEST['patient_id']."',cost ='".${"cost$i"}."',total_cost ='".${"total_cost$i"}."',amb_charge ='".${"amb_charge$i"}."',ambulance_extra_km ='".${"ambulance_extra_km$i"}."',ambulance_from = '".${"ambulance_from$i"}."',ambulance_to ='".${"ambulance_to$i"}."',ambulance_out_km='".${"ambulance_out_km$i"}."',ambulance_in_km='".${"ambulance_in_km$i"}."',ambulance_total_km='".${"ambulance_total_km$i"}."',ambulance_out_time='".${"ambulance_out_time$i"}."',ambulance_in_time='".${"ambulance_in_time$i"}."',ambulance_duty='".${"ambulance_duty$i"}."',ambulance_used='".${"ambulance_used$i"}."',ambulance_details='".${"ambulance_details$i"}."',ambulance_number='".${"ambulance_number"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery; error_log( $query); if (!$result = mysqli_query($conn,$query)) { rollback(); exit(mysqli_error($conn)); } } commit(); ?>