// die("0:" . $queryCheckStartDate. "::" . $queryCheckEndDate ."::" . count($checkStartArray) .'::'. count($checkEndArray) ); die("0:Failure to save"); } $addAppt = new appointments(); // die($htmlID); $addAppt->username = $username; $addAppt->htmlid = $htmlID; $addAppt->appt_name = $name; $addAppt->appt_type = $inputType; $addAppt->appt_code = $inputCode; $addAppt->appt_details = $inputDetails; $addAppt->appt_start = $start; $addAppt->appt_end = $end; $ok = $addAppt->Save(); if (!$ok) { $err = $addAppt->ErrorMsg(); die($err); } die("1:SUCCESS: This was saved successfully."); break; case "retrieve": $mondayDate = $_POST['mondayDate']; $showNumDays = $_POST['showNumDays']; // eg 7 days in a week or 14 for a fortnight $changeDate = explode('-', $mondayDate); $mondayDate = $changeDate[2] . '-' . $changeDate[1] . '-' . $changeDate[0]; // want the format 2008-10-23 00:00:00 $start = $mondayDate . ' 00:00:00'; // end date is +7 days and - 1 second $sundayDate = new DateTime($mondayDate); $sundayDate->modify("+" . ($showNumDays - 1) . " day");