function 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_array['id'] == $subject['id']) {
$output .= "class='selected' ";
}
$output .= "> ";
$output .= "<a href='manage_content.php?subject=" . urlencode($subject['id']) . "'> " . htmlentities($subject['menu_name']) . "</a>";
$pages_set = find_pages_for_subject($subject['id']);
$output .= "<ul class='pages'>";
while ($page = mysqli_fetch_assoc($pages_set)) {
$output .= "<li ";
if ($page_array && $page_array['id'] == $page['id']) {
$output .= "class='selected'";
}
$output .= "> ";
$output .= "<a href='manage_content.php?page=" . urlencode($page['id']) . "'> " . htmlentities($page['menu_name']) . " </a></li> ";
}
$output .= "</ul>\n </li>";
}
mysqli_free_result($subject_set);
mysqli_free_result($pages_set);
$output .= '</ul>';
return $output;
}
function navigation($subject_id, $page_id)
{
$output = "<ul class = \"subjects\">";
$subject_set = find_all_subjects();
while ($subjects = mysqli_fetch_assoc($subject_set)) {
$output .= "<li";
if ($subjects["id"] == $subject_id) {
$output .= " class=\"selected\"";
}
$output .= ">";
$output .= "<a href=\"manage_content.php?subject=";
$output .= urlencode($subjects["id"]);
$output .= "\">";
$output .= $subjects['menu_name'];
$output .= "</a>";
$page_set = find_pages_for_subject($subjects["id"]);
$output .= "<ul class = \"pages\">";
while ($pages = mysqli_fetch_assoc($page_set)) {
$output .= "<li";
if ($pages["id"] == $page_id) {
$output .= " class=\"selected\"";
}
$output .= ">";
$output .= "<a href = \"manage_content.php?page=";
$output .= urlencode($pages["id"]);
$output .= "\">";
$output .= $pages['menu_name'];
$output .= "</a> </li>";
}
mysqli_free_result($page_set);
$output .= "</ul></li>";
}
mysqli_free_result($subject_set);
$output .= "</ul>";
return $output;
}
Visible: <?php
echo $current_subject["visible"] == 1 ? 'Yes' : 'No';
?>
<br />
<br />
<a href="edit_subject.php?subject=<?php
echo urlencode($current_subject["id"]);
?>
">Edit Subject</a>
<br />
<br />
<div class="page-info">
<h3>Pages in this subject</h3>
<ul>
<?php
$subject_pages = find_pages_for_subject($current_subject["id"], false);
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 a new page to this subject</a>
</h2>
<form action="edit_page.php?page=<?php
echo urlencode($current_page["id"]);
?>
" method="post" accept-charset="utf-8">
<p>Menu Name:<input type="text" name="menu_name" value="<?php
echo htmlentities($current_page["menu_name"]);
?>
"></p>
<p>Position:
<select name="position">
<?php
// so I find all the data from the database with my function
// then get the number of rows to have a max value for the for loop
// the for loop is going to make a bunch of option tags for the selection tag
$page_set = find_pages_for_subject($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 " selected";
}
echo ">{$count}</option>";
}
?>
</select>
</p>
<p>Visible:
<input type="radio" name="visible" value="0" <?php
if ($current_page["visible"] == 0) {
echo "checked";
function public_content_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_subject($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 public_navigation($subject_array, $page_array)
{
$output = "<ul class=\"subjects\">";
$subject_set = find_all_subjects();
// 3. Use returned data (if any)
while ($subject = mysqli_fetch_assoc($subject_set)) {
// output data from each row
$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>";
$page_set = find_pages_for_subject($subject["id"]);
$output .= "<ul class=\"pages\">";
// 3. Use returned data (if any)
while ($page = mysqli_fetch_assoc($page_set)) {
// output data from each row
$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>";
$output .= "</li>";
}
mysqli_free_result($page_set);
$output .= "</ul>";
$output .= "</li>";
}
// 4. Release returned data
mysqli_free_result($subject_set);
$output .= "</ul>";
return $output;
}
<?php
require_once "../includes/session.php";
require_once "../includes/db_connection.php";
require_once "../includes/functions.php";
confirm_logged_in();
?>
<?php
$current_subject = find_subject_by_id($_GET["subject"], false);
if (!$current_subject) {
// subject ID was missing or invalid or
// subject couldn't be found in database
redirect_to("manage_contenct.php");
}
$pages_set = find_pages_for_subject($current_subject["id"]);
if (mysqli_num_rows($pages_set) > 0) {
$_SESSION["message"] = "Can't delete a subject with pages.";
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) {
// Success
$_SESSION["message"] = "Subject deleted.";
redirect_to("manage_content.php");
} else {
// Failure
$_SESSION["message"] = "Subject deletion failed.";
redirect_to("manage_content.php?subject={$id}");
if ($subject["id"] == $selected_subject_id) {
echo " class=\"selected\"";
}
echo ">";
?>
<a href="manage_content.php?subject=<?php
echo $subject["id"];
?>
">
<?php
echo $subject["menu_name"];
?>
</a><ul class="pages">
<?php
$pages = find_pages_for_subject($subject["id"]);
while ($page = mysqli_fetch_assoc($pages)) {
?>
<?php
echo "<li";
if ($page["id"] == $selected_page_id) {
echo " class=\"selected\"";
}
echo ">";
?>
<a href="manage_content.php?page=<?php
echo $page["id"];
?>
">
<?php
<?php
echo form_errors($errors);
?>
<h2>Create Page</h2>
<form action="new_page.php?subject=<?php
echo urlencode($current_subject["id"]);
?>
" method="post">
<p>Menu name:
<input type="text" name="menu_name" value="" />
</p>
<p>Position:
<select name="position">
<?php
$page_set = find_pages_for_subject($current_subject["id"], false);
$page_count = mysqli_num_rows($page_set);
for ($count = 1; $count <= $page_count + 1; $count++) {
echo "<option value=\"{$count}\">{$count}</option>";
}
?>
</select>
</p>
<p>Visible:
<input type="radio" name="visible" value="0" /> No
<input type="radio" name="visible" value="1" /> Yes
</p>
<p>Content:<br />
<textarea name="content" rows="20" cols="80"></textarea>
</p>
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;
}
return null;
}
function navigation($subject_array, $page_array)
{
//current_subject/page = array or null
$output = "<ul class=\"subjects\">";
$subject_set = find_all_subjects(false);
while ($subject = mysqli_fetch_assoc($subject_set)) {
$output .= "<li";
if ($subject_array && $subject["id"] == $subject_array["id"]) {
$output .= " class=\"selected\"";
}
$output .= ">";
$output .= "<a href=\"manage_content.php?subject=";
$output .= urlencode($subject["id"]);
$output .= "\">";
$output .= htmlentities($subject["menu_name"]);
$output .= "</a>";
$page_set = find_pages_for_subject($subject["id"], false);
$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=\"manage_content.php?page=";
$output .= urlencode($page["id"]);
$output .= "\">";
$output .= htmlentities($page["menu_name"]);
$output .= "</a>";
$output .= "</li>";
}
$output .= "</ul>";
mysqli_free_result($page_set);
$output .= "</li>";
}
mysqli_free_result($subject_set);
$output .= "</ul>";
return $output;
}
