53 lines
1.4 KiB
PHP
53 lines
1.4 KiB
PHP
|
<?php
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include ('includes/functions.php');
|
||
|
|
include ('log_entry.php');
|
||
|
|
error_log ( "Start Printing Request Attributes" );
|
||
|
|
$requestStr="";
|
||
|
|
foreach ( $_REQUEST as $key => $value ) {
|
||
|
|
$requestStr.=$key . " : " . $value . "\n";
|
||
|
|
error_log ( $key . " : " . $value . "<br />\r\n" );
|
||
|
|
}
|
||
|
|
error_log ( "End Printing Request Attributes" );
|
||
|
|
save_log($requestStr,'indication','SAVE','save_indication_list.php');
|
||
|
|
$noOfRows=$_POST['count_items'];
|
||
|
|
error_log("rows: ".$noOfRows);
|
||
|
|
|
||
|
|
$id = $_POST['indication_id'];
|
||
|
|
for($i=0;$i<$noOfRows;$i++){
|
||
|
|
|
||
|
|
error_log("INTO THE FOR LOOP");
|
||
|
|
$id_str="indication_id".$i;
|
||
|
|
$id=$_REQUEST[$id_str];
|
||
|
|
// echo $id;
|
||
|
|
error_log("indication_id".$id);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//echo $procurement_refno;
|
||
|
|
$query_initial="";
|
||
|
|
$endquery="";
|
||
|
|
begin();
|
||
|
|
if(!empty($id)){
|
||
|
|
$query_initial="update ";
|
||
|
|
$endquery=" where indication_id = '".$id."' ";
|
||
|
|
}else{
|
||
|
|
$query_initial="insert into ";
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
$query=$query_initial." indication set indication_name ='".${"indication_name$i"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery;
|
||
|
|
|
||
|
|
// echo $query;
|
||
|
|
error_log("MY INDICATION QUERY -> " . $query);
|
||
|
|
if (!$result = @mysqli_query($conn,$query)) {
|
||
|
|
error_log("NOT INSERTED-> " . mysqli_error($conn));
|
||
|
|
rollback();
|
||
|
|
exit(error_log(mysqli_error($conn)));
|
||
|
|
}else{
|
||
|
|
error_log("INDOCATION EXEC");
|
||
|
|
}
|
||
|
|
}
|
||
|
|
commit();
|
||
|
|
?>
|
||
|
|
|