$region = isset( $_REQUEST['region'] ) ? $_REQUEST['region'] : 0; $yearsel = isset( $_REQUEST['yearsel'] ) ? $_REQUEST['yearsel'] : date("Y"); if( $region ) { $sql = "SELECT * FROM event WHERE approved = '1' AND region_id = '".$region."' ORDER BY date ASC"; } else { $sql = "SELECT * FROM event WHERE approved = '1' ORDER BY date ASC"; } $events = $result = $db->exec_query($sql); if($yearsel) { $events = array(); foreach( $result as $key => $value ) { if( date("Y",$value['date']) == $yearsel ) $events[$key] = $value; } } $sql = "SELECT id, label FROM regions ORDER BY label ASC"; $res = $db->exec_query($sql); $regions = array(); foreach( $res as $key => $value ) { $regions[$value['id']] = $value['label']; } if( $region ) { $sql = "SELECT date FROM event WHERE region_id = '".$region."' ORDER BY date ASC"; } else { $sql = "SELECT date FROM event ORDER BY date ASC"; } $dates = $db->exec_query($sql); $years = array(); foreach( $dates as $value ) { $year = date("Y",$value['date']); if( !in_array( $year, $years )) { $years[$year] = $year; } } if( empty( $years )) $years[date('Y')] = date('Y'); ?> if( $_l == 'en' ) { ?>
The Calendar of Events lists CGS and related industry events that may be of interest to geotechnical professionals. Please use the web links provided to search for events by date and/or by region.
To have your event considered for posting on our Calendar of Events, please click here to complete our online event listing form.
While we make every effort to provide timely and factually correct information, please excuse us if the details are out of date.
Le Calendrier des événements présente les événements organisés par la SCG et d’autres événements de l’industrie qui pourraient présenter de l'intérêt pour les professionnels en géotechnique. Pour trouver des événements selon la date et la région ou la section, utilisez les hyperliens ci-dessous.
} ?>Geographic Region: foreach ($regions as $key => $value) { if ($key == $region) { echo $value; } } ?> Year: foreach ($years as $key => $value) { if ($key == $yearsel) { echo $value; } } ?>
| Date | Geographic Region | Location | Event | Contact |
| '; // start day month year $sd = date("d",$value['date']); $sm = date("F",$value['date']); $sy = date("Y",$value['date']); // end day month year $ed = date("d",$value['date_end']); $em = date("F",$value['date_end']); $ey = date("Y",$value['date_end']); $display = ''; // compare the start and end date values to figure out a good way of displaying the date // is the day the same? if( $sd == $ed ) { // is the month the same? if( $sm == $em ) { // is the year the same? if( $sy == $ey ) { // starts and ends on same day, display "Month Day, Year" $display = date("M d, Y",$value['date']); } else { // Different years, display "Month Day, Year - Month Day, Year" $display = date("M d, Y",$value['date']).' - '.$display = date("M d, Y",$value['date_end']); } } else { // is the year the same? if( $sy == $ey ) { // starts and ends in same year, display "Month Day - Month Day, Year" $display = date("M d",$value['date']).' - '.date("M d",$value['date_end']).', '.date("Y",$value['date']); } else { // Different years, display "Month Day, Year - Month Day, Year" $display = date("M d, Y",$value['date']).' - '.$display = date("M d, Y",$value['date_end']); } } } else { // is month the same? if( $sm == $em ) { // is year the same? if( $sy == $ey ) { // Different days, same month and year, display "Month Day - Day, Year" $display = date("M d",$value['date']).'-'.date("d",$value['date_end']).', '.date("Y",$value['date']); } else { // Different years, display "Month Day, Year - Month Day, Year" $display = date("M d, Y",$value['date']).' - '.$display = date("M d, Y",$value['date_end']); } } else { // different months $display = date("M d",$value['date']).' - '.$display = date("M d",$value['date_end']).', '.date("Y",$value['date']); } } echo $display; echo ' | '; echo ''; $sql = "SELECT label FROM regions WHERE id = '".$value['region_id']."'"; $region = $db->exec_query($sql); $region = array_shift($region); echo $region['label']; echo ' | '; echo ''; echo $value['location']; echo ' | '; echo '';
echo ''.$value['title'].' '; echo $value['description']; echo ' | ';
echo ''; $url = ''; if($value['url'] != '' && $value['url'] != 'http://') { $url = $value['url']; } if( $url ) { echo 'See Website'; } if( $url && $value['email'] ) { echo ' or '; } if( $value['email'] ) { echo 'Contact '.$value['email'].''; } echo ' | '; echo ''.$no_events.' | '; } ?>