source: schedule/Transaction/update.php@ 17218

<?php
//Build by: khristofer Usman
//Modified by: Jaypee Tanio
// June 22,2013
include '../include/factdb.php';
$Time =$_POST['Time'];
$SelectedSource = $_POST['Source'];
$SelectedMeasure = $_POST['measure'];
$limtex = count(explode(",",$SelectedSource));
$Upd=$_POST['upd'];
$Upt=$_POST['upt'];
$value = $_POST['Data'];
$date = $_POST['Date'];
$n_value = explode(",",$value);
$Times = explode(",",$Time);
$select = explode(",",$SelectedSource);
$measure = explode(",",$SelectedMeasure);
//date_default_timezone_set('Asia/Manila'); // Setting up the localTimeZone in asia
$UpdateDate=(date('Y-m-d H:i:s'));


                                                $days = Date('Y-m-d',strtotime($date));

                        $fetch = mysql_query("SELECT * FROM schedule") or die(mysql_error());
                                        
                                        while($rows = mysql_fetch_array($fetch))
                                        {
                                        $timestamp=strtotime($rows['fStart']);
                                        $timestamp2 = date('Y-m-d',$timestamp);
                                        $date_time = date('H:i',$timestamp);
                                        //$time_new = $date_time->format('H:i:s')
                                                if($days == $timestamp2)
                                                {

                                                $delete = mysql_query("DELETE FROM `schedule` WHERE `fStart`='{$rows['fStart']}'");
                        
                                                }
                                        }
                                        

for($i=0;$i<=$limtex-1;$i++)
{
$select = explode(",",$SelectedSource);
        $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');
        
                mysql_query("INSERT INTO schedule VALUES('null','".$parsed_date."','".$UpdateDate."','".$measuref."','','".$n1."','".$selectf."','".$measuref."')");    
                        
}       
?>