PHP find_page_by_id函数代码示例

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