rendered paste body<?$months = array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");$data = $db->getData("programs", "*", "1", 1);foreach($data as $key=>$val) { foreach($val as $k=>$v) { if($k=="Dates") { $new_date = explode(" ", $val['Dates']); $month = $new_date[0]; foreach($months as $k=>$v) { if(preg_match("/" . $v . "/", $new_date[1])) { /* we have start and end month that differ */ $date_string = explode("-", $new_date[1]); $start_date[$val['id']] = $month . " " . $date_string[0] . " " . date("Y"); $end_date[$val['id']] = $date_string[1] . " " . $new_date[2] . " " . date("Y"); } } if(preg_match("/-/", $new_date[1])) { $date_string = explode("-", $new_date[1]); $begin_date = $date_string[0]; $date_end = $date_string[1]; $start_date[$val['id']] = $month . " " . $begin_date . " " . date("Y") . "\n"; $end_date[$val['id']] = $month . " " . $date_end . " " . date("Y") . "\n"; } else { $start_date[$val['id']] = $new_date[0] . " ". $new_date[1] . date("Y"); $end_date[$val['id']] = $new_date[0] . " ". $new_date[1] . date("Y"); } } if($k == "Time") { if($val['Time'] != "") { $new_time = str_replace(" ", "", $val['Time']); $new_time = explode("-", $new_time); if(preg_match("/[noon]/i", strtolower($new_time[0]))) { $new_time[0] = "12:00p.m."; } if(preg_match("/noon/i", strtolower($new_time[1]))) { $new_time[1] = "12:00p.m."; } $new_time[0] = str_replace("noon", " p.m.", $new_time[0]); if(!preg_match("/:/", $new_time[0])) { if(!preg_match("/(a.m.)|(p.m.)|(am)|(pm)/", $new_time[0])) { if(preg_match("/(a.m.)|(p.m.)|(am)|(pm)/", $new_time[1])) { if(preg_match("/(a.m.)|(am)/", $new_time[1])) { $start_time[$val['id']] = $new_time[0] . ":00" . "a.m."; } else { $start_time[$val['id']] = $new_time[0] . ":00" . "p.m."; } } } else { if(preg_match("/(a.m.)|(am)/", $new_time[0])) { $new_time[0] = str_replace("a.m.", "", $new_time[0]); $start_time[$val['id']] = $new_time[0] . ":00" . "a.m."; } else if(preg_match("/(p.m.)|(pm)/", $new_time[0])) { $new_time[0] = str_replace("p.m.", "", $new_time[0]); $start_time[$val['id']] = $new_time[0] . ":00" . "p.m."; } else if(preg_match("/(a.m.)|(am)/", $new_time[1])) { $start_time[$val['id']] = $new_time[0] . ":00" . "a.m."; } else { $start_time[$val['id']] = $new_time[0] . ":00" . "p.m."; } } } else { if(!preg_match("/(a.m.)|(p.m.)|(am)|(pm)/", $new_time[0])) { if(preg_match("/(a.m.)|(p.m.)|(am)|(pm)/", $new_time[1])) { if(preg_match("/(a.m.)|(am)/", $new_time[1])) { $start_time[$val['id']] = $new_time[0] . "a.m."; } else { $start_time[$val['id']] = $new_time[0] . "p.m."; } } } else { $start_time[$val['id']] = $new_time[0]; } } if(!preg_match("/:/", $new_time[1])) { $new_time[1] = str_replace("noon", "p.m.", $new_time[1]); if(preg_match("/(a.m.)|(p.m.)|(am)|(pm)/", $new_time[1])) { if(preg_match("/(a.m.)|(am)/", $new_time[1])) { $new_time[1]= str_replace("a.m.", "", $new_time[1]); $end_time[$val['id']] = $new_time[1] . ":00" . " a.m."; } else { $new_time[1]= str_replace("p.m.", "", $new_time[1]); $end_time[$val['id']] = $new_time[1] . ":00" . " p.m."; } } } else { $end_time[$val['id']] = $new_time[1]; } } else { $start_time[$val['id']] = "12:00a.m."; $end_time[$val['id']] = "11:59p.m."; } } } $park = new parks($val['Location']); $category = new parkscategory($val['Cat']); $program = new parksprogram(); $new_data['category_id'] = $category->categorydata[0]['category_id']; $new_data['park_id'] = $park->parksdata[0]['park_id']; $new_data['fee'] = $val['Fee']; $new_data['title'] = $val['Title']; $new_data['program_number'] = $val['Prog']; $new_data['instructor'] = $val['Instructor']; $new_data['age_group'] = $val['URL']; $new_data['capacity'] = $val['Limits']; $new_data['short_description'] = $val['Short']; $new_data['description'] = $val['Description']; $new_data['start_date'] = date("Y-m-d H:i:s", strtotime($start_date[$val['id']] . " " . $start_time[$val['id']])); $new_data['end_date'] = date("Y-m-d H:i:s", strtotime($end_date[$val['id']] . " " . $end_time[$val['id']])); $new_data['registration_end_date'] = $val['Reg']; $program->addProgram($new_data);}?>