<?php
require_once "../includes/session.php";
require_once "../includes/db_connect.php";
require_once "../includes/functions.php";
include "../includes/layouts/admin-header.php";
?>
<?php
$current_subject = FindSubjectById($_GET["subject"], false);
if (!$current_subject) {
RedirectTo("manage_content.php");
}
$pages_set = PagesForSubjects($current_subject["id"], false);
if (mysqli_num_rows($pages_set) > 0) {
$_SESSION["message"] = "Can't delete subject with pages";
RedirectTo("manage_content.php?subject={$current_subject["id"]}");
}
$id = $current_subject["id"];
$query = "DELETE FROM subjects WHERE id = {$id} LIMIT 1";
$result = mysqli_query($db, $query);
if ($result && mysqli_affected_rows($db) == 1) {
$_SESSION["message"] = "Subject deleted.";
RedirectTo("manage_content.php");
} else {
$message = "Subject deletion failed";
RedirectTo("new_subject.php?subject={$id}");
}
?>
</h2>
<form action="edit_page.php?page=<?php
echo urlencode($current_page["id"]);
?>
" method="post">
<p>Page Name:
<input type="text" name="menu_name" value="<?php
echo $current_page["menu_name"];
?>
" />
</p>
<p>Position:
<select name="position">
<?php
$page_set = PagesForSubjects($current_page["subject_id"], false);
$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
function Navigation($subject_array, $page_array, $public = true)
{
$output = "<ul class=\"subjects\">";
if (!$public) {
$subject_set = FindAllSubjects(false);
} else {
$subject_set = FindAllSubjects(true);
}
while ($subject = mysqli_fetch_assoc($subject_set)) {
$output .= "<li";
if ($subject_array && $subject["id"] == $subject_array["id"]) {
$output .= " class=\"selected\" ";
}
$output .= ">";
if (!$public) {
$output .= "<a href=\"manage_content.php?subject=";
} else {
$output .= "<a href=\"page_content.php?subject=";
}
$output .= urlencode($subject["id"]);
$output .= "\">";
$output .= htmlentities($subject["menu_name"]);
$output .= "</a>";
if (!$public) {
$page_set = PagesForSubjects($subject["id"], false);
} else {
$page_set = PagesForSubjects($subject["id"], true);
}
$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 .= ">";
if (!$public) {
$output .= "<a href=\"manage_content.php?page=";
} else {
$output .= "<a href=\"page_content.php?page=";
}
$output .= urlencode($page["id"]);
$output .= "\">";
$output .= htmlentities($page["menu_name"]);
$output .= "</a></li>";
}
mysqli_free_result($page_set);
$output .= "</ul></li>";
}
mysqli_free_result($subject_set);
$output .= "</ul>";
return $output;
}
<?php
echo FormErrors($errors);
?>
<div>
<h2>Create Page</h2>
<form action="new_page.php?subject=<?php
echo urlencode($current_subject["id"]);
?>
" method="post">
<p>Page Name:
<input type="text" name="menu_name" value="" />
</p>
<p>Position:
<select name="position">
<?php
$page_position = PagesForSubjects($current_subject["id"], false);
$pages_count = mysqli_num_rows($page_position);
for ($i = 1; $i <= $pages_count + 1; $i++) {
echo "<option value=\"{$i}\">{$i}</option>";
}
?>
</select>
</p>
<p>Visible
<input type="radio" name="visible" value="0" /> No
 
<input type="radio" name="visible" value="1"/>Yes
</p>
<p><textarea rows="10" cols="50" name="content"></textarea></p>
<input type="submit" name="submit" value="Create Page" />
