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;
}
