Untitled

<html>
<head>
    <title>Admin Page | Alison Ryde's Photography</title>
    <link rel="stylesheet" type="text/css" href="../../css/style.css">
</head>
    <body>

        <h2>Insert a new image</h2><br>

        <form action="imagesInsert.php" method="POST" enctype="multipart/form-data">

            Name of Image: <input type="text" name="name" /><br>

            Date: <input type="text" name="dateTime" /><br>

            Caption: <input type="text" name="caption" /><br>

            Comment: <textarea type="text" name="comment" cols="40" rows="4"></textarea><br>

            Slideshow: <input type="text" name="slideshow" /><br>

            Choose an Album to place it in:

                <?php
                mysql_connect('localhost', 'root', '1k9i2n8gjd');
                mysql_select_db('admin_db');

                $sql = "SELECT albumName FROM album_tbl WHERE hidden = false";
                $result = mysql_query($sql); ?>

                <select name='albumName'>; <?php
                while ($row = mysql_fetch_array($result)) {
                    echo "<option value='" . $row['albumName'] . "'->" . $row['albumName'] . "</option>";
                }
                ?> </select>


            <input type="submit" name="submit"/><br>
        </form>


        <h2>Hide the Image</h2><br>

        <form action="imagesHidden.php" method="POST" enctype="multipart/form-data">

            Title:

                <?php
                mysql_connect('localhost', 'root', '1k9i2n8gjd');
                mysql_select_db('admin_db');

                $sql = "SELECT name FROM image_tbl WHERE hidden = false";
                $result = mysql_query($sql);

                echo "<select name='name'>";
                while ($row = mysql_fetch_array($result)) {
                    echo "<option value='" . $row['name'] . "'>" . $row['name'] . "</option>";
                }
                echo "</select>";
                ?>

                <input type="submit" value="Hide" name="submit">

        </form>


        <h2> Renew from Hidden Items </h2><br>

        <form action="imagesRestore.php" method="POST" enctype="multipart/form-data">

            Title:

                <?php
                mysql_connect('localhost', 'root', '1k9i2n8gjd');
                mysql_select_db('admin_db');

                $sql = "SELECT name FROM image_tbl WHERE hidden = true";
                $result = mysql_query($sql);

                echo "<select name='name'>";
                while ($row = mysql_fetch_array($result)) {
                    echo "<option value='" . $row['name'] . "'>" . $row['name'] . "</option>";
                }
                echo "</select>";
                ?>

                <input type="submit" value="Renew / Un-Hide" name="submit">

        </form>


    </body>
</html>