source: schedule/Transaction/update.php@ 16740

<?php
include '../include/factdb.php';



 $Time =$_GET['Time'];
 $SelectedSource = $_GET['Source'];
 $Date = $_GET['Date'];
  
 $SelectedMeasure = $_GET['measure'];
$TimeEX = explode("-",$Date);

$TimeEX2 = "day=".$TimeEX[0]."&month=".$TimeEX[1]."&year=".$TimeEX[2];
 $limtex = count(explode(",",$SelectedSource));
$insertdate = $TimeEX[2]."-".$TimeEX[1]."-".$TimeEx[0];
$value = $_GET['Data'];
$date = $_GET['Date'];
//$date = new DateTime($_GET['Date']);
$n_value = explode(",",$value);
echo "<br />";
//echo $date->format('Y-m-d H:i:s');
//fdgdfgdf
 $Times = explode(",",$Time);
$select = explode(",",$SelectedSource);
$measure = explode(",",$SelectedMeasure);
echo "<br />";
$temp = "";
$insert_count = 0;
        


                                                $days = Date('Y-m-d',strtotime($date));

                        $fetch = mysql_query("SELECT * FROM schedule") or die(mysql_error());
                                        
                                        while($rows = mysql_fetch_array($fetch)){
                                        $timestamp=strtotime($rows['fLastUpdate']);
                                        $timestamp2 = date('Y-m-d',$timestamp);
                                        $date_time = date('H:i',$timestamp);
                                        //$time_new = $date_time->format('H:i:s')
                                        if($days == $timestamp2){

                                        $delete = mysql_query("DELETE FROM `schedule` WHERE `fLastUpdate`='{$rows['fLastUpdate']}'");
                        
                                        }
                                        }
                                        
                                        
                                        
                                        
                                        
                                        

for($i=0;$i<=$limtex-1;$i++){
$select = explode(",",$SelectedSource);
                                                $n1 = $n_value[$i];
                                                
                                         $selectf = $select[$i];
                                //////Time////
                                //$Timef = $Time[$i];
                                                
                                //////// for measurement /////////
                                                
                                                $measuref = $measure[$i];

                                //////// Date parsing into format////////
                                                $dateTime=new DateTime($date." ".$Times[$i]);
                                                 $parsed_date =  $dateTime->format('Y-m-d H:i:s');
                                                $new = 0;
                                        
                        $select = mysql_query("SELECT * FROM schedule WHERE fLastUpdate = '$parsed_date'");
                        if($select){
                        while($row = mysql_fetch_array($select)){
                
                                
                                $new =   $row['fMeasurementID'] + 1 ;
                                
                        
                        
                        }
                                }else{
                                
                                $new = 0;
                                
                                }       
                        
                $insert = mysql_query("INSERT IGNORE INTO schedule values('','$parsed_date','$parsed_date','$new','','$n1','$selectf','$measuref')") or die(mysql_error());
                                        
}
 if($insert){
        
                                ?>
                                <script type="text/javascript">
                                   
                                        alert("Sucessfully save");
                                        window.location = '../index.php?days=<?php echo $date; ?>';
                                </script>
                                <?php
        
        }
        
?>