";
//echo $date->format('Y-m-d H:i:s');
//fdgdfgdf
$Times = explode(",",$Time);
$select = explode(",",$SelectedSource);
$measure = explode(",",$SelectedMeasure);
echo "
";
$temp = "";
$insert_count = 0;
$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['fLastUpdate']);
$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 `fLastUpdate`='{$rows['fLastUpdate']}'");
}
}
for($i=0;$i<=$limtex-1;$i++){
$select = explode(",",$SelectedSource);
$n1 = $n_value[$i];
$selectf = $select[$i];
//////Time////
//$Timef = $Time[$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 IGNORE INTO schedule values('','$parsed_date','$parsed_date','$new','','$n1','$selectf','$measuref')") or die(mysql_error());
}
if($insert){
?>