blob: ef289bd0a2fd63146972bef9b02916691a3a246a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
<?php
require '../config.php';
require_once(TEMPLATES_PATH . "/header.php");
require_once(TEMPLATES_PATH . "/panel.php");
require_once(LIBRARY_PATH . "/functions.php");
if(!session_set()) {
header("Refresh: 2; URL={$config['urls']['base']}");
goto footer;
}
$id = isset($_GET['id']) ? $_GET['id'] : "";
$title = "";
$submitter = $_SESSION['user_name'];
$description = "";
if($id != "") {
$conn = new PDO($config['db']['dsn'], $config['db']['username'], $config['db']['password']);
$query = $conn->prepare("SELECT title, description, users.username AS submitter FROM reports
JOIN users ON reports.author=users.id
WHERE reports.id=:report_id");
$query->bindParam(':report_id', $id);
$query->execute();
$result = $query->fetch();
$title = $result['title'];
$submitter = $result['submitter'];
$description = $result['description'];
}
?>
<form action="update.php?id=<?php echo $id; ?>" method="post">
<input name="id" type="hidden" value="<?php echo $id; ?>">
<p>Title: <input name="title" type="text" value="<?php echo $title; ?>"></p>
<p>Submitted by: <?php echo $submitter; ?></p>
<p>Description: <br><textarea name="description" rows=25 cols=80><?php echo $description; ?></textarea></p>
<input type="submit" value="submit" >
</form>
<?php
footer: require_once(TEMPLATES_PATH . "/footer.php");
?>
|
