editlink.php

<?php

// Necessary phpCAS Setup files for RPI's system
require 'resources/functions.php';
require 'resources/config.php';
require 'resources/rpiCAS.php';

forceAuth();

// Establish a connection to the database for this page.
$conn = new PDO('mysql:host=localhost;dbname=slatecrate', $config['DB_USERNAME'], $config['DB_PASSWORD']);

function echoPostURL() {
    if(isset($_GET["class"])) {
        echo "links.php?class=" . $_GET["class"];
    } else {
        echo "links.php";
    }
}

$edit = $conn->prepare("SELECT * FROM `links` WHERE `link_id` = " . $_POST["edit"]);
$edit->execute();
$edit = $edit->fetch(PDO::FETCH_ASSOC);

require 'partials/head.partial.php';
require 'partials/navigation.partial.php';

$pageHeader = "Editing <i>".$edit["title"]."</i>";

require 'partials/pageheader.partial.php';
?>

<div class="container mtb">
    <div class="row">
        <div class="col-md-6 col-md-offset-3 col-sm-12 col-sm-offset-0">
            <div id="alertLocation"></div>
            <div class="well well-lg">
                <form method="post" action="links.php?class=<?php echo $edit["category_id"]; ?>" class="form-horizontal" id="linkAction">
                    <div class="form-group">
                        <label for="linkName" class="col-sm-3 control-label">
                            Link Name
                        </label>

                        <div class="col-sm-9">
                            <input type="text" class="form-control" name="linkName"
                                   id="linkName" value="<?php echo $edit["title"]; ?>">
                        </div>
                    </div>
                    <div class="form-group">
                        <label for="URL" class="col-sm-3 control-label">
                            Link URL
                        </label>

                        <div class="col-sm-9">
                            <input type="text" class="form-control" name="URL"
                                   id="URL" value="<?php echo $edit["link"]; ?>">
                        </div>
                    </div>
                    <?php
                        echo "<div class='form-group'>
                                 <label for='URL' class='col-sm-3 control-label'>
                                       Class
                                 </label>

                                <div class='col-sm-9'>
                                    <select id='classForAdd' class='form-control' name='classForAdd'>
                                        <option value='' disabled selected>Select a class (type to search)</option>";

                        $var = $conn->prepare("SELECT * FROM `categories` ORDER BY `prefix`");
                        $var->execute();
                        $results = $var->fetchAll(PDO::FETCH_ASSOC);
                        $prevPrefix = "";
                        foreach($results as $r) {
                            if($prevPrefix != $r['prefix'] || $prevPrefix == "") {
                                if($prevPrefix != "") {
                                    echo "</optgroup>";
                                }
                                echo "<optgroup label='" . $r['prefix'] . "'>";
                                $prevPrefix = $r['prefix'];
                            }
                            if($r["category_id"] != $edit["category_id"]){ echo "<option value='" . $r["category_id"] . "'>" . $r["title"] . "</option>"; }
                            else { echo "<option value='" . $r["category_id"] . "' selected>" . $r["title"] . "</option>"; }
                        }
                        echo "</optgroup>";

                        echo       "</select>
                                </div>
                             </div>";
                    ?>
                    <div class="form-group">
                        <div class="col-xs-12">
                            <button type="submit" class="btn btn-primary pull-right" name="edit" value="<?php echo $_POST["edit"]; ?>">
                                Submit
                            </button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>

<?php require 'partials/footer.partial.php'; ?>
<script src="assets/js/linkaction.js"></script>

</body>
</html>