diff options
Diffstat (limited to 'public/admin-category.php')
| -rw-r--r-- | public/admin-category.php | 33 |
1 files changed, 32 insertions, 1 deletions
diff --git a/public/admin-category.php b/public/admin-category.php index a899b00..b55e084 100644 --- a/public/admin-category.php +++ b/public/admin-category.php @@ -1,16 +1,47 @@ <!DOCTYPE html> <?php require "../lib/login.php"; ?> <?php if_privileged(PRIVILEGE_ADMIN, "/") ?> +<?php +$res = $cursor->query("select max(id)+1 as id from webs.category"); +$obj = $res->fetch_object(); +$new_id = $obj->id; +?> +<?php do { + if ($_SERVER['REQUEST_METHOD'] !== 'POST') break; + $name = $_POST['name']; + $parent = $_POST['parent']; + if (!$name) break; + if (!$parent) $parent = null; + + $statement = $cursor->prepare("insert into webs.category (`name`, `parent`) values (?, ?)"); + $statement->bind_param("si", $name, $parent); + $statement->execute(); +} while (false); ?> <html> <head> <?php include 'head.php' ?> <title>categorie toevoegen</title> + <link rel="stylesheet" href="admin.css"> </head> <body> <?php include 'navbar.php' ?> <div class="main limwidth"> <h2>categorie toevoegen</h2> - + <form action="/admin-category.php" method="post"> + <label for="id">ID (automatisch)</label> + <input id="id" type="text" disabled value="<?php echo $new_id; ?>"> + <label for="name">Naam</label> + <input id="name" name="name" type="text" placeholder="Naam"> + <label for="parent">Bovenliggende categorie</label> + <select id="parent" name="parent"> + <option value="0">(geen)</option> + <?php + $res = $cursor->query("select id, name from webs.category"); + while ($c = $res->fetch_object()) echo "<option value='$c->id'>$c->name</option>"; + ?> + </select> + <input id="submit" type="submit" value="Toevoegen"> + </form> </div> <?php include 'footer.php' ?> </body> |