All pastes #483719 Raw Edit

Stuff

public php v1 · immutable
·published 2007-05-11 21:14 UTC
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);}?>