function find_default_page($subject_id) { $page_set = find_pages_for_subjects($subject_id); if ($first_page = mysqli_fetch_assoc($page_set)) { return $first_page; } else { return null; } }
<?php echo "<li"; if ($selected_subject_set == $subject['id']) { echo " class=\"selected\""; } echo ">"; ?> <a href="manage_content.php?subject=<?php echo $subject['id']; ?> "><?php echo $subject['menu_name']; ?> </a> <?php $page_set = find_pages_for_subjects($subject['id']); ?> <ul class="pages"> <?php while ($pages = mysqli_fetch_assoc($page_set)) { ?> <?php echo "<li"; if ($selected_page_set == $pages['id']) { echo " class=\"selected\""; } echo ">"; ?> <a href="manage_content.php?pages=<?php echo $pages['id']; ?>
?> </h2> <form action="edit_page.php?page=<?php echo urlencode($current_page["id"]); ?> " method="post"> <p> Menu Name:<input name="menu_name" type="text" value="<?php echo $current_page["menu_name"]; ?> "/> <br/> </p> <p> Position: <select name="position"> <?php $page_set = find_pages_for_subjects($current_page["subject_id"]); $page_count = mysqli_num_rows($page_set); for ($count = 1; $count <= $page_count; $count++) { echo "<option value=\"{$count}\""; if ($current_page["position"] == $count) { echo "class=\"selected\""; } echo ">{$count}</option>"; echo ">{$count} </option>"; } ?> </select> </p> <p>Visible: <input type="radio" name="visible" value="1" <?php
echo $current_subject["position"]; ?> <br/> Visible : <?php echo $current_subject["visible"] == 1 ? 'Yes' : 'No'; ?> <br/> <a href="edit_subject.php?subject=<?php echo urlencode($current_subject["id"]); ?> "> Edit Subject </a> <div style="margin-top: 2em; border-top:1px solid #000"> <h3>Pages in This Subject:</h3> <ul> <?php $subject_pages = find_pages_for_subjects($current_subject["id"]); while ($page = mysqli_fetch_assoc($subject_pages)) { echo "<li>"; $safe_page_id = urlencode($page["id"]); echo "<a href=\"manage_content.php?page={$safe_page_id}\">"; echo htmlentities($page["menu_name"]); echo "</a>"; echo "</li>"; } ?> </ul> <br/> <a href="new_page.php?subject=<?php echo urlencode($current_subject["id"]); ?> ">Add Page for This Subject>></a>
<?php echo "<li"; if ($subject["id"] == $current_subject) { echo " class=\"selected\""; } echo ">"; ?> <a href="manage_content.php?subject=<?php echo urlencode($subject["id"]); ?> "><?php echo $subject["menu_name"]; ?> </a> <?php $page_set = find_pages_for_subjects($subject["id"]); ?> <ul class="pages"> <?php while ($pages = mysqli_fetch_assoc($page_set)) { ?> <?php echo "<li"; if ($pages["id"] == $current_page) { echo " class=\"selected\""; } echo ">"; ?> <a href="manage_content.php?page=<?php echo urlencode($pages["id"]); ?>
require_once "../includes/db-connection.php"; require_once "../includes/functions.php"; ?> <?php $layout_context = "admin"; ?> <?php $current_subject = find_subject_by_id($_GET["subject"]); if (!$current_subject) { //subject id was missing or invalid or coudn'nt find on db redirect_to("manage_content.php"); } // finding if any pages left in subject $pages_set = find_pages_for_subjects($current_subject["id"]); if (mysqli_num_rows($pages_set) > 0) { $_SESSION["message"] = "Can't Do because pages left in subject"; redirect_to("manage_content.php?subject={$current_subject["id"]}"); } $id = $current_subject["id"]; $query = "DELETE FROM subjects WHERE id = {$id} LIMIT 1"; $result = mysqli_query($connection, $query); if ($result && mysqli_affected_rows($connection) == 1) { //sucess $_SESSION["message"] = "Subject DELETED!"; redirect_to("manage_content.php"); } else { //failure $_SESSION["message"] = "Subject DELETION Failed"; redirect_to("manage_content.php?subject={$id}");
function public_navigation($subject_array, $page_array) { $output = "<ul class=\"subjects\">"; $subject_set = find_all_subjects(); while ($subject = mysqli_fetch_assoc($subject_set)) { $output .= "<li"; if ($subject_array && $subject["id"] == $subject_array["id"]) { $output .= " class=\"selected\""; } $output .= ">"; $output .= "<a href=\"index.php?subject="; $output .= urlencode($subject["id"]); $output .= "\">"; $output .= htmlentities($subject["menu_name"]); $output .= "</a>"; if ($subject_array["id"] == $subject["id"] || $page_array["subject_id"] == $subject["id"]) { $page_set = find_pages_for_subjects($subject["id"]); $output .= "<ul class=\"pages\">"; while ($page = mysqli_fetch_assoc($page_set)) { $output .= "<li"; if ($page_array && $page["id"] == $page_array["id"]) { $output .= " class=\"selected\""; } $output .= ">"; $output .= "<a href=\"index.php?page="; $output .= urlencode($page["id"]); $output .= "\">"; $output .= htmlentities($page["menu_name"]); $output .= "</a></li>"; } $output .= "</ul>"; mysqli_free_result($page_set); } $output .= "</li>"; // end of the subject li } mysqli_free_result($subject_set); $output .= "</ul>"; return $output; }
function page_default($subject_id) { $page = find_pages_for_subjects($subject_id["id"]); $result = mysqli_fetch_assoc($page); return $result; }