links::getLinkByName PHP Method

getLinkByName() public method

public getLinkByName ( $name )
    function getLinkByName($name)
    {
        require_once $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . "classes" . DIRECTORY_SEPARATOR . "settings.class.php";
        $settings = new settings();
        if ($settings::db_driver == "xml") {
            // XML
            $links = simplexml_load_file($_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . "data" . DIRECTORY_SEPARATOR . "links.xml");
            foreach ($links as $link) {
                if (strtolower($link->name) == strtolower($name)) {
                    return (array) $link;
                }
            }
        } else {
            // PDO
            require_once $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . "classes" . DIRECTORY_SEPARATOR . "common.class.php";
            $common = new common();
            $dbh = $common->pdoOpen();
            $sql = "SELECT * FROM " . $settings::db_prefix . "links WHERE name = :name";
            $sth = $dbh->prepare($sql);
            $sth->bindParam(':name', $name, PDO::PARAM_STR, 100);
            $sth->execute();
            $link = $sth->fetch(PDO::FETCH_ASSOC);
            $sth = NULL;
            $dbh = NULL;
            return $link;
        }
    }

Usage Example

Esempio n. 1
0
$common = new common();
$account = new account();
$links = new links();
// Check if the user is logged in.
if (!$account->isAuthenticated()) {
    // The user is not logged in so forward them to the login page.
    header("Location: login.php");
}
if ($common->postBack()) {
    // Update the contents of the blog post.
    $links->editLinkByName(urldecode($_POST['originalName']), $_POST['name'], $_POST['address']);
    // Forward the user to the link management index page.
    header("Location: /admin/links/");
}
// Get the link data.
$link = $links->getLinkByName(urldecode($_GET['name']));
////////////////
// BEGIN HTML
require_once $_SERVER['DOCUMENT_ROOT'] . DIRECTORY_SEPARATOR . "admin" . DIRECTORY_SEPARATOR . "includes" . DIRECTORY_SEPARATOR . "header.inc.php";
?>
            <h1>Links Management</h1>
            <hr />
            <h2>Edit Link</h2>
            <h3><?php 
echo $link['name'];
?>
</h3>
            <form id="edit-link" method="post" action="edit.php">
                <div class="form-group">
                    <label for="name">Name</label>
                    <input type="text" id="name" name="name" class="form-control" value="<?php