"; //echo $date->format('Y-m-d H:i:s'); //fdgdfgdf $Times = explode(",",$Time); $select = explode(",",$SelectedSource); $measure = explode(",",$SelectedMeasure); echo "
"; $temp = ""; $insert_count = 0; $new_limit = $limtex; for($j=0;$j <= $new_limit;$j++){ //echo $Times[$j]; $ex_counter = explode(":",$Times[$j]); $counter[$j] = $ex_counter[0]; } for($i=0;$i<=$limtex-1;$i++){ $n1 = $n_value[$i]; $select[$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'); // $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; // } //echo $new."
"; $insert = mysql_query("INSERT INTO schedule values('','$parsed_date','$parsed_date','','','$n1','$selectf','$measuref')ON DUPLICATE KEY UPDATE fMeasurementID=fMeasurementID + 1") or die(mysql_error()); } if($insert){ ?>