function find_selected_pages($public = false)
{
global $current_subject;
global $current_page;
if (isset($_GET["subject"])) {
//use get request to get my subject id
$selected_subject_id = $_GET["subject"];
//get my subject details by id from the database
$current_subject = find_subject_by_id($selected_subject_id, $public);
$selected_page_id = null;
if ($current_subject && $public) {
$current_page = find_default_page_for_subject($current_subject["id"]);
} else {
$current_page = null;
}
} elseif (isset($_GET["page"])) {
$selected_subject_id = null;
$current_subject = null;
$selected_page_id = $_GET["page"];
$current_page = find_page_by_id($selected_page_id);
} else {
$selected_subject_id = null;
$current_subject = null;
$selected_page_id = null;
$current_page = null;
}
}
function find_selected_page()
{
global $current_subject;
global $current_page;
if (isset($_GET["subject"])) {
$current_subject = find_subject_by_id($_GET["subject"]);
$current_page = null;
} elseif (isset($_GET["page"])) {
$current_subject = null;
$current_page = find_page_by_id($_GET["page"]);
} else {
$current_subject = null;
$current_page = 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_page = find_page_by_id($_GET["page"], $public);
$current_subject = null;
} else {
$current_subject = null;
$current_page = null;
}
}
<?php
require_once "../../includes/sessions.php";
require_once "../../includes/db_connect.php";
require_once "../../includes/functions.php";
logged_in();
$current_page = find_page_by_id($_GET["page"]);
if (!$current_page) {
redirect_to("manage_content.php");
} else {
$id = $current_page["id"];
$delete_query = "DELETE FROM pages ";
$delete_query .= "WHERE id = {$id} ";
$delete_query .= "LIMIT 1";
$result = mysqli_query($connection, $delete_query);
if ($result && mysqli_affected_rows($connection) == 1) {
$_SESSION["message"] = "Subject deletion success.";
redirect_to("manage_content.php");
} else {
$_SESSION["message"] = "Subject deletion failed.";
redirect_to("manage_content.php?page={$id}");
}
}
//if (!$current_subject) {
<?php
require_once "../includes/session.php";
require_once "../includes/db_connection.php";
require_once "../includes/functions.php";
confirm_logged_in();
?>
<?php
$current_page = find_page_by_id($_GET["page"], false);
if (!$current_page) {
// page ID was missing or invalid or
// page couldn't be found in database
redirect_to("manage_content.php");
}
$id = $current_page["id"];
$query = "DELETE FROM pages WHERE id = {$id} LIMIT 1";
$result = mysqli_query($connection, $query);
if ($result && mysqli_affected_rows($connection) == 1) {
// Success
$_SESSION["message"] = "Page deleted.";
redirect_to("manage_content.php");
} else {
// Failure
$_SESSION["message"] = "Page deletion failed.";
redirect_to("manage_content.php?page={$id}");
}
<?php
require_once "../includes/session.php";
require_once "../includes/dbconnect.php";
require_once "../includes/functions.php";
?>
<?php
$current_page = find_page_by_id($_GET["page"], $public = false);
if (!$current_page) {
// if current subject was null or invalid
redirect_to("manage_content.php");
}
$id = $current_page["id"];
$query = "DELETE FROM pages WHERE id = {$id} LIMIT 1";
$result = mysqli_query($connection, $query);
if ($result && mysqli_affected_rows($connection) == 1) {
// Success
$_SESSION["message"] = "page Deleted .";
redirect_to("manage_content.php");
} else {
// failure
$_SESSION["message"] = "page Deletion failed .";
redirect_to("manage_content.php?page={$id}");
}
?>
function find_selected_page($public = false)
{
global $current_page;
global $current_subject;
if (isset($_GET["subject"])) {
// This is an associative array with all the database info
$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_page = null;
$current_subject = null;
}
}
?>
<h2>Manage Subject</h2>
<?php
$current_subject = find_subject_by_id($selected_subject_id);
?>
Menu name: <?php
echo $current_subject["menu_name"];
?>
<br />
<?php
} elseif ($selected_page_id) {
?>
<h2>Manage Page</h2>
<?php
$current_page = find_page_by_id($selected_page_id);
?>
Menu name: <?php
echo $current_page["menu_name"];
?>
<br />
<?php
} else {
?>
Please select a subject or a page.
<?php
}
?>
</div>
</div>
function find_selected_page_edit()
{
global $current_subject;
global $current_page;
if (isset($_GET['page'])) {
$current_page = find_page_by_id($_GET['page']);
$current_subject = null;
} else {
$current_subject = null;
$current_page = null;
}
}
<?php
require_once "includes/functions.php";
//Functions files
require_once "includes/db_connection.php";
//Including the database connection file
$sp = find_page_by_id($_GET["id"]);
$pages = find_pages();
?>
<aside class="main-sidebar">
<!-- sidebar: style can be found in sidebar.less -->
<section class="sidebar">
<!-- sidebar menu: : style can be found in sidebar.less -->
<ul class="sidebar-menu">
<?php
// Navigation: left bar - Complex!
while ($subject = mysqli_fetch_assoc($pages)) {
$output = " <li";
// start: li
if ($subject["id"] == $_GET["id"]) {
$output .= " class=\"active\"";
}
$output .= ">";
$output .= "<a href=\"";
$output .= urlencode($subject["page"]);
$output .= "?id=";
$output .= urlencode($subject["id"]);
$output .= "\">";
$output .= "<i class=\"";
$output .= $subject["icon"];
$output .= "\"></i>";
function find_selected_page($public = false)
{
global $current_subject;
global $current_page;
//instead of returning we can make it as a global variable
if (isset($_GET["subject"])) {
$current_subject = find_subject_by_id($_GET["subject"], $public);
if ($current_subject && $public) {
$current_page = default_page_for_subject($current_subject["id"]);
# default page for subject }
} else {
$current_page = null;
}
} elseif (isset($_GET["page"])) {
$current_page = find_page_by_id($_GET["page"], $public);
# for not displaying the invisible pages
$current_subject = null;
} else {
# for coming from admin page
$current_subject = null;
$current_page = null;
}
}
function find_selected_page()
{
global $current_subject;
// creating them in the global scope
global $current_page;
// creating them in the global scope
if (isset($_GET["subject"])) {
$current_subject = find_subject_by_id($_GET["subject"]);
$current_page = null;
} elseif (isset($_GET["page"])) {
$current_page = find_page_by_id($_GET["page"]);
$current_subject = null;
} else {
$current_subject = null;
$current_page = null;
}
}
