$value ) { $requestStr.=$key . " : " . $value . "\n"; error_log ( $key . " : " . $value . "
\r\n" ); } error_log ( "End Printing Request Attributes" ); save_log($requestStr,'Task Master','SAVE','save_task.php'); // echo "hello".$noOfRows; $task_id = $_POST['task_id']; // for(=0;<$noOfRows;++){ // $task_id_str="task_id".; // $task_id=$_REQUEST[$task_id_str]; // echo $task_id; // error_log("task_id".$task_id); // get comma saparated weeks day values // $weekly_task_due = implode(",", ${"weekly_task_due"}); //echo $procurement_refno; $query_initial=""; $endquery=""; begin(); if(!empty($task_id)){ $query_initial="update "; $endquery=" where task_id = '".$task_id."' "; }else{ $query_initial="insert into "; } if ( ${"frequency"} == "Daily" ){ $query=$query_initial." task_master set task_name ='".${"task_name"}."', task_description ='".${"task_description"}."', frequency = '".${"frequency"}."', ohc_type ='".${"ohc_type"}."', daily_task_due_time='".${"daily_task_due_time"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery; } if ( ${"frequency"} == "Weekly" ){ $query=$query_initial." task_master set task_name ='".${"task_name"}."', task_description ='".${"task_description"}."', frequency = '".${"frequency"}."', ohc_type ='".${"ohc_type"}."', sun='".${"sun"}."', sun_time='".${"sun_time"}."', mon='".${"mon"}."', mon_time='".${"mon_time"}."', tue='".${"tue"}."', tue_time='".${"tue_time"}."', wed='".${"wed"}."', wed_time='".${"wed_time"}."', thu='".${"thu"}."', thu_time='".${"thu_time"}."', fri='".${"fri"}."', fri_time='".${"fri_time"}."', sat='".${"sat"}."', sat_time='".${"sat_time"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery; } if ( ${"frequency"} == "Fortnight" ){ $query=$query_initial." task_master set task_name ='".${"task_name"}."', task_description ='".${"task_description"}."', frequency = '".${"frequency"}."', ohc_type ='".${"ohc_type"}."', fort_day1_time='".${"fort_day1_time"}."', fort_day1='".${"fort_day1"}."', fort_day2_time='".${"fort_day2_time"}."', fort_day2='".${"fort_day2"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery; } if ( ${"frequency"} == "Monthly" ){ $query=$query_initial." task_master set task_name ='".${"task_name"}."', task_description ='".${"task_description"}."', frequency = '".${"frequency"}."', ohc_type ='".${"ohc_type"}."', monthly_time='".${"monthly_time"}."', monthly_day='".${"monthly_day"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery; } if ( ${"frequency"} == "Quaterly" ){ $query=$query_initial." task_master set task_name ='".${"task_name"}."', task_description ='".${"task_description"}."', frequency = '".${"frequency"}."', ohc_type ='".${"ohc_type"}."', qtrly_m1='".${"qtrly_m1"}."', qtrly_d1='".${"qtrly_d1"}."', qtrly_t1='".${"qtrly_t1"}."', qtrly_m2='".${"qtrly_m2"}."', qtrly_d2='".${"qtrly_d2"}."', qtrly_t2='".${"qtrly_t2"}."', qtrly_m3='".${"qtrly_m3"}."', qtrly_d3='".${"qtrly_d3"}."', qtrly_t3='".${"qtrly_t3"}."', qtrly_m4='".${"qtrly_m4"}."', qtrly_d4='".${"qtrly_d4"}."', qtrly_t4='".${"qtrly_t4"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery; } if ( ${"frequency"} == "Semi Annually" ){ $query=$query_initial." task_master set task_name ='".${"task_name"}."', task_description ='".${"task_description"}."', frequency = '".${"frequency"}."', ohc_type ='".${"ohc_type"}."', sem_ann_m1='".${"sem_ann_m1"}."', sem_ann_d1='".${"sem_ann_d1"}."', sem_ann_t1='".${"sem_ann_t1"}."', sem_ann_m2='".${"sem_ann_m2"}."', sem_ann_d2='".${"sem_ann_d2"}."', sem_ann_t2='".${"sem_ann_t2"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery; } if ( ${"frequency"} == "Annually" ){ $query=$query_initial." task_master set task_name ='".${"task_name"}."', task_description ='".${"task_description"}."', frequency = '".${"frequency"}."', ohc_type ='".${"ohc_type"}."', annual_m='".${"annual_m"}."', annual_d='".${"annual_d"}."', annual_t='".${"annual_t"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery; } // $query=$query_initial." task_master set task_name ='".${"task_name"}."', task_description ='".${"task_description"}."', frequency = '".${"frequency"}."', ohc_type ='".${"ohc_type"}."', daily_task_due_time='".${"daily_task_due_time"}."', sun='".${"sun"}."', sun_time='".${"sun_time"}."', mon='".${"mon"}."', mon_time='".${"mon_time"}."', tue='".${"tue"}."', tue_time='".${"tue_time"}."', wed='".${"wed"}."', wed_time='".${"wed_time"}."', thu='".${"thu"}."', thu_time='".${"thu_time"}."', fri='".${"fri"}."', fri_time='".${"fri_time"}."', sat='".${"sat"}."', sat_time='".${"sat_time"}."', fort_day1_time='".${"fort_day1_time"}."', fort_day1='".${"fort_day1"}."', fort_day2_time='".${"fort_day2_time"}."', fort_day2='".${"fort_day2"}."', monthly_time='".${"monthly_time"}."', monthly_day='".${"monthly_day"}."', qtrly_m1='".${"qtrly_m1"}."', qtrly_d1='".${"qtrly_d1"}."', qtrly_t1='".${"qtrly_t1"}."', qtrly_m2='".${"qtrly_m2"}."', qtrly_d2='".${"qtrly_d2"}."', qtrly_t2='".${"qtrly_t2"}."', qtrly_m3='".${"qtrly_m3"}."', qtrly_d3='".${"qtrly_d3"}."', qtrly_t3='".${"qtrly_t3"}."', qtrly_m4='".${"qtrly_m4"}."', qtrly_d4='".${"qtrly_d4"}."', qtrly_t4='".${"qtrly_t4"}."', sem_ann_m1='".${"sem_ann_m1"}."', sem_ann_d1='".${"sem_ann_d1"}."', sem_ann_t1='".${"sem_ann_t1"}."', sem_ann_m2='".${"sem_ann_m2"}."', sem_ann_d2='".${"sem_ann_d2"}."', sem_ann_t2='".${"sem_ann_t2"}."', annual_m='".${"annual_m"}."', annual_d='".${"annual_d"}."', annual_t='".${"annual_t"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery; // echo $query; error_log($query); if (!$result = @mysqli_query($conn,$query)) { rollback(); exit(mysqli_error($conn)); } // } commit(); ?>