$value ) { $requestStr.=$key . " : " . $value . "\n"; error_log ( $key . " : " . $value . "
\r\n" ); } error_log ( "End Printing Request Attributes" ); save_log($requestStr,'Oxygen Cylinder','SAVE','save_oxygen_cylinder.php'); $query_initial=""; $endquery=""; begin(); if(!empty($id)){ $query_initial="update "; $endquery=" where id = '".$id."' "; }else{ $query_initial="insert into "; } $query=$query_initial." oxygen_cylinder set type='".$_POST['type']."',oxygen_kit_no='".$_POST['cylinder_number']."',date_n_time=STR_TO_DATE('".$_POST['date_n_time']."', '%d/%m/%Y %h:%i %p') ".$endquery; //echo $query; if (!$result = mysqli_query($conn,$query)) { rollback(); exit(mysqli_error($conn)); } commit(); ?>