Legenda:
index.php (de log in scherm)
session.php (dit checkt of de persoon die inlogt admin is)
planning.php (de ticket overzicht voor de user)
board.php (de ticket overzicht voor de admin)
user.php (de users overzicht voor de admin)
<?php
session_start();
$admin= $_GET['admin'];
if(isset($_POST['submit'])){
$subject = $_POST['subject'];
$content = $_POST['content'];
$type = $_POST['type'];
$db = mysqli_connect('localhost', 'root', '', 'qrp');
$sql = "INSERT INTO tickets (subject, content, type) VALUES ('$subject', '$content' , '$type')";
$result= mysqli_query($db, $sql);
mysqli_close($db);
if (isset($_SESSION['is_admin'])){
header("Location: board.php");
}
else {
header("Location: planning.php");
}
if (!isset($_POST['subject']) || $_POST['subject']=== ""){
$ok=false;
}
if (!isset($_POST['content']) || $_POST['content']=== ""){
$ok=false;
}
}
?>
<!DOCTYPE html>
<html>
<link href="css/style.css" type="text/css" rel="stylesheet">
<head>
</head>
<body>
<div class="wrapper">
<div class="banner">
<nav>
<a id="home-button" class="nav-buttons" href="planning.php">Quick Response Portal</a>
<?php
if ($_SESSION['is_admin']){
?>
<a class="nav-buttons" href="board.php">Board</a>
<a class="nav-buttons" href="user.php">Users</a>
<?php } else {?>
<a class="nav-buttons" href="planning.php">Planning</a>
<?php } ?>
<a id="sign-out" href="logout.php">Log Out</a>
</nav>
</div>
<?php if ($admin == 1){ ?>
<div class="form-frame-ticket-admin">
<form method="post" action="">
<div>
<p class="form-title">Add New Ticket</p>
</div>
<div class="subject">
<label class="label">Subject</label>
<input class="text-field" type="text" name="subject" size="" value="">
</div>
<div class="content">
<label class="label">Content</label>
<textarea class="text-field-big" name="content" datatype="CHAR" content=""></textarea>
</div>
<div class="type">
<label class="label">Type</label>
<select class="type-select" name="type">
<option value="Notification">Notification</option>
<option value="Instruction">Instruction</option>
<option value="Question">Question</option>
<option value="Request">Request</option>
</select>
<div class="status">
<label class="label">Status</label>
<select class="type-select" name="type">
<option value="Not Done">Not Done</option>
<option value="Pending">Pending</option>
<option value="In Progress">In Progress</option>
<option value="Done">Done</option>
</select>
</div>
</div>
<div class="submit">
<p class="fill-up2"></p>
<input class="login" type="submit" name="submit" value="Submit">
</div>
</form>
</div>
<?php } else { ?>
<div class="form-frame-ticket">
<form method="post" action="">
<div>
<p class="form-title">Edit Ticket</p>
</div>
<div class="subject">
<label class="label">Subject</label>
<input class="text-field" type="text" name="subject" size="" value="">
</div>
<div class="content">
<label class="label">Content</label>
<textarea class="text-field-big" name="content" datatype="CHAR" content=""></textarea>
</div>
<div class="type">
<label class="label">Type</label>
<select class="type-select" name="type">
<option value="Question">Question</option>
<option value="Request">Request</option>
</select>
</div>
<div class="submit">
<p class="fill-up2"></p>
<input class="login" type="submit" name="submit" value="Submit">
</div>
</form>
</div>
<?php } ?>
</div>
</body>
</html>