PHP Week::getLastId Examples

Example #1

File: week.php Project: mhender24/WebScheduler

 public static function createDays($schId)
 {
     $db = Database::getInstance();
     $weekId = Week::getLastId();
     $schedule = Schedule::getSchedule($schId);
     $sql = "INSERT INTO day (weekId, startTime, shiftDate) VALUES (:weekId, :startTime, :shiftDate)";
     for ($i = 0; $i < 7; $i++) {
         $shift = date('Y-m-d', strToTime("+" . $i . " days", strToTime($schedule['startDate'])));
         $result = $db->prepare($sql);
         $result->execute(array(":weekId" => $weekId, ":startTime" => null, ":shiftDate" => $shift));
     }
 }