source: schedule/Transaction/insert.php@ 16000

Last change on this file since 16000 was 16000, checked in by tanio, 11 years ago
File size: 1.4 KB
Line 
1<?php
2include '../include/factdb.php';
3
4 $Time =$_GET['Time'];
5 $SelectedSource = $_GET['Source'];
6 $Date = $_GET['Date'];
7
8 $SelectedMeasure = $_GET['measure'];
9$TimeEX = explode("-",$Date);
10
11echo $TimeEX2 = "day=".$TimeEX[0]."&month=".$TimeEX[1]."&year=".$TimeEX[2];
12echo $limtex = count(explode(",",$SelectedSource));
13$insertdate = $TimeEX[2]."-".$TimeEX[1]."-".$TimeEx[0];
14$value = $_GET['Data'];
15$Date = $_GET['Date2'];
16//$date = new DateTime($_GET['Date']);
17$n_value = explode(",",$value);
18echo "<br />";
19//echo $date->format('Y-m-d H:i:s');
20//fdgdfgdf
21$Time = explode(",",$Time);
22$select = explode(",",$SelectedSource);
23$measure = explode(",",$SelectedMeasure);
24echo "<br />";
25for($i=0;$i<=$limtex-1;$i++){
26
27
28 $n1 = $n_value[$i];
29
30 $select[$i];
31
32
33 $selectf = $select[$i];
34 $Timef = $Time[$i];
35 $dateTime=new DateTime($date." ".$Time[$i]);
36
37 echo $parsed_date = $dateTime->format('Y-m-d H:i:s');
38 $measuref = $measure[$i];
39
40
41 $insert = mysql_query("INSERT INTO schedule values('','$parsed_date','$parsed_date','','','$n1','$selectf','$measuref')") or die(mysql_error());
42
43}
44 if($insert){
45
46 ?>
47 <script type="text/javascript">
48 var data_to = <?php echo $TimeEX2; ?>
49 alert("Sucessfully save");
50 window.location.href = 'index.php?'+data_to;
51 </script>
52 <?php
53
54 }
55
56?>
Note: See TracBrowser for help on using the repository browser.