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'];
$ticket_id= $_GET['id'];
$db= mysqli_connect('localhost', 'root', '', 'qrp');
$sql = "SELECT * FROM tickets WHERE ticket_id= '$ticket_id'";
$result= mysqli_query($db, $sql);
$subject ='';
$content ='';
$type ='';
$status ='';
if(isset($_POST['submit'])){
$subject = $_POST['subject'];
$content = $_POST['content'];
$type = $_POST['type'];
$status=$_POST['status'];
$sql = "UPDATE tickets SET subject='$subject', content='$content', type='$type', status='$status' WHERE ticket_id='$ticket_id'";
$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;
}
}
if($row = mysqli_fetch_assoc($result)){
$rowsubject = $row['subject'];
$rowcontent = $row['content'];
$rowtype = $row['type'];
mysqli_close($db);
?>
<!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-button2" class="nav-buttons" href="planning.php">Quick Response Portal</a>
<?php
if ($admin = 1){
?>
<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 ($_SESSION['is_admin']){ ?>
<div class="form-frame-ticket-admin">
<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="<?= $rowsubject ?>">
</div>
<div class="content">
<label class="label">Content</label>
<textarea class="text-field-big" name="content" datatype="CHAR" ><?= $rowcontent ?></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="<?= $rowsubject ?>">
</div>
<div class="content">
<label class="label">Content</label>
<textarea class="text-field-big" name="content" datatype="CHAR" ><?= $rowcontent ?></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>
<?php }?>