47 lines
1.7 KiB
PHP
47 lines
1.7 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
|
|
$test_count=$_POST['count_items'];
|
|
|
|
$vac_d1 = $_POST['vac_date1'];
|
|
$vac_d2 = $_POST['vac_date2'];
|
|
|
|
error_log("vac d1: ". $vac_date1);
|
|
error_log("vac d2: ". $vac_date2);
|
|
|
|
//echo "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 ";
|
|
// }
|
|
|
|
|
|
// $query=$query_initial." ambulance_details set ambulance_date=STR_TO_DATE('".${"ambulance_date$i"}."','%d/%m/%Y'), ambulance_driver ='".${"ambulance_driver$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"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery;
|
|
|
|
// echo $query;
|
|
|
|
// if (!$result = @mysqli_query($conn,$myconn,$query)) {
|
|
// rollback();
|
|
// exit(mysqli_error($conn));
|
|
// }
|
|
// }
|
|
// commit();
|
|
?>
|
|
|