source: schedule/Transaction/SaveSchedule.php@ 19058

 <?php
//connect to the mysql
$db = mysql_connect("localhost","scheduletest","t3stsched");
mysql_select_db('sandboxschedule', $db) or die("Could not select database");

        $dataArray = json_decode($_POST['Data']);
        $day = date('Y-m-d', $_POST['Date']);
        $numObservations = count($dataArray);
        $count = 0;
        mysql_query("DELETE FROM schedule WHERE DATE(fStart) = '$day'");
        foreach($obsArr in $dataArray) {
                foreach($schedArr in $obsArr) {
                        $datetime = new DateTime($day.$schedArray[0]);
                        $schedDate = date('Y-m-d H:i:s', $datetime);
                        $updateDate = date('Y-m-d H:i:s');
                        $seq = $schedArray[1];
                        $dataValue = $schedArray[2];
                        $source = $schedArray[3];
                        $measure = $schedArray[4];
                        mysql_query("INSERT INTO schedule VALUES('null','".$dateformat."','".$updateDate."','".$seq."','','".$dataValue."','".$source."','".$measure."')");                     
                }
        }
        //database query
        //              mysql_query("INSERT INTO schedule VALUES('null','".$par."','".$part."','".$seq."','','".$data."','".$Source."','".$measure."')");
        echo 'done';
?>