source: schedule/Transaction/insert.php@ 15906

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

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

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

$Time = explode(",",$Time);
$select = explode(",",$SelectedSource);
$measure = explode(",",$SelectedMeasure);
echo "<br />";
for($i=0;$i<=$limtex-1;$i++){

        
                                                $n1 = $n_value[$i];
                        
                                                $select[$i];
        
        
                                                $selectf = $select[$i];
                                                $Timef = $Time[$i];
                                                $dateTime=new DateTime($date." ".$Time[$i]);
                                                
                                                echo $parsed_date =  $dateTime->format('Y-m-d H:i:s');
                                                $measuref = $measure[$i];
                
                        
                $insert = mysql_query("INSERT INTO schedule values('','$parsed_date','','','','$n1','$selectf','$measuref')") or die(mysql_error());
                                
}
 if($insert){
        
                                ?>
                                <script type="text/javascript">
                                        alert("Sucessfully save");
                                </script>
                                <?php
        
        }
        
?>