\n

Logged in: $logged_in_user

\n

Back to list

\n

Admin Menu

\n

Log Out

\n"; } $presenter_id = $_GET['presenter_id']; $sql = "SELECT * FROM presenter WHERE presenter_id=$presenter_id;"; $result = @mysqli_query($connection, $sql) or die(mysqli_error()); $display_block = ""; $name_with_qualifications = ""; while ($row = mysqli_fetch_array($result)) { $surname = $row['surname']; $firstname = $row['firstname']; $country = strtolower($row['country']); $qualifications = $row['qualifications']; $biography = stripslashes($row['biography']); $photo = $row['photo']; $email = $row['email']; $tel = $row['tel']; $website = $row['website']; $website2 = $row['website2']; $name_initcaps = $firstname . " " . $surname; $name = strtolower($name_initcaps); //$name_with_qualifications = $name . " $qualifications"; $name_with_country = $name . " $country"; // Convert any spaces in file name to %20 (to pass W3C validation) $photo = str_replace(" ", "%20", $photo); if (!empty($qualifications)) { $display_block = "

$qualifications

"; } // 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_block .= "\n\"Photo"; } else { $display_block .= "\n\"No"; } } else { $display_block = "\n\"No"; } $display_block .= "\n
\n

"; if (!empty($website)) { $display_block .="\nweb: $website
"; } if (!empty($website2)) { $display_block .="\nalso: $website2
"; } if (!empty($email)) { $display_block .="\nemail: $email"; } $display_block .= "

\n
"; } mysqli_free_result ($result); $sql2 = "SELECT presentation.presentation_id, presentation.type, DATE_FORMAT(presentation.presentation_date, '%a %e %b') as presentation_date FROM presentation, presentation_presenter WHERE presentation.presentation_id = presentation_presenter.presentation_id AND presentation_presenter.presenter_id = $presenter_id ORDER BY presentation.type, presentation.presentation_date;"; $result2 = @mysqli_query($connection, $sql2) or die(mysqli_error()); $display_block2= ""; $type_style = ""; $type_heading = ""; $event_page = ""; $display_block3= ""; while ($row = mysqli_fetch_array($result2)) { $presentation_id = $row['presentation_id']; $type = strtolower($row['type']); $presentation_date = strtolower($row['presentation_date']); if ($presentation_date === "sat 1 aug") $presentation_date = "date tba"; switch ($type) { case "plenary": $type_style = "plenary"; $type_heading = "plenary session"; $event_page = "pl_session.php"; break; // case "special": // $type_style = "special"; // $type_heading = "special presentation"; // $event_page = "special.php"; // break; case "panel": $type_style = "panel_discussion"; $type_heading = "panel discussion"; $event_page = "panel.php"; break; case "continuous learning": $type_style = "continuous"; $type_heading = "continuous learning session"; $event_page = "cl_session.php"; break; case "workshop": $type_style = "workshops"; $type_heading = "workshop"; $event_page = "workshop.php"; break; } if ($type != "other") { $display_block2 .= "

"; $display_block2 .= "$type_heading: "; if ($type == "continuous learning") $display_block2 .= "all week"; else $display_block2 .= "$presentation_date"; $display_block2 .= " | details"; $display_block2 .= "

\n"; } else { $display_block2 = ""; $display_block3 = "

← go back

"; } } // The connection will be closed automatically when the script ends, but to make it explicit: mysqli_close($connection); ?> AT Congress 2015 | <? echo $name_initcaps ?> | Profile
Participants at a workshop at the Alexander Technique 9th International Congress 2011

Facebook icon Twitter icon Youtube icon Email icon

back to top