Index: schedule/Transaction/insert.php
===================================================================
--- schedule/Transaction/insert.php	(revision 16926)
+++ schedule/Transaction/insert.php	(revision 17422)
@@ -1,33 +1,22 @@
-<?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."')");
+	
 	
 ?>