Changeset 17422 for schedule/Transaction/insert.php

Timestamp:

01/03/14 09:23:03 (11 years ago)

Author:

tanio

Message:

 

File:

• schedule/Transaction/insert.php (modified) (1 diff)

schedule/Transaction/insert.php

@@ -1 @@
-<?php
-//Build by: khristofer Usman
-//Modified by: Jaypee Tanio
-// June 14,2013
+ <?php
+//connect to the mysql
+$db = mysql_connect('localhost', 'root', '') or die("Could not connect database");
+mysql_select_db('sandboxschedule', $db) or die("Could not select database");
 
-include '../include/factdb.php';
- $Time =$_POST['Time'];
- $SelectedSource = $_POST['Source'];
- $Date = $_POST['Date'];
- echo $Date;
- $SelectedMeasure = $_POST['measure'];
-$value = $_POST['Data'];
-$date = $_POST['Date'];
-echo "<br />";
-$n_value = explode(",",$value);
-$Times = explode(",",$Time);
-$select = explode(",",$SelectedSource);
-$measure = explode(",",$SelectedMeasure);
-$limtex = count(explode(",",$SelectedMeasure));
-echo "<br />";
-for($i=0;$i<=$limtex-1;$i++)
-{
-        $n1 = $n_value[$i];             
-        $selectf = $select[$i]; 
-        $measuref = $measure[$i];
-        $dateTime=new DateTime($date." ".$Times[$i]);
-        $parsed_date =  $dateTime->format('Y-m-d H:i:s');
+
+        $GTimes=$_POST['GTime'];
+        $Source=$_POST['Source'];
+        $measure=$_POST['measure'];
+        $data=$_POST['Data'];
+        $Gdates = $_POST['GDate'];
+        $seq = $_POST['seq'];
         
-                mysql_query("INSERT INTO schedule VALUES('null','".$parsed_date."','".$UpdateDate."','".$measuref."','','".$n1."','".$selectf."','".$measuref."')");    
-                        
-}
+        $date = new DateTime($Gdates.$GTimes);
+        $par=$date->format('Y-m-d H:i:s');
+        $Timez = new DateTime($GTimes);
+        $part = $Timez->format('H:i:s');        
+                        //database query
+                        mysql_query("INSERT INTO schedule VALUES('null','".$par."','".$part."','".$seq."','','".$data."','".$Source."','".$measure."')");
+        
         
 ?>