source: schedule/Transaction/insert.php@ 16914

<?php
//Build by: khristofer Usman
//Modified by: Jaypee Tanio
// June 14,2013

include '../include/factdb.php';
 $Time =$_POST['Time'];
 $SelectedSource = $_POST['Source'];
 $Date = $_POST['Date'];
 echo $Date;
 $SelectedMeasure = $_POST['measure'];
$value = $_POST['Data'];
$date = $_POST['Date'];
$n_value = explode(",",$value);
echo "<br />";
$Times = explode(",",$Time);
$select = explode(",",$SelectedSource);
$measure = explode(",",$SelectedMeasure);
$limtex = count(explode(",",$SelectedMeasure));
echo "<br />";
for($i=0;$i<=$limtex;$i++)
{
$select = explode(",",$SelectedSource);
                                        $n1 = $n_value[$i];
                                        $selectf = $select[$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 INTO schedule values('','$parsed_date','$parsed_date','$measuref','','$n1','$selectf','$measuref')") or die(mysql_error());                               

                
                
}
        
?>