\n

Logged in: $logged_in_user

\n

Back to list

\n

Admin Menu

\n

Log Out

\n"; } $presentation_id = $_GET['event']; $sql_categories = "SELECT category.category_name, category.category_abbrev, presentation_category.note FROM presentation_category, category WHERE presentation_category.category_id = category.category_id AND presentation_category.presentation_id=$presentation_id;"; $result_categories = @mysqli_query($connection, $sql_categories) or die(mysqli_error()); $display_block_cat = ""; $counter = 1; while ($row = mysqli_fetch_array($result_categories)) { $category_name = strtolower($row['category_name']); $category_abbrev = strtoupper($row['category_abbrev']); $note = strtolower($row['note']); if ($counter > 1) $display_block_cat .= "  "; $display_block_cat .= "\n$category_abbrev $category_name"; if (!empty($note)) $display_block_cat .= " ($note)"; $counter++; } // Free memory associated with the result of the previous query mysqli_free_result($result_categories); // Main query $sql = "SELECT DATE_FORMAT(presentation.presentation_date, '%W %b %e') as presentation_date, TIME_FORMAT(presentation.presentation_start_time, '%k%:%i') as presentation_start_time, presentation.title, presentation.description, presentation.course_code, presentation_presenter.presenter_id, presenter.surname, presenter.firstname, presenter.photo, presentation.venue_room, presentation.venue_building, presentation.duration FROM `presenter`, presentation, presentation_presenter WHERE presenter.presenter_id = presentation_presenter.presenter_id AND presentation.presentation_id = presentation_presenter.presentation_id AND presentation.presentation_id = $presentation_id;"; $result = @mysqli_query($connection, $sql) or die(mysqli_error()); $display_block = ""; $display_presenter1photo = ""; $display_presenter2photo = ""; $display_presenternames = ""; $display_course_code = ""; // For HTML title and SEO tags: $presenter_name1 = ""; $presenter_name2 = ""; $counter = 0; while ($row = mysqli_fetch_array($result)) { $counter++; // Most workshops have one presenter, a few have two // First time around - pick up all details - including first presenter if ($counter == 1) { $presentation_date = strtolower($row['presentation_date']); $presentation_start_time = $row['presentation_start_time']; $duration = $row['duration']; $title = htmlspecialchars($row['title']); $description = $row['description']; $course_code = $row['course_code']; $presenter_id = $row['presenter_id']; $firstname = $row['firstname']; $surname = $row['surname']; $photo = $row['photo']; $venue_room = $row['venue_room']; $venue_building = $row['venue_building']; // Work out end time $endtime = date('G:i', strtotime("+$duration minutes", strtotime($presentation_start_time))); $title = strtolower($title); $duration = $duration / 60; if ($duration > 60) $duration = "$duration hours"; else $duration = "$duration hour"; $presenter_name_initcaps = $firstname . " " . $surname; $presenter_name1 = $presenter_name_initcaps; $presenter_name = strtolower($presenter_name_initcaps); $venue = $venue_room . ", " . $venue_building; if ($venue === "unknown, unknown") $venue = "tba"; if ($title === "unknown title") $title = "title tba"; if ($presenter_name === "unknown presenter") $presenter_name = "tba"; if ($course_code === "???") $course_code = "tba"; if ($presentation_date === "saturday aug 1") $presentation_date = "date tba"; $display_presenternames = "$presenter_name"; // Convert any spaces in file name to %20 (to pass W3C validation) $photo = str_replace(" ", "%20", $photo); // Check whether an image file name has been entered in the database, then check whether that file exists if (!empty($photo)) { $photo_file = "pictures/presenters/$photo"; if (file_exists($photo_file)) { $display_presenter1photo = "\n\"$presenter_name,"; } else { $display_presenter1photo = "\n\"No"; } } else { $display_presenter1photo = "\n\"No"; } } else { // Second time around - second presenter - all other data is the same, just collect second presenter details and add to display string $presenter_id = $row['presenter_id']; $firstname = $row['firstname']; $surname = $row['surname']; $photo = $row['photo']; $presenter_name_initcaps = $firstname . " " . $surname; $presenter_name2 = $presenter_name_initcaps; $presenter_name = strtolower($presenter_name_initcaps); if ($presenter_name === "unknown presenter") $presenter_name = "tba"; $display_presenternames .= " and $presenter_name"; // Convert any spaces in file name to %20 (to pass W3C validation) $photo = str_replace(" ", "%20", $photo); // Check whether an image file name has been entered in the database, then check whether that file exists if (!empty($photo)) { $photo_file = "pictures/presenters/$photo"; if (file_exists($photo_file)) { $display_presenter2photo = "\n\"$presenter_name,"; } else { $display_presenter2photo = "\n\"No"; } } else { $display_presenter2photo = "\n\"No"; } } } $display_block .= "\n

$title

"; $display_block .= $display_presenter1photo; if ($display_presenter2photo != "") $display_block .= $display_presenter2photo; $venue_room = $venue_room; $venue_building = $venue_building; $display_course_code = "

course code: $course_code

"; $display_block .= "\n

with $display_presenternames
"; $display_block .= "\n$presentation_date, $presentation_start_time - $endtime
"; $display_block .= "\nvenue: $venue

"; if (!empty($display_block_cat)) $display_block .= "\n

category:
$display_block_cat

"; $display_block .= "\n
"; // HTML title and SEO tags if ($presenter_name2 == "") { $title_tag = "$presenter_name1"; $seo_text = "$presenter_name1"; } else { $title_tag = "$presenter_name1 and $presenter_name2"; $seo_text = "$presenter_name1, $presenter_name2"; } // The connection will be closed automatically when the script ends, but to make it explicit: mysqli_close($connection); ?> AT Congress 2015 | <? echo $title_tag; ?> | Workshop
Actively engaged in a continuous learning session at Alexander Technique Congress

workshop

Facebook icon Twitter icon Youtube icon Email icon

all workshops daily schedule weekly schedule