";
$output .= "Please fix the following errors:";
$output .= "";
foreach ($errors as $key => $error) {
$output .= "- ";
$output .= htmlentities($error);
$output .= "
";
}
$output .= "
";
$output .= "";
}
return $output;
}
function find_all_subjects($public=true) {
global $connection;
$query = "SELECT * ";
$query .= "FROM subjects ";
if ($public) {
$query .= "WHERE visible = 1 ";
}
$query .= "ORDER BY position ASC";
$subject_set = mysqli_query($connection, $query);
confirm_query($subject_set);
return $subject_set;
}
function find_pages_for_subject($subject_id, $public=true) {
global $connection;
$safe_subject_id = mysqli_real_escape_string($connection, $subject_id);
$query = "SELECT * ";
$query .= "FROM pages ";
$query .= "WHERE subject_id = {$safe_subject_id} ";
if ($public) {
$query .= "AND visible = 1 ";
}
$query .= "ORDER BY position ASC";
$page_set = mysqli_query($connection, $query);
confirm_query($page_set);
return $page_set;
}
function find_subject_by_id($subject_id, $public=true) {
global $connection;
$safe_subject_id = mysqli_real_escape_string($connection, $subject_id);
$query = "SELECT * ";
$query .= "FROM subjects ";
$query .= "WHERE id = {$safe_subject_id} ";
if ($public) {
$query .= "AND visible = 1 ";
}
$query .= "LIMIT 1";
$subject_set = mysqli_query($connection, $query);
confirm_query($subject_set);
if($subject = mysqli_fetch_assoc($subject_set)) {
return $subject;
} else {
return null;
}
}
function find_page_by_id($page_id, $public=true) {
global $connection;
$safe_page_id = mysqli_real_escape_string($connection, $page_id);
$query = "SELECT * ";
$query .= "FROM pages ";
$query .= "WHERE id = {$safe_page_id} ";
if ($public) {
$query .= "AND visible = 1 ";
}
$query .= "LIMIT 1";
$page_set = mysqli_query($connection, $query);
confirm_query($page_set);
if($page = mysqli_fetch_assoc($page_set)) {
return $page;
} else {
return null;
}
}
function find_default_page_for_subject($subject_id) {
$page_set = find_pages_for_subject($subject_id);
if($first_page = mysqli_fetch_assoc($page_set)) {
return $first_page;
} else {
return null;
}
}
function find_selected_page($public=false) {
global $current_subject;
global $current_page;
if (isset($_GET["subject"])) {
$current_subject = find_subject_by_id($_GET["subject"], $public);
if ($current_subject && $public) {
$current_page = find_default_page_for_subject($current_subject["id"]);
} else {
$current_page = null;
}
} elseif (isset($_GET["page"])) {
$current_subject = null;
$current_page = find_page_by_id($_GET["page"], $public);
} else {
$current_subject = null;
$current_page = null;
}
}
// navigation takes 2 arguments
// - the current subject array or null
// - the current page array or null
function navigation($subject_array, $page_array) {
$output = "";
$subject_set = find_all_subjects(false);
while($subject = mysqli_fetch_assoc($subject_set)) {
$output .= "";
$output .= htmlentities($subject["menu_name"]);
$output .= "";
$page_set = find_pages_for_subject($subject["id"], false);
$output .= "";
while($page = mysqli_fetch_assoc($page_set)) {
$output .= "";
$output .= htmlentities($page["menu_name"]);
$output .= "";
}
mysqli_free_result($page_set);
$output .= "
";
}
mysqli_free_result($subject_set);
$output .= "
";
return $output;
}
function public_navigation($subject_array, $page_array) {
$output = "";
$subject_set = find_all_subjects();
while($subject = mysqli_fetch_assoc($subject_set)) {
$output .= "";
$output .= htmlentities($subject["menu_name"]);
$output .= "";
if ($subject_array["id"] == $subject["id"] ||
$page_array["subject_id"] == $subject["id"]) {
$page_set = find_pages_for_subject($subject["id"]);
$output .= "";
while($page = mysqli_fetch_assoc($page_set)) {
$output .= "";
$output .= htmlentities($page["menu_name"]);
$output .= "";
}
$output .= "
";
mysqli_free_result($page_set);
}
$output .= ""; // end of the subject li
}
mysqli_free_result($subject_set);
$output .= "
";
return $output;
}
?>